Trouble Updating Server (7.0-Current)

[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.

[GeorgeS]

These are the changes I made to run EQEmu-0.7.0-838. So far it works.
You did overwrite the binaries right?

GeorgeS


ALTER TABLE `npc_types` DROP walkspeed;
ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;
CREATE TABLE rule_sets (ruleset_id TINYINT UNSIGNED NOT NULL auto_increment, name VARCHAR(255) NOT NULL, PRIMARY KEY(ruleset_id));
INSERT INTO rule_sets VALUES(0, "default");
UPDATE rule_sets SET ruleset_id=0;
CREATE TABLE rule_values (ruleset_id TINYINT UNSIGNED NOT NULL, rule_name VARCHAR(64) NOT NULL, rule_value VARCHAR(10) NOT NULL, INDEX(ruleset_id), PRIMARY KEY(ruleset_id,rule_name));

[John Adams]

Yeah, embarrassingly enough, once I did the upgrade yet one more time to 840, everything was working fine. I think my problem had little to do with the SQL or game code, and a lot to do with my adolescence at getting things to work. I seem to be able to install, run, and screw up an EQEmu within minutes now.

There are indeed some great tips on this forum. Search is my friend.

[greneday]

I looked around, and tried to on my own, but I just do not know how to impliment the change logs into my database.

ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;
when plugged into mysql, or saved as a sql file and tried to query, it just gives me syntax errors.