Page 1 of 1

Unknown column 'sub_pledge_id' in 'field list'

Posted: Sat Dec 04, 2010 7:58 pm
by hiroshima
Well i made Freya update and during server start-up i get this warning:

Code: Select all

SEVERE: Error restoring clan skills: Unknown column 'sub_pledge_id' in 'field list'com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'sub_pledge_id' in 'field list'    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)    at java.lang.reflect.Constructor.newInstance(Unknown Source)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)    at com.mysql.jdbc.Util.getInstance(Util.java:384)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)    at com.l2jserver.gameserver.model.L2Clan.restoreSkills(L2Clan.java:1076)    at com.l2jserver.gameserver.model.L2Clan.restore(L2Clan.java:959)    at com.l2jserver.gameserver.model.L2Clan.<init>(L2Clan.java:187)    at com.l2jserver.gameserver.datatables.ClanTable.<init>(ClanTable.java:93)    at com.l2jserver.gameserver.datatables.ClanTable.<init>(ClanTable.java:56)    at com.l2jserver.gameserver.datatables.ClanTable$SingletonHolder.<clinit>(ClanTable.java:521)    at com.l2jserver.gameserver.datatables.ClanTable.getInstance(ClanTable.java:64)    at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:259)    at com.l2jserver.gameserver.GameServer.main(GameServer.java:512)Dec 4, 2010 8:43:38 PM com.l2jserver.gameserver.model.L2Clan restoreSubPledges
I Forget about something?

Re: Unknown column 'sub_pledge_id' in 'field list'

Posted: Sat Dec 04, 2010 9:03 pm
by hiroshima
bump ;P

Re: Unknown column 'sub_pledge_id' in 'field list'

Posted: Sat Dec 04, 2010 9:16 pm
by jurchiks
missed update sqls?

Re: Unknown column 'sub_pledge_id' in 'field list'

Posted: Sat Dec 04, 2010 9:50 pm
by hiroshima
yep but wondering which :/ since sub_pledge_id is in clan_subpledge .... looking for 2nd part

EDIT: clan_data and clan_subpledge have influence for it.... what else?

Re: Unknown column 'sub_pledge_id' in 'field list'

Posted: Sun Dec 05, 2010 2:04 am
by hiroshima
fixed. ;) from Freya clan_skills have 1 more row "sub_pledge_id".