Trouble Updating Server (7.0-Current)

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

[Aramid]

Originally Posted by 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.

Assuming that everything is installed as defaults, see if this helps:

goto c:\mysql\bin>

Type in mysql -ueq -p peq (peq if your using peq database or eq if your using cavedude's database)

Enter your password. You should now be at a mysql> prompt

TYpe in the Changes

ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;

If you get an error, leave off the ` around traps, message and effectvalue2

when your done, type in quit to exit mysql.

[johane]

Originally Posted by 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.

Don't use the character ` for quotes, use the character ' .

That's the single quote near your enter key, NOT the one near your escape key (assuming you have a standard US keyboard layout).