Dynamic zone failed

[shamanistik]

Hi everyone,

Have a problem for couple days, the only way to make it work again is to unistall the DRP server, and reinstall it..

Here is what happen, like every couple days..
But since I worked very hard on my db I would like to keep it now.. :(

logs

[05.11. - 18:18:38] Starting Log: logs/eqemu_debug_1628.log
[05.11. - 18:18:38] [LAUNCHER__INIT] Loading server configuration..
[05.11. - 18:18:38] [LAUNCHER__INIT] Starting main loop...
[05.11. - 18:18:38] [NET__WORLD] Connected to World: 127.0.0.1:9000
[05.11. - 18:18:43] [LAUNCHER__WORLD] World told us to start zone dynamic_01.
[05.11. - 18:18:43] [LAUNCHER__WORLD] World told us to start zone dynamic_02.
[05.11. - 18:18:43] [LAUNCHER__WORLD] World told us to start zone dynamic_03.
[05.11. - 18:18:43] [LAUNCHER__WORLD] World told us to start zone dynamic_04.
[05.11. - 18:18:43] [LAUNCHER__WORLD] World told us to start zone dynamic_05.
[05.11. - 18:18:43] [LAUNCHER__ERROR] World told us to start zone dynamic_01, but it is already running.
[05.11. - 18:18:43] [LAUNCHER__ERROR] World told us to start zone dynamic_02, but it is already running.
[05.11. - 18:18:43] [LAUNCHER__ERROR] World told us to start zone dynamic_03, but it is already running.
[05.11. - 18:18:43] [LAUNCHER__ERROR] World told us to start zone dynamic_04, but it is already running.
[05.11. - 18:18:43] [LAUNCHER__ERROR] World told us to start zone dynamic_05, but it is already running.
[05.11. - 18:18:43] [LAUNCHER__STATUS] Starting zone dynamic_01
[05.11. - 18:18:43] [LAUNCHER__STATUS] Zone dynamic_01 has been started.
[05.11. - 18:18:43] [LAUNCHER__STATUS] Waiting 20000 milliseconds before booting the second zone.
[05.11. - 18:18:45] [LAUNCHER__STATUS] Zone dynamic_01 has gone down. Restart timer started.
[05.11. - 18:19:03] [LAUNCHER__STATUS] Starting zone dynamic_01
[05.11. - 18:19:03] [LAUNCHER__STATUS] Zone dynamic_01 has been started.
[05.11. - 18:19:03] [LAUNCHER__STATUS] Waiting 20000 milliseconds before booting the second zone.
[05.11. - 18:19:05] [LAUNCHER__STATUS] Zone dynamic_01 has gone down. Restart timer started.
[05.11. - 18:19:25] [LAUNCHER__STATUS] Starting zone dynamic_01
[05.11. - 18:19:25] [LAUNCHER__STATUS] Zone dynamic_01 has been started.
[05.11. - 18:19:25] [LAUNCHER__STATUS] Waiting 20000 milliseconds before booting the second zone.
[05.11. - 18:19:27] [LAUNCHER__STATUS] Zone dynamic_01 has gone down. Restart timer started.
[05.11. - 18:19:47] [LAUNCHER__STATUS] Starting zone dynamic_01
[05.11. - 18:19:47] [LAUNCHER__STATUS] Zone dynamic_01 has been started.
[05.11. - 18:19:47] [LAUNCHER__STATUS] Waiting 20000 milliseconds before booting the second zone.
[05.11. - 18:19:49] [LAUNCHER__STATUS] Zone dynamic_01 has gone down. Restart timer started.
[05.11. - 18:19:51] [LAUNCHER__STATUS] Caught signal 2
[05.11. - 18:19:53] [LAUNCHER__STATUS] Stopping zone dynamic_01 before it has started.
[05.11. - 18:19:53] [LAUNCHER__STATUS] Stopping zone dynamic_02 before it has started.
[05.11. - 18:19:53] [LAUNCHER__STATUS] Stopping zone dynamic_03 before it has started.
[05.11. - 18:19:53] [LAUNCHER__STATUS] Stopping zone dynamic_04 before it has started.
[05.11. - 18:19:53] [LAUNCHER__STATUS] Stopping zone dynamic_05 before it has started.

The 1st zone keep going down again and again.. also, when it work.. the first messages like this keep appearing, wondering if it's normal..

[05.11. - 18:18:43] [LAUNCHER__ERROR] World told us to start zone dynamic_01, but it is already running.
[05.11. - 18:18:43] [LAUNCHER__ERROR] World told us to start zone dynamic_02, but it is already running.
[05.11. - 18:18:43] [LAUNCHER__ERROR] World told us to start zone dynamic_03, but it is already running.
[05.11. - 18:18:43] [LAUNCHER__ERROR] World told us to start zone dynamic_04, but it is already running.
[05.11. - 18:18:43] [LAUNCHER__ERROR] World told us to start zone dynamic_05, but it is already running.



Thanks in advance, any help welcome

EDIT: by the way, I don't use minilogin server

[shamanistik]

Seems it comes from DB.. installed new EQemu server with DRP, with no DB

Same problem..

But the only things I modified was the NPC (delete, create new ones)
Created spawnpoints for them
Assigned a shared loot table

That could possibly corrupt the DB??

Everytimes I change it, after couple days it crash and I install again..

[sakrod]

Try dropping the database and re-sourcing it from scratch using the installer instead of just copying over the old one.

Open up my sql -> Start/run/"c:\mysql\bin\mysql -u root"
Drop your database -> drop eq; or drop peq; depending on database name.
Exit sql
Reinstall serverpack

[shamanistik]

Uhmm, even the game don't launch, I come to the server select screen, it freeze and game crash to desktop.. any clue??

[shamanistik]

Originally Posted by sakrod

Try dropping the database and re-sourcing it from scratch using the installer instead of just copying over the old one.

Open up my sql -> Start/run/"c:\mysql\bin\mysql -u root"
Drop your database -> drop eq; or drop peq; depending on database name.
Exit sql
Reinstall serverpack

Drop eq; don't work, and not sure how to source a complete DB also :/

[sakrod]

Drop eq; don't work

I apologize, the command if you are using cavedude's database is "drop database eq; "

If you are using peq's, the command is "drop database peq;"


When you reinstall the server pack, it sources the database for you, so you do not manually need to do it..as stated in my previous post.

re-sourcing it from scratch using the installer

[shamanistik]

I reinstalled the server pack and it work.. but I lost my database and 2 full days of work.. : (

Since I only edited mobs and spawnpoints.. what killed my DB??
This time I only used PEQeditor to remove/add spawn point and mobs

Last time it crashed after a long quest script..

Would really like to stop losing my databases :/

[shamanistik]

Same problem :(

Fresh new titanium install, fresh DRP server install.

(EQgame freeze sometimes and crash to desktop, chain doing it, until I change account it worked.. maybe a problem from accounts???)

Well I log in to my server, create a character, kill a mob, zone, everything work.
I camp, logout, close the server with CTRL C.

Open PEQeditor, log in, remove all spawn points, then all loot tables, then all mobs (1 by 1, starting in order above) in Kurn zone

I create a named mob, add a spawn point in a safe loc I already know about

Create another mob, add spawn points (10) safe locs also
Create a second mob with same name, different ID (of course) and different look
Add this mob in the spawngroup, balance chances to pop

I log out from PEQeditor, close firefox

I launch Questeditor, select kurn zone, find my 3 mobs in kurns (actually find 1 X 5 times the same mob + 1 X 5 times the other mob + the named mob

I open the named mob, select PEQ template, modify answer to hail by 'Greetings broodling'
Click save, then quit

I launch EQemu server

Same error as above..

[LAUNCHER__STATUS] Zone dynamic_01 has gone down. Restart timer started.

?????????

Thanks for the help :(

[Dr Zauis]

If I were you Id find sqlyog program and learn to use it..I have many databases I use. I back up before I change stuff just copy paste rename.
I use sql queries only to change stuff. sqlyog is kinda buggy to change single
values by the table method.

[shamanistik]

Thanks for the advise, already found some sites with trainings and tutorials, will try to find this ; )

[shamanistik]

Thanks, just DL the free version and looked at it, it seems less and less complicated now, maybe a day I'll talk in mySQL with my hamster

Thanks again man, looks like a great tool