Bug report moved to the new portal: Mmore.club
Detailed info: L2-scripts.com
Skype: Urchika

Our portfolio of solved reports: High Five
Our portfolio of solved reports: GOD
Our portfolio of solved reports: Classic

This forum is closed and open for viewing our work on bug reports for a long time. Thank you all !


L2-scripts Форум / Для наших клиентов / Archive Lindvior, Ertheia, Odyssey, Undergeround, Helios, Grand Crusade / : Unknown column 'id' in 'where clause' (NOT RELEVANT)
Закрытая тема
 
Опции темы Опции просмотра
Старый 01.08.2016, 13:24   #1
l2gold
Клиент Расширенка Crusade, + Classic 2.5 + svn + New GEO
 
Регистрация: 13.04.2012
Сообщений: 2,226
По умолчанию : 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
l2gold вне форума  
Старый 01.08.2016, 13:27   #2
Scorpius
Спонсор Арены
 
Аватар для Scorpius
 
Регистрация: 14.06.2013
Адрес: Норильск
Сообщений: 2,876
Отправить сообщение для Scorpius с помощью Skype™
По умолчанию
Скачай с SVN ResidenceFunction.sql и перебей ее в базе
__________________
http://forum.l2-scripts.ru/image.php?type=sigpic&userid=947&dateline=1423019797
Scorpius вне форума  
Старый 01.08.2016, 13:29   #3
l2gold
Клиент Расширенка Crusade, + Classic 2.5 + svn + New GEO
 
Регистрация: 13.04.2012
Сообщений: 2,226
По умолчанию
недавно появилась
сначала когда обновлялся не было этой ошибки

такая же и на ундерграунде.
l2gold вне форума  
Старый 01.08.2016, 13:30   #4
l2gold
Клиент Расширенка Crusade, + Classic 2.5 + svn + New GEO
 
Регистрация: 13.04.2012
Сообщений: 2,226
По умолчанию
недавно появилась
сначала когда обновлялся не было
может какую хрень купили в игре

на андеграунде тоже лезет ошибка эта
l2gold вне форума  
Старый 01.08.2016, 13:37   #5
l2gold
Клиент Расширенка Crusade, + Classic 2.5 + svn + New GEO
 
Регистрация: 13.04.2012
Сообщений: 2,226
По умолчанию
Цитата:
Скачай с SVN ResidenceFunction.sql и перебей ее в базе

удалил таблицу и заново создал - пропала ошибка. но все равно не дело
l2gold вне форума  
Старый 01.12.2016, 09:20   #6
Scorpius
Спонсор Арены
 
Аватар для Scorpius
 
Регистрация: 14.06.2013
Адрес: Норильск
Сообщений: 2,876
Отправить сообщение для Scorpius с помощью Skype™
По умолчанию
Неактуально.
__________________
http://forum.l2-scripts.ru/image.php?type=sigpic&userid=947&dateline=1423019797
Scorpius вне форума  
Закрытая тема

« Предыдущая тема | Следующая тема »

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения
BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход


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

Обратная связь - L2-scripts.ru Разработка скриптов для Lineage 2 - Архив - Вверх

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