Jump to content
  • 0

{HELP}Could not store Spawn in the DB!!


Question

Posted

i need help...when i do one  npc spawn....shows me an error in gameserver.bat log...who says :...

 

 

                              Could not store Spawn in the DB...: Data truncation :Out of range Value abjusted for column

                              'id' at row 1

                              and then mysql.error etc....

 

  the spawn appears on the server...but if i do  rr or shutdown...npc isnt there...not saved (as error said)..

 

  can someone tell me why??  in freya i try for 1st time to do something...i did everything i do in others times when i had epilogue or

final server....and i dont think is something in my configs or my data....is something from navicat ..but i cant find what...pla help

dudes...

 

 

Thank you

3 answers to this question

Recommended Posts

  • 0
Posted

You surely miss a column in your database, or the //spawn command tries to add more datas than your current database format can support.

 

What can you do then ?

 

Search your spawn command, and analyze it. It will show which columns are used.

 

Compare it with your spawn database format, or the table where your custom spawns are supposed to be stored.

 

My serverpack uses another table for custom spawn. So be AWARE.

 

 

 

PS : even if your signature is sexy, can you decrease the height per... 10 ? Lol, just change of signature dude. And she got fake boobs.

  • 0
Posted

I Fix it man...tnx for your help....i had made a wrong  spawn id...:)...

 

close the topic...

 

Locked as requested.

Guest
This topic is now closed to further replies.


  • Posts

    • Greetings, MaxCheaters community! We are the development team behind projects like AdenLand, Classic GvE, TinyEssence, PvPEssence, and several others. Over the years of managing high-traffic servers, we’ve built our own ecosystem of tools for datapack and client editing, simply because standard software often failed to meet our production needs or was too slow. Today, we are opening access to these professional solutions for our colleagues in the dev scene. You can explore our suite of editors and utilities here: 👉 https://la2.tools/ Why choose our tools? Battle-Tested: This software is used daily to maintain and update our own live projects. Efficiency: Designed to automate routine tasks that usually take hours or even days. Stability: Built to handle complex client/server structures where generic tools often crash. We are ready to provide consultations on integrating these tools into your development workflow to make your process faster and more secure.  
    • There is such a topics based on java html services!
    • L2Elixir – Patch 9 Is Live! Since November 28, when L2Elixir officially opened, we’ve been here consistently and with dedication. We sincerely thank everyone who continues to support this major effort to bring back the true legacy of L2Elixir, even after 18+ years. It truly makes us happy to see many old players reunite, just like in the old days, and enjoy the game the way it was meant to be played: without RMT, without bug abusers, and without “paid” clans/CPs that disappear after a month. We continue with vision, stability, and respect for the community. Wishing everyone to Have fun! Changelogs: 🏆 Olympiad Olympiad every Monday & Friday (last day: Friday). Fixed an issue with wrong Class ID caused by the Class Change service. ⚔️ Territory Wars Territory Wars will now be held every Tuesday to increase PvP activity. 🛡️ Antibot General updates and additional security improvements implemented. 🔧 Items Augmentation & Attribute are now allowed on PvP weapons. Implemented Premium Coupon (15 Days) (currently not available). 🎉 Events An Auto Event will begin early morning (05:00) for NA players. 💻 Client Added EXP zones to the Map → Hunting Zones section. Renamed them to “XP Bonus” so they appear at the top of the list.   Website: https://l2elixir.org/ Discord: https://discord.gg/5ydPHvhbxs
    • I haven't work in Essence but I have transformed mobius projects into fully stable projects, reach out to me in Discord @cerus0130
  • 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..