L2-scripts Форум

L2-scripts Форум (http://l2-scripts.ru/forum/index.php)
-   Archive Lindvior, Ertheia, Odyssey, Undergeround, Helios, Grand Crusade (http://l2-scripts.ru/forum/forumdisplay.php?f=103)
-   -   : Unknown column 'id' in 'where clause' (NOT RELEVANT) (http://l2-scripts.ru/forum/showthread.php?t=7014)

l2gold 01.08.2016 13:24
: Unknown column 'id' in 'where clause' (NOT RELEVANT)
 
[12:19:18] INFO =================================================
[12:19:18] INFO Project Revision: ........ L2s [23113]
[12:19:18] INFO Build Revision: .......... 8710
[12:19:18] INFO Update: .................. Epic Tale of Aden: Infinite of Odyssey
[12:19:18] INFO Build date: .............. 2016.07.27 18:57
[12:19:18] INFO Compiler version: ........ 1.8.0_101-b13 (Oracle Corporation)
[12:19:18] INFO =================================================

Код:
[12:20:10]  INFO =[Events]=========================================
[12:20:10] ERROR Cannot update rent time:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'id' in 'where clause'
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
    at com.mysql.jdbc.Util.getInstance(Util.java:372)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2145)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2081)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2066)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2s.gameserver.model.entity.residence.ResidenceFunction.updateRentTime(ResidenceFunction.java:94)
    at l2s.gameserver.model.entity.residence.Residence.startAutoTaskForFunction(Residence.java:456)
    at l2s.gameserver.model.entity.residence.Residence.loadFunctions(Residence.java:288)
    at l2s.gameserver.model.entity.residence.ClanHall.init(ClanHall.java:29)
    at l2s.gameserver.model.entity.residence.AuctionClanHall.init(AuctionClanHall.java:45)
    at l2s.gameserver.data.xml.holder.ResidenceHolder.callInit(ResidenceHolder.java:121)
    at l2s.gameserver.GameServer.<init>(GameServer.java:308)
    at l2s.gameserver.GameServer.main(GameServer.java:459)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at ru.akumu.smartguard.SmartGuard.main(SmartGuard.java:327)
[12:20:10] ERROR Cannot update rent time:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'id' in 'where clause'
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
    at com.mysql.jdbc.Util.getInstance(Util.java:372)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2145)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2081)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2066)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2s.gameserver.model.entity.residence.ResidenceFunction.updateRentTime(ResidenceFunction.java:94)
    at l2s.gameserver.model.entity.residence.Residence.startAutoTaskForFunction(Residence.java:456)
    at l2s.gameserver.model.entity.residence.Residence.loadFunctions(Residence.java:288)
    at l2s.gameserver.model.entity.residence.ClanHall.init(ClanHall.java:29)
    at l2s.gameserver.model.entity.residence.AuctionClanHall.init(AuctionClanHall.java:45)
    at l2s.gameserver.data.xml.holder.ResidenceHolder.callInit(ResidenceHolder.java:121)
    at l2s.gameserver.GameServer.<init>(GameServer.java:308)
    at l2s.gameserver.GameServer.main(GameServer.java:459)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at ru.akumu.smartguard.SmartGuard.main(SmartGuard.java:327)
[12:20:10] ERROR Cannot update rent time:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'id' in 'where clause'
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
    at com.mysql.jdbc.Util.getInstance(Util.java:372)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2145)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2081)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2066)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2s.gameserver.model.entity.residence.ResidenceFunction.updateRentTime(ResidenceFunction.java:94)
    at l2s.gameserver.model.entity.residence.Residence.startAutoTaskForFunction(Residence.java:456)
    at l2s.gameserver.model.entity.residence.Residence.loadFunctions(Residence.java:288)
    at l2s.gameserver.model.entity.residence.ClanHall.init(ClanHall.java:29)
    at l2s.gameserver.model.entity.residence.AuctionClanHall.init(AuctionClanHall.java:45)
    at l2s.gameserver.data.xml.holder.ResidenceHolder.callInit(ResidenceHolder.java:121)
    at l2s.gameserver.GameServer.<init>(GameServer.java:308)
    at l2s.gameserver.GameServer.main(GameServer.java:459)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at ru.akumu.smartguard.SmartGuard.main(SmartGuard.java:327)
[12:20:10] ERROR Cannot update rent time:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'id' in 'where clause'
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
    at com.mysql.jdbc.Util.getInstance(Util.java:372)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2145)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2081)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2066)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2s.gameserver.model.entity.residence.ResidenceFunction.updateRentTime(ResidenceFunction.java:94)
    at l2s.gameserver.model.entity.residence.Residence.startAutoTaskForFunction(Residence.java:456)
    at l2s.gameserver.model.entity.residence.Residence.loadFunctions(Residence.java:288)
    at l2s.gameserver.model.entity.residence.ClanHall.init(ClanHall.java:29)
    at l2s.gameserver.model.entity.residence.AuctionClanHall.init(AuctionClanHall.java:45)
    at l2s.gameserver.data.xml.holder.ResidenceHolder.callInit(ResidenceHolder.java:121)
    at l2s.gameserver.GameServer.<init>(GameServer.java:308)
    at l2s.gameserver.GameServer.main(GameServer.java:459)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at ru.akumu.smartguard.SmartGuard.main(SmartGuard.java:327)
[12:20:10]  INFO CastleSiegeEvent: Gludio Castle time - 20:00 07.08.2016
[12:20:10]  INFO CastleSiegeEvent: Dion Castle time - 20:00 07.08.2016
[12:20:10]  INFO CastleSiegeEvent: Giran Castle time - 20:00 07.08.2016

Scorpius 01.08.2016 13:27
Скачай с SVN ResidenceFunction.sql и перебей ее в базе

l2gold 01.08.2016 13:29
недавно появилась
сначала когда обновлялся не было этой ошибки

такая же и на ундерграунде.

l2gold 01.08.2016 13:30
недавно появилась
сначала когда обновлялся не было
может какую хрень купили в игре

на андеграунде тоже лезет ошибка эта

l2gold 01.08.2016 13:37
Цитата:
Скачай с SVN ResidenceFunction.sql и перебей ее в базе

удалил таблицу и заново создал - пропала ошибка. но все равно не дело

Scorpius 01.12.2016 09:20
Неактуально.


Часовой пояс GMT +4, время: 23:28.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd. Перевод: zCarot