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

    • You think you have good “l2j” files until you try running a low-rate server.   Saying “there’s not a single L2 server out there worth mentioning” just shows you probably only know the first 10 servers on voting sites, the same voting sites that owned by them. You call the forum dead, yet you’re here discussing your next projects… From my perspective, you don’t seem ready to run any L2 server in 2025. Around 70% of players are here for RMT or ask for payment just to bring their clan, and you really think the community cares about Premium or donations or files quality? The other 20% spend their time downloading and deleting servers all day, playing for one day, then quitting for whatever random reason. And finally, the last 10% are the only ones who actually play because they genuinely like your features, your server files, and your overall project. Good luck 🙂
    • I genuinely admire your bravery - in an age where AI can whip up something better in under a minute, you still stubbornly try to sell these "projects" of yours on a forum that’s been clinically dead for years. That’s no longer determination, that’s digital archaeology. I just can’t tell whether you’re actually trying to make money, or simply testing how much we can endure before we ask an AI to generate you some actual talent.   And ofc AI will make it for free, $220 saved.
    • 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
  • 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