C6 TradeController

[caioconc]

When starting the server this happens!

https://imgur.com/imYvWil

Code: [Select]

protected void dataTimerSave(int time)
{
final long timerSave = System.currentTimeMillis() + (time * 60 * 60 * 1000);
try (Connection con = DatabaseFactory.getConnection())
{
final PreparedStatement statement = con.prepareStatement("UPDATE merchant_buylists SET savetimer =? WHERE time =?");
statement.setLong(1, timerSave);
statement.setInt(2, time);
statement.executeUpdate();
statement.close();
}
catch (Exception e)
{
LOGGER.warning("TradeController: Could not update Timer save in Buylist");
}
}

[G-hamsteR]

I'm not having the same problem. Did you modify anything in your buylists?

[Mobius]

Add this

Code: [Select]

catch (Exception e)
{
e.printStackTrace();
LOGGER.warning("TradeController: Could not update Timer save in Buylist");
}

[spawnz]

Today the gameserver gave me this error.

Code: [Select]

   [27/09 12:47:12] TradeController: Could not update Timer save in Buylist
   [27/09 12:47:13] TradeController: Could not update Timer save in Buylist

[Mobius]

Double post, topics merged.

[spawnz]

When starting the server this happens!

https://imgur.com/imYvWil

Code: [Select]

protected void dataTimerSave(int time)
{
final long timerSave = System.currentTimeMillis() + (time * 60 * 60 * 1000);
try (Connection con = DatabaseFactory.getConnection())
{
final PreparedStatement statement = con.prepareStatement("UPDATE merchant_buylists SET savetimer =? WHERE time =?");
statement.setLong(1, timerSave);
statement.setInt(2, time);
statement.executeUpdate();
statement.close();
}
catch (Exception e)
{
LOGGER.warning("TradeController: Could not update Timer save in Buylist");
}
}

Yes The Same , Happens

[Mobius]

Add this

Code: [Select]

catch (Exception e)
{
e.printStackTrace();
LOGGER.warning("TradeController: Could not update Timer save in Buylist");
}

[warjoker]

Criticizes an error in the initial village! When you buy warrior armor! Similar problem with byulist. But it doesn't write the error in the logs.

[Mobius]

Code: [Select]

Index: java/org/l2jmobius/gameserver/TradeController.java
===================================================================
--- java/org/l2jmobius/gameserver/TradeController.java (revision 7672)
+++ java/org/l2jmobius/gameserver/TradeController.java (working copy)
@@ -462,7 +462,7 @@
  }
  catch (Exception e)
  {
- LOGGER.warning("TradeController: Could not update Timer save in Buylist");
+ LOGGER.warning("TradeController: Could not update Timer save in Buylist." + e);
  }
  }