error in start server

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
gabrielhw
Posts: 77
Joined: Thu Jun 17, 2010 6:32 pm

error in start server

Post by gabrielhw »

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

Please help
What would this error?
And how to fix?

See attachmant pls

Code: Select all

 ...L2JMOD: Initializing CoupleManagerLoaded: 0 couples(s)Cannot add the unique task: Field 'id' doesn't have a default valuejava.sql.SQLException: Field 'id' doesn't have a default value    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)    at com.l2jserver.gameserver.taskmanager.TaskManager.addUniqueTask(TaskManager.java:354)    at com.l2jserver.gameserver.taskmanager.TaskManager.addUniqueTask(TaskManager.java:331)    at com.l2jserver.gameserver.taskmanager.tasks.TaskGlobalVariablesSave.initializate(TaskGlobalVariablesSave.java:63)    at com.l2jserver.gameserver.taskmanager.TaskManager.registerTask(TaskManager.java:190)    at com.l2jserver.gameserver.taskmanager.TaskManager.initializate(TaskManager.java:174)    at com.l2jserver.gameserver.taskmanager.TaskManager.<init>(TaskManager.java:165)    at com.l2jserver.gameserver.taskmanager.TaskManager.<init>(TaskManager.java:53)    at com.l2jserver.gameserver.taskmanager.TaskManager$SingletonHolder.<clinit>(TaskManager.java:425)    at com.l2jserver.gameserver.taskmanager.TaskManager.getInstance(TaskManager.java:160)    at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:389)    at com.l2jserver.gameserver.GameServer.main(GameServer.java:506) Cannot add the unique task: Field 'id' doesn't have a default valuejava.sql.SQLException: Field 'id' doesn't have a default value    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)    at com.l2jserver.gameserver.taskmanager.TaskManager.addUniqueTask(TaskManager.java:354)    at com.l2jserver.gameserver.taskmanager.TaskManager.addUniqueTask(TaskManager.java:331)    at com.l2jserver.gameserver.taskmanager.tasks.TaskRecom.initializate(TaskRecom.java:84)    at com.l2jserver.gameserver.taskmanager.TaskManager.registerTask(TaskManager.java:190)    at com.l2jserver.gameserver.taskmanager.TaskManager.initializate(TaskManager.java:177)    at com.l2jserver.gameserver.taskmanager.TaskManager.<init>(TaskManager.java:165)    at com.l2jserver.gameserver.taskmanager.TaskManager.<init>(TaskManager.java:53)    at com.l2jserver.gameserver.taskmanager.TaskManager$SingletonHolder.<clinit>(TaskManager.java:425)    at com.l2jserver.gameserver.taskmanager.TaskManager.getInstance(TaskManager.java:160)    at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:389)    at com.l2jserver.gameserver.GameServer.main(GameServer.java:506) Cannot add the unique task: Field 'id' doesn't have a default valuejava.sql.SQLException: Field 'id' doesn't have a default value    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)    at com.l2jserver.gameserver.taskmanager.TaskManager.addUniqueTask(TaskManager.java:354)    at com.l2jserver.gameserver.taskmanager.TaskManager.addUniqueTask(TaskManager.java:331)    at com.l2jserver.gameserver.taskmanager.tasks.TaskDailyQuestClean.initializate(TaskDailyQuestClean.java:93)    at com.l2jserver.gameserver.taskmanager.TaskManager.registerTask(TaskManager.java:190)    at com.l2jserver.gameserver.taskmanager.TaskManager.initializate(TaskManager.java:181)    at com.l2jserver.gameserver.taskmanager.TaskManager.<init>(TaskManager.java:165)    at com.l2jserver.gameserver.taskmanager.TaskManager.<init>(TaskManager.java:53)    at com.l2jserver.gameserver.taskmanager.TaskManager$SingletonHolder.<clinit>(TaskManager.java:425)    at com.l2jserver.gameserver.taskmanager.TaskManager.getInstance(TaskManager.java:160)    at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:389)    at com.l2jserver.gameserver.GameServer.main(GameServer.java:506) HellboundManager: Initializing... 
You do not have the required permissions to view the files attached to this post.
Last edited by gabrielhw on Mon Dec 20, 2010 12:18 pm, edited 1 time in total.
MELERIX FOR PRESIDENT
\O/
hope
Posts: 1160
Joined: Thu Aug 30, 2007 5:17 pm

Re: error in start server

Post by hope »

Install all tables correctly
gabrielhw
Posts: 77
Joined: Thu Jun 17, 2010 6:32 pm

Re: error in start server

Post by gabrielhw »

Can you tell me which table?
MELERIX FOR PRESIDENT
\O/
User avatar
Barthyczg
Posts: 28
Joined: Mon May 24, 2010 7:48 pm

Re: error in start server

Post by Barthyczg »

datapack/sql/mods/mods_wedding.sql
gabrielhw
Posts: 77
Joined: Thu Jun 17, 2010 6:32 pm

Re: error in start server

Post by gabrielhw »

Thanks a lot, for all help
MELERIX FOR PRESIDENT
\O/
Post Reply