L2J Server

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 6466:
L2JDP Revision 10243:

I am getting this error whenever anyone logs into my server.

Could not store char effect data:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'remaining_time' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:118)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeEffect(L2PcInstance.java:7782)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7579)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeMe(L2PcInstance.java:7607)
at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:376)
at com.l2jserver.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:941)
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.runAndReset(FutureTask.java:304)
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:744)

Hi,

And if a new char? same error?

yes same error for new players

column 'remaining_time' is in the tables

• character_pet_skills_save
• character_skills_save
• character_summon_skills_save

Check this tables if in each there is the column 'remaining_time'.
If not, then you've found the thing what is causing the error.

also when player takes buffs there is another error very similar to the login error but starts with:

could not store char effect data

GentleJesus wrote:also when player takes buffs there is another error very similar to the login error but starts with:

could not store char effect data

Check the tables, please.

Guess you miss the column in character_skills_save

ok that column is not in those tables, does it matter what order the columns are in or can i just add it at the end

It doesn't matter.

But the format does matter.

• int(11) NOT NULL DEFAULT '0'

this prob is now fixed ty

you're welcome