[Help]Error with l2jarchid. Doesn't give items to new chars and error on gs...

An4rchy · December 17, 2010

Could not restore item 268478769 from DB:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'bindId' in

'field list'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:1313)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:

1448)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr

oxyPreparedStatement.java:76)

at com.l2jarchid.gameserver.model.L2ItemInstance.restoreFromDb(L2ItemIns

tance.java:955)

at com.l2jarchid.gameserver.model.inventory.Inventory.restore(Inventory.

java:1394)

at com.l2jarchid.gameserver.model.inventory.PcInventory.restore(PcInvent

ory.java:531)

at com.l2jarchid.gameserver.model.actor.L2Player.<init>(L2Player.java:90

5)

at com.l2jarchid.gameserver.model.actor.L2Player.restore(L2Player.java:5

876)

at com.l2jarchid.gameserver.model.actor.L2Player.load(L2Player.java:858)

at com.l2jarchid.gameserver.network.L2GameClient.loadCharFromDisk(L2Game

Client.java:447)

at com.l2jarchid.gameserver.network.clientpackets.CharacterSelected.runI

mpl(CharacterSelected.java:87)

at com.l2jarchid.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:86)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source

)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Could not restore item 268478768 from DB:

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'bindId' in

'field list'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:1313)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:

1448)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr

oxyPreparedStatement.java:76)

at com.l2jarchid.gameserver.model.L2ItemInstance.restoreFromDb(L2ItemIns

tance.java:955)

at com.l2jarchid.gameserver.model.inventory.Inventory.restore(Inventory.

java:1394)

at com.l2jarchid.gameserver.model.inventory.PcInventory.restore(PcInvent

ory.java:531)

at com.l2jarchid.gameserver.model.actor.L2Player.<init>(L2Player.java:90

5)

at com.l2jarchid.gameserver.model.actor.L2Player.restore(L2Player.java:5

876)

at com.l2jarchid.gameserver.model.actor.L2Player.load(L2Player.java:858)

at com.l2jarchid.gameserver.network.L2GameClient.loadCharFromDisk(L2Game

Client.java:447)

at com.l2jarchid.gameserver.network.clientpackets.CharacterSelected.runI

mpl(CharacterSelected.java:87)

at com.l2jarchid.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:86)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source

)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Could not restore item 268478767 from DB:

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'bindId' in

'field list'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:1313)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:

1448)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr

oxyPreparedStatement.java:76)

at com.l2jarchid.gameserver.model.L2ItemInstance.restoreFromDb(L2ItemIns

tance.java:955)

at com.l2jarchid.gameserver.model.inventory.Inventory.restore(Inventory.

java:1394)

at com.l2jarchid.gameserver.model.inventory.PcInventory.restore(PcInvent

ory.java:531)

at com.l2jarchid.gameserver.model.actor.L2Player.<init>(L2Player.java:90

5)

at com.l2jarchid.gameserver.model.actor.L2Player.restore(L2Player.java:5

876)

at com.l2jarchid.gameserver.model.actor.L2Player.load(L2Player.java:858)

at com.l2jarchid.gameserver.network.L2GameClient.loadCharFromDisk(L2Game

Client.java:447)

at com.l2jarchid.gameserver.network.clientpackets.CharacterSelected.runI

mpl(CharacterSelected.java:87)

at com.l2jarchid.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:86)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source

)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Could not restore item 268478766 from DB:

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'bindId' in

'field list'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:1313)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:

1448)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr

oxyPreparedStatement.java:76)

at com.l2jarchid.gameserver.model.L2ItemInstance.restoreFromDb(L2ItemIns

tance.java:955)

at com.l2jarchid.gameserver.model.inventory.Inventory.restore(Inventory.

java:1394)

at com.l2jarchid.gameserver.model.inventory.PcInventory.restore(PcInvent

ory.java:531)

at com.l2jarchid.gameserver.model.actor.L2Player.<init>(L2Player.java:90

5)

at com.l2jarchid.gameserver.model.actor.L2Player.restore(L2Player.java:5

876)

at com.l2jarchid.gameserver.model.actor.L2Player.load(L2Player.java:858)

at com.l2jarchid.gameserver.network.L2GameClient.loadCharFromDisk(L2Game

Client.java:447)

at com.l2jarchid.gameserver.network.clientpackets.CharacterSelected.runI

mpl(CharacterSelected.java:87)

at com.l2jarchid.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:86)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source

)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Could not restore item 268478765 from DB:

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'bindId' in

'field list'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:1313)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:

1448)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr

oxyPreparedStatement.java:76)

at com.l2jarchid.gameserver.model.L2ItemInstance.restoreFromDb(L2ItemIns

tance.java:955)

at com.l2jarchid.gameserver.model.inventory.Inventory.restore(Inventory.

java:1394)

at com.l2jarchid.gameserver.model.inventory.PcInventory.restore(PcInvent

ory.java:531)

at com.l2jarchid.gameserver.model.actor.L2Player.<init>(L2Player.java:90

5)

at com.l2jarchid.gameserver.model.actor.L2Player.restore(L2Player.java:5

876)

at com.l2jarchid.gameserver.model.actor.L2Player.load(L2Player.java:858)

at com.l2jarchid.gameserver.network.L2GameClient.loadCharFromDisk(L2Game

Client.java:447)

at com.l2jarchid.gameserver.network.clientpackets.CharacterSelected.runI

mpl(CharacterSelected.java:87)

at com.l2jarchid.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:86)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source

)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

This is the error. It doesn't give items to players except from magic flute and magic gem. :S help me please...

Akken · December 17, 2010

1st this pack sucks it is not the only error you will see nobless isnt working.. clan ally/create isnt working... Varka mobs got lol skills

secondly the fix is here:

alter table items add COLUMN bindId int

write it on a txt file and execute it as an sql t the db

Coyote™ · December 17, 2010

Archid has been private since.. Woah, long time ago.. Which means that you can't ask for support, since it is considered as 'dead' for the public.

Locked.

Matim · December 17, 2010

Unlocked just to note:

My advice is to not use "premium archid", its really bugged, lot of missed files etc.

A lot of errors, npe's etc.

About this fix from Akken, as I remember this bindId field is not even used, so it would be better to delete it.

As I remember (but im not sure, because it was 3 months ago when i was trying for fix whole premium archid)

L2ItemInstance.java

Find this line:

PreparedStatement statement = con.prepareStatement("SELECT owner_id, object_id, item_id, count, enchant_level, loc, loc_data, price_sell, price_buy, custom_type1, custom_type2, mana_left, bindId FROM items WHERE object_id = ?");

And remove bindId marked with yellow color.

Should be fine now.

Locked again.

[Help]Error with l2jarchid. Doesn't give items to new chars and error on gs...

Question

An4rchy

3 answers to this question

Recommended Posts

Akken

Coyote™

Matim

Posts

Topics

Browse

Activity

Store

Important Information