View Single Post
  #1  
Old 09-15-2013, 02:55 AM
NEEDADISPENSERHERE
Fire Beetle
 
Join Date: Nov 2009
Posts: 12
Default Zone Dynamic 01 Constantly Restarting (Database sourcing problem?)

Hello all. I've searched up and down on google and this website and can't seem to find an answer to my problem. Sorry in advance for the wall of text, I put a tldr at the bottom.

I followed every single step in this guide: http://www.eqemulator.net/wiki/wikka...rverSetupGuide

*However*, I run into a problem at step 4 (http://www.eqemulator.net/wiki/wikka...tupGuide#Step4) where it says to grab the peq database (http://projecteqdb.googlecode.com/sv...k/peqdatabase), and then says "[n]ext, go to the folder C:\EQ\SQL and unzip the file from peqdb_revNNNN.sql.gz."

This file is no longer on the website, and there is a textfile called "DO_NOT_USE_THIS_DB" which contains a link to a more up-to-date database (http://peqtgc.com/releases). I downloaded the beta database file and the quests file. I wasn't really sure what to do from here, so I sourced "load_player.sql" and "load_bots.sql" from the old link and then just sourced "drop_system.sql" and "peqbeta_2013-09-14-02_01.sql" from the new link.

When I got my server all setup and ran it, zone.exe gave errors. I then extracted all the quests from the new database link and replaced the old quest files in C:/EQ/EQEmuServer/Quests and sourced "user_tables_2013-09-14-02_01.sql" and "source_views.sql" which obviously didn't work and probably made things worse (sourcing user tables almost made my cmmd prompt crash).

So can anyone help me out as to what I did wrong? I don't have specific error logs with me now, but I don't really know how to post logs here (the log text files don't give full details like running zone.exe in cmmd prompt does), and I have a feeling all of this is due to me not properly setting and sourcing my database.

TLDR;
-old database: http://projecteqdb.googlecode.com/svn/trunk/peqdatabase
-new database: http://peqtgc.com/releases
-was confused by directions, so sourced "load_player.sql" and "load_bots.sql" from old database and "drop_system.sql" and "peqbeta_2013-09-14-02_01.sql" from the new database (followed by "user_tables_2013-09-14-02_01.sql" and "source_views.sql" when I got zone errors)
-still getting zone errors (peq.zone doesn't exist), faction errors, etc.
-guessing I screwed up step four, help please

Appreciate any response, and sorry again for the messy walkthrough.
Reply With Quote