Restore offline traders bug

Find the proper support area, Saga-Version.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
kimera1554
Posts: 29
Joined: Tue Oct 02, 2012 11:15 am

Restore offline traders bug

Post by kimera1554 »

my server is bug offlinetrader and fortress
» Find Revision
L2J Revision 61106:
L2JDP Revision 9869:

can not save OfflineTradersTable.

my config

Code: Select all

# Option to enable or disable offline trade feature.# Enable -> true, Disable -> falseOfflineTradeEnable = True # Option to enable or disable offline craft feature.# Enable -> true, Disable -> falseOfflineCraftEnable = True # If set to True, off-line shops will be possible only peace zones.# Default: FalseOfflineModeInPaceZone = False # If set to True, players in off-line shop mode wont take any damage, thus they cannot be killed.# Default: FalseOfflineModeNoDamage = False # If set to True, name color will be changed then entering offline modeOfflineSetNameColor = False # Color of the name in offline mode (if OfflineSetNameColor = True)OfflineNameColor = 808080 # Allow fame for characters in offline mode# Enable -> true, Disable -> falseOfflineFame = True #Restore offline traders/crafters after restart/shutdown. Default: false.RestoreOffliners = True #Do not restore offline characters, after OfflineMaxDays days spent from first restore.#Require server restart to disconnect expired shops.#0 = disabled (always restore).#Default: 10OfflineMaxDays = 7  #Disconnect shop after finished selling, buying.#Default: TrueOfflineDisconnectFinished = True
Error

Code: Select all

OfflineTradersTable: Loading offline traders...Exception in thread "main" java.lang.Error: Unable to determine localhost address.    at com.l2jserver.gameserver.network.L2GameClient.<init>(L2GameClient.java:148)    at com.l2jserver.gameserver.datatables.OfflineTradersTable.restoreOfflineTraders(OfflineTradersTable.java:178)    at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:397)    at com.l2jserver.gameserver.GameServer.main(GameServer.java:486)
And Fortress bug

Code: Select all

Exception: ScheduleEndSiegeTask() for Fort: Ivory nulljava.lang.NullPointerException    at com.l2jserver.gameserver.model.entity.FortSiege.endSiege(FortSiege.java:268)    at com.l2jserver.gameserver.model.entity.FortSiege$ScheduleEndSiegeTask.run(FortSiege.java:94)    at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:93)    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)    at java.util.concurrent.FutureTask.run(FutureTask.java:166)    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)    at java.lang.Thread.run(Thread.java:724) 

Code: Select all

java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:823)    at cz.nxs.events.engine.EventBuffer.storeData(EventBuffer.java:376)    at cz.nxs.events.engine.EventBuffer.access$100(EventBuffer.java:29)    at cz.nxs.events.engine.EventBuffer$DataUpdater.run(EventBuffer.java:523)    at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:93)    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)    at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)    at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)    at java.lang.Thread.run(Thread.java:724) 
Thank.
User avatar
UnAfraid
L2j Veteran
L2j Veteran
Posts: 4199
Joined: Mon Jul 23, 2007 4:25 pm
Location: Bulgaria
Contact:

Re: Restore offline traders bug

Post by UnAfraid »

Turn your table's collation to utf8_general_ci.
Check your hosts file if has 127.0.0.1 locahost (for linux /etc/hosts)
Image
kimera1554
Posts: 29
Joined: Tue Oct 02, 2012 11:15 am

Re: Restore offline traders bug

Post by kimera1554 »

UnAfraid wrote:Turn your table's collation to utf8_general_ci.
Check your hosts file if has 127.0.0.1 locahost (for linux /etc/hosts)
it error

Code: Select all

OfflineTradersTable: Loading offline traders...Exception in thread "main" java.lang.Error: Unable to determine localhost address.    at com.l2jserver.gameserver.network.L2GameClient.<init>(L2GameClient.java:148)    at com.l2jserver.gameserver.datatables.OfflineTradersTable.restoreOfflineTraders(OfflineTradersTable.java:178)    at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:397)    at com.l2jserver.gameserver.GameServer.main(GameServer.java:486) 
my server centos 5.9
/etc/host

Code: Select all

127.0.0.1   localhost
command #hostname

Code: Select all

CAT481.xxxx.NET 
Post Reply