Trouble Updating Server (7.0-Current)

[onuris]

Hello all. Just looking for some help on a little problem I am having. I follow the instructions in the Setup Guide to the letter and I can was able to get my server up and running with no problems. Where I am having problems is when I try to update my binaries to the newest version.

I understand that I have to backup my config file then drag and drop the newer files into my EQemu directory and that I have to look at the ChangeLog to get the updates. What I am getting confused on is the ChangeLog.

Do I need to update my DB with all the SQL entries that is says in the ChangeLog or just whats under the most current date? Or do I need to do all the SQL changes from 7.0 up to the the current binaries I am installing? (which is .840)

Example:
If there is no updates under 7/23/2006 then do I not need to do any? Or do I have to make the changes stated under 7/17/2006 and so on down to 7/5/2006?

This is the only thing I am confused on. When I copy the new files to my EQemu folder and do ALL the SQL DB changes from the version changelog my server doesn't work properly. One of the problems is my CMD window for the zone server is just blank. Nothing loads up in it. It will say waiting for WORLD to load before loading ZONE. Once the WORLD loads the window goes blank and goes to sleep. Which in turn makes all my ZONES unvailable when I hit enter world from the character select. I have searched and searched the forums for answers but really haven't found much.

I have done everything except reinstall EQTitanium. Any help would be great.

Thanks
Onuris

you have to do everything from the version you are running to the version you are moving to.

[onuris]

Thank You. Thats all I needed to know.

Come to find out I need to reinstall EQ anyway. Something got botched when I was screwing around tring to get my server working. That might also have something to do with the problems I was having. We shall see after I reinstall EQ.

Thanks
Onuris

[justplaininsane]

i know this is a stupid question, but i can't seem to find it myself yet...

how do i figure out what version of the binaries i currently have running? i used the guide to install 0.7.0, but i don't know exactly which build was used...

thanks in advance.

[onuris]

Not sure which build Titanium is. I got my server to work properly now. All I did was update to .840 and the do the DB updates in order from earliest to the newest and everything seems to work fine now. Just update to the newest binaries and do the changes in the ChangeLog from the earliest date to the current date. That worked for me.

Thanks
Onuris

[John Adams]

I'm having an interesting time updating from Cavedudes 3.52 package to the latest binaries. Being a typical engineer-type, I took the latest bins, extracted them over my (backed up) Emu files, then did all the SQLs in the changelog. Game runs, client connects, but when I enter the world, I get the infamous "Zone Unavailable" message.

Since I do know how to use Search, I found out that one thing that definitely can cause this is not doing the SQLs correct from the changelog. So, I backed everything back to original install (3.52 packager), and put in every binary release (and SQL change) one_rev_at_a_time, logging in fully until I had the problem.

Mine is crapping out on 07/16/2006 patch, binary version EQEmu-0.7.0-833, after running the "ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2`;" as it says in the changelog. Now, and until I remove this set of Binaries, I cannot log into the game. (should have started at the end and went backwards, eh?)

Anyone else having this problem with this particular patch? Other than this, things are running wonderfully.


Edit: Actually, I should have tested this first - the Zone Unavailable has nothing to do with the ALTER TABLE `traps`... since I back-revved that table and the game still won't let me in. If I go back to the 828 binaries, all is well. But I am screwed from bin patch 833-840.