Jump to content
  • 0

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


Question

Posted
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...

3 answers to this question

Recommended Posts

  • 0
Posted

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

  • 0
Posted

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.

  • 0
Posted

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.

Guest
This topic is now closed to further replies.


  • Posts

    • The server has been online and stable for over 2 months now, and we’re still going strong! No wipes, no shortcuts ~ just continuous work, daily fixes, events, and improvements to ensure the best possible experience.   Great News! 🔥 CHAPTER II IS COMING — GRACIA FINAL 🔥 On February 16, L2Elixir enters a new era. The server will be officially updated to Gracia Final, opening Chapter II of our journey. Expect new content, improvements, and surprises that will refresh the gameplay while keeping the classic Gracia Final spirit alive.   More challenges, more competition, and more reasons to log in.   📅 Update Date: February 16 ⚔️ Chapter II: Gracia Final This is not a reset. This is evolution.   Prepare yourselves — Chapter II begins soon.   Website: https://l2elixir.org/ Discord: https://discord.gg/5ydPHvhbxs    
    • Server owners, Top.MaxCheaters.com is now live and accepting Lineage 2 server listings. There is no voting, no rankings manipulation, and no paid advantages. Visibility is clean and equal, and early listings naturally appear at the top while the platform grows. If your server is active, it should already be listed. Submit here 👉https://Top.MaxCheaters.com This platform is part of the MaxCheaters.com network and is being built as a long-term reference point for the Lineage 2 community. — MaxCheaters.com Team
    • Hello! We are Genesis, small team that works on new Lineage 2 project. Our goal with this project is to create a fresh new place to play — built around real community feedback, with no aggressive pay-to-win donations and with carefully thought-out quality-of-life improvements, balance changes etc. We believe that even tho we all love this game, everyone has at least one or two things they would like to change in the game to make it more enjoyable. Thats why we want the comunity feedback to shape our server. Main information about the server: • Interlude Classic version • Rates: EXP x4 SP x2 Loot x2, Spoil x2 (not set in stone, might be changed) • Local & Server-Side Dualbox Protection • Complete, Clear Website with Integrated Account Panel (Game account creation, direct communication with support, bug reporting, voting and reward system) • Launcher – External Game Login System: manage all your accounts inside the launcher, “Play” button logs you directly into the game server Here are list of few changes we already added/decided to add to the server: • Reworked Client to fit interlude Era with upgraded Classic Ui • Custom Antibot system • Custom AntiDualBox System • Offline shops • Offline shop with buffs (available only in towns) • Mass Sweeper added to the game • Newbie buffs available all the way to lvl 76 (nothing crazy, but its free) • Slight balance change to Destroyer damage with Polearm and Cancel spell from SPS • PvP zones on every Epic spawn spot • Overbuffing blocked • And more! Since we put big focus on community feedback and suggestions, we are looking for people for our internal tests, that will discuss whether current changes „fit” into the game and maybe suggest some changes themselves. If what you’ve just read sounds interesting to you, if you want to help creating server fitted for you, join our server Discord. Help us to understand what Lineage 2 players in 2026 actually expect and need — so we can meet those expectations and avoid becoming just another server that dies a natural death.     Even if you’re not interested in playing right now, but you are a long-time Lineage 2 player, feel free to join our community. We would greatly appreciate your experience and feedback to help us improve and develop our project. Join the growing L2Genesis community: https://discord.gg/mcuHsQzNCm Also check our website: https://l2genesis.com/
    • I messaged you privately. If you want me to help, message me privately.  
    • Hello guys I’m new here, also I’m new on those things I  don’t know anything about programming but I need some help about many things …I want to open a faction server  Firstly , I want to make a classic but with interlude staff like skills items level etc ..so is there any project server interlude -classic ..is there any interlude -classic client ?  what other server doing ?  can I go with interlude and add a patch-interface that will work for all people whos gonna join the server,  that will have inventory stats bars etc from classic , lobby create character ..etc and L2Fonts  for title and names also chat letters  like classic ?  I read about Lucera 2 has an interlude -classic client is it correct ? I also read about a multi protocol ..   also I saw that there is a lot of classic chronicles like 2.0 2.5 2.6 2.7 2.9.5 3.0  what are the differences    I know that the 3.0 add kamael which I don’t want    in conclusion.. I want full interlude staff but classic things    what should I do with client , server files  which is the way to go and with what files    if someone can answer me to all  sorry for my bad English 
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..