Jump to content
MaxCheaters Official Group on Discord
--> Place your ad text here <--
  • 0

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

An4rchy

Asked by An4rchy,

 Share

Question

An4rchy Experienced

An4rchy

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

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0
Akken Newbie

Akken

Posted
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

Link to comment
Share on other sites
  • 0
Coyote™ Newbie

Coyote™

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

Link to comment
Share on other sites
  • 0
Matim Newbie

Matim

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

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to question listing


  • Posts

    • MarGaZeaS
      VPS with assisted L2J installing

      By MarGaZeaS · Posted

      send me dm to help you
    • Alo2alo2
      Help with folder system!

      By Alo2alo2 · Posted

      I can use this folder system for High Five offline server?   The folder does not have a l2.exe file.   Thank you very much if anyone can help me.   https://drive.google.com/file/d/13kU-g_4JJ-sP-kg2F7pqkUOVKmQdubFm/view
    • elcardiano
      VPS with assisted L2J installing

      By elcardiano · Posted

      I know, but...every time I have problem with IP address setup 😞
    • l2-scripts
      L2-Scripts Packs: (388 Essence, Classic, GOD ) [28/01/23]

      By l2-scripts · Posted

      ENGLISH As you know, we have always profiled in the development of Java emulators, we continue to do our favorite thing, and now we have the opportunity to provide you with services in the field of private development of L2 assemblies Essence, Classic and High Five, which we have been doing in recent years, we have not been working on basic builds for a long time and work only on contracts for the world's best projects. These are the best builds we can offer, we have test servers and we can show them to you on the test, and if you are very good at gameplay, you will see a big difference in the quality and detail of the official content compared to the basic builds. These are the best top solutions in the world, which are currently used to implement the largest projects in the world. We guarantee 100% implementation of all official content. If you have any questions about testing, discussions, etc., please contact our studio and we will discuss everything. At the moment, you can get acquainted with the preliminary information and prices for Private L2 contracts here: Private Server packs L2 Essence 464, 447, 388, 362, 286 protocols Private server packs L2Classic Private server pack High Five РУССКИЙ --------------------------------------------- Как вы знаете мы всегда профилировались на разработке в сфере Java эмуляторов, мы продолжаем заниматься своим любимым делом, и сейчас у нас появилась возможность предоставлять вам услуги в сфере приватных разработок L2 сборок Essence, Classic и High Five, которыми мы занимаемся последние годы, мы уже давно не работаем над базовыми сборками и работаем только на контрактах для лучших мировых проектов. Это лучшие сборки, которые мы можем предложить, у нас есть тестовые сервера, и мы можем показать их вам на тесте, и если вы очень хорошо разбираетесь в игровом процессе, вы увидите большую разницу в качестве и детализации официального контента по сравнению с базовыми сборками. Это лучшие топовые решения в мире, которые на данный момент используются для реализации крупнейших проектов в мире. Мы даем гарантии - 100% реализации всего официального контента. По вопросам тестирования, обсуждений и тд - пишите по контактам нашей студии и мы все обсудим. На данный момент вы можете ознакомиться с предварительной информацией и ценами на Приватные контракты L2 тут: Приватные Сборки L2 Essence 464, 447, 388, 362, 286 protocols Приватные Сборки L2Classic Приватная Сборка High Five -------------------------------------------------------------- Contacts: Telegram: https://t.me/L2scripts Whatsapp, Viber: +1 (916) 226 1910 С уважением, Администрация !
    • wongerlt
      Save ACC on login

      By wongerlt · Posted

      I can sell it. If you are interested just pm.

  • Topics

×
×
  • Create New...