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

[An4rchy]

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]

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™]

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]

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.