error on login

[GentleJesus]

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)

[l2terror]

Hi,

And if a new char? same error?

[GentleJesus]

yes same error for new players

[Cresceus]

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.

[GentleJesus]

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

could not store char effect data

[Cresceus]

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

[GentleJesus]

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

[Cresceus]

It doesn't matter.

But the format does matter.

• int(11) NOT NULL DEFAULT '0'

[GentleJesus]

this prob is now fixed ty

[Cresceus]

you're welcome