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

    • I’m glad I’m not the only one who appreciates Maxthor’s involvement in group gay orgies, he can’t be bothered to reply to messages, but covering the entire forum in gay lights is absolutely no issue for him. As for the project - the forum is packed with feedback from the testers, the lads are spending every spare moment fixing even the tiniest typo in an NPC’s text. I’ll share the links as soon as I get the green light. Edit: I forgot to add that the GM recruitment will begin once the links are released. Three people will be accepted, and they’ll work in a three-shift rotation so that there’s always a GM available online.
    • Added: a brand-new default dashboard template. You can now add multiple game/login server builds. Full support for running both PTS & L2J servers simultaneously, with switching between them. Payment systems: added OmegaPay and Pally (new PayPal-style API). Account history now stores everything: donations, items delivered to characters, referrals, transfers between game accounts, and coin transfers to another master account. Personal Promo Code System: you can create a promo code and assign it to a user or promoter. When donating, a player can enter this promo code to receive bonus coins, and the promo code owner also receives a bonus — all fully configurable in the admin panel.     Look demo site: demo
    • One of best project i play last few years
    • for me no  😕   https://files.fm/f/jewqgu9fkb
    • 🚀 **TOMORROW – GRAND OPENING!** 🚀   📅 **Grand Opening Date:** 5 December 2025   ⏰ **Time:** 20:00 GMT+2   🎫 **BONUS CODE:** `WELCOME-TO-L2MID`   ⚠️ Limited to the **first 100 players** only! 🖥️ **Server Info:** - 🕒 The server will open **1 hour earlier (19:00 GMT+2)** so you can create your characters. - 🧍 All important **NPCs will appear at 20:00 GMT+2** for the official **GRAND OPENING**. 💡 **How to redeem the bonus code:** - After you create your character, log in to the **L2Mid Panel** and redeem your bonus here:     🔗 https://l2mid.com/account.php#dash-promocode 🎁 **BONUS CODE REWARDS:** 🧪 Mana Drug × 50   🛡️ Greater CP Potion × 50   ❤️ Greater Healing Potion × 50   📜 Blessed Scroll of Escape × 5   ⭐ Bonus Rune – 3 Hours × 1   ⚔️ Get ready for the start of your new adventure on **L2Mid**!  
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock