Jump to content
  • 0

[Request] I can't add custom items on my l2jdatabase succefully


Question

Posted

hi Devs,i started a server just yesterday so i am a newbie developer..i have a gracia final server with datapack version=6705 and server version=3614...the problem is that:when i run batch file to add a custom item..i click start but it doesnt add succefully and give me error like :"[Err] 1136 - Column count doesn't match value count at row 1

[Err] INSERT INTO `armor` VALUES ('9813', 'Epic Mask', 'face', 'false', 'none', '1', 'leather', 's', '0', '-1', '0', '0', '500', '48000000', '0', 'true', 'true', 'true', 'true', '0', '0');

[Msg] Finished - Unsuccessfully"...i asked for example Drogata and he thinks that maybe the custom items are not for my datapack..but HOW CAN BE?i have the latest datapack version..what i have to do?i tryied with weapons also and i get this:"[Err] 1136 - Column count doesn't match value count at row 1

[Err] -- ---------------------------

-- By Legollas

-- ---------------------------

INSERT INTO `weapon` VALUES ('99000', 'Hard Blade - Haste', 'rhand', 'true', '1300', '1', '1', 'adamantaite', 's', '281', '10', 'sword', '8', '0.00000', '0', '0', '0', '379', '0', '132', '-1', '-1', '48800000', '2052', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '9365', '3564-1;');

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

help me guys..Regards

 

Cloud;)

Recommended Posts

  • 0
Posted

as i said i am a newbie developer?can u say me what i have to cancel/add?maybe i must remove "set into ..etc and leave only id,material etc"..hope u understand,thx u

  • 0
Posted

try this

INSERT INTO `armor` VALUES ('9813', 'Epic Mask', 'face', 'false', 'none', '1', 'leather', 's', '0', '-1', '0', '0', '500', '48000000', '0', 'true', 'true', 'true', 'true', '0-0', '0-0;');

  • 0
Posted

sorry but that was fail replies for real just when you will try again to install the sql files on your navicat press Continue On Errors if it still show you an error listen what you need to do if it's that

[Err] INSERT INTO `armor` VALUES ('9813',       

go in armor table search for this ID 9813 if already exist change it save it on your navicat and then try to put them again

you will make the same thing with INSERT INTO `weapon` VALUES ('99000'

  • 0
Posted

uhm..is so strange i checked for weapon and armor and i dont have a item with ID "9813" and"99000"...but i get still this error..what i have to do?maybe i get this error because the first time i installed a wrong datapack and i needed to download the right one..maybe it still have the old datapack even if i installed the new and i get this error?..i am really confused,i get this error with L2J Database Editor(DragonHunter) too

  • 0
Posted

i did it now and i added a epic mask as item id 9813 and it worked..but is normal that i dont see it on armor values?(i putted it here with batch file)...

  • 0
Posted

There's nothing like a batch here lol..

Right click on the mysql table (in navicat) then choose Console.

But in your code it seems the insert doesn't match your columns.

Track / follow the columns within' your code and delete/add the missing ones ,so it could match.

  • 0
Posted

There's nothing like a batch here lol..

yes right wrong type>_<...anyway my problem is that:i fixed the values and i added it succefully..but i cant see it on armor table and if i try to add again i get this error:"[Err] 1062 - Duplicate entry '9813' for key 'PRIMARY'" i think he says that i already have a item with 9813 ID..but where is it?
  • 0
Posted

uhm..is strange..what u sayd work but..my last item on armor table is 9126 but this custom item have id 9813:(...where the hell it is..i rly love developing server but..it gives much problems:(

 

edit:problem fixed..i just changed the id:)

Guest
This topic is now closed to further replies.


  • Posts

    • And Discord: https://discord.gg/3aYqWNqb
    • Ofc: https://discord.gg/3aYqWNqb
    • You can find some H5 skins shared in old L2 modding Discords, but most of the higher‑quality ones are either paid or come bundled with full client edits. I usually mix in commissioned work and whatever I can patch myself. On a side note, I fund a lot of these commissions by selling off game items through instant sell cs2 skins, which has been a quick way for me to get some cash for projects.
    • There is no need for gRPC in this case, even tho originally it was gRPC based but since we don't need it to be bi-directional, we switched to simple http requests for the web calls and SSEs for the data streamed from the server. There are distributed locks in place to precent race conditions between actions that can happen between multiple web instances and the server.   Local models can also be slow depending on the model, and most external models can actually be faster than local ones if you use Flash 2.5 or something along those lines. I am running on 512GB of Unified Memory on my Mac Studio M3 Ultra so the speed of the local model for a small model is pretty good but I tested it with Gemini too and it works equally as fast and in some cases faster. The way it works is that I'm using pgvector (one of the benefits of moving to Postgres) to search the data and see what the player can see etc and there is some batching of the next few actions for 2-4 seconds for the user until the next LLM request fires. The batching also includes branching on logic so if they for example fall under some HP they will move to kiting instead of attacking or maybe they heal etc.   Everything is authed and permission-based. The server and the backend of the frontend have secure communication between them, either with a symmetric key (not recommended for production) or a certificate (the recommended way), so there is no worry. It's all tied to the account's access level, etc., so nobody can make an action that they normally wouldn't be allowed to do. Even the MCP is token-based, and there are prompt injection protections in place. The MCP is audited, and every mutation needs confirmation. The admin area is only accessible to the admin account anyway so normal users can't access it.  
  • 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..