database not saving spawn.

[darren]

anyone have any Idea what is causing the database not to be saving your spawn when you restart the server? after restart they are deleted.

[hawryszka]

I have the same problem

[Fanky]

Client/project?

Check the spawnlist.sql

[hawryszka]

My client is Freya, Project: L2j Dev Team, L2j Server ver 4422, L2j Datapack ver 7669. Spawnlist.sql looks good

[Kяaσh]

Any error ?, the only idea that i had now is to enable the custom npc table and spawnlist.

[Matim]

STOP Helping people while they are not even able to post in right section!

 

---

 

Wrong Section.

 

Read Our Forum Rules.

 

You should post it here [Request] Dev Help [L2J] En.

 

Before posting also check Rules of this Section.

 

Topic Locked.

[Furiosus]

Moved & Unlocked.

[darren]

this is the error that you get:

 

 

any idea's how to fix it?

[maoq93]

Hello Darren, this error is easy to fix. If you use navicat to manager your DB, you just need to select "design table" in "spawnlist" there you will see something like

Name  Type  Lenght  Decimals  Allow Null

ID       

 

you just need to change the type to "mediumint" and the lenght to "11"

I hope it will work to you.

 

 

[darren]

thx you very much for info, it helped me and I'n sure it will help alot others......you are a true forum, stright to the point on how to fix what need to be fixed.......If you ever care to work on server stuff together, pm me and I will add you to my msn or skype.

[Matim]

As I can see, your problem has been fixed, topic locked.