Server problems

[njlinus]

Hey thanks for the quick replies. i will look into this tomorrow night and keep you updated. I never rebooted my machine before trying to log on so that might be it.
as for my database i started working on it this week and forgot to back it up..oh well. i only had a few ornate and epic merchants. so i didnt lose much that i cant redo quickly.

[Zandig]

If you are updating from Server Pack 3.52 to the latest build you must follow the changelogs: http://www.eqemulator.net/releases/l...-0.7.0-804.txt
and make the appropriate adjustments to your database.

So to update to the newest release: 0.7.0-804 (which is the newest as of this post) you must run these lines into your database:

ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;

ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';

alter table account DROP packencrypt;
alter table character_ change extprofile extprofile blob NULL;
alter table player_corpses change data data blob NULL;
alter table player_corpses_backup change data data blob NULL;

I'm using the PEQ database (works with Cavedude's as well) and it works great. If I didn't do exactly as I stated above it would not work properly and say the zone is unavailable. Trust me I've already found out

I also find that using MySQL Control Center is easiest for making database modifications. Load the control center, select your database, select the SQL/Query button, copy and paste the code and then execute the query.

[njlinus]

Yep that fixed it, was a little slow loading in the first time but it works, thanks guys!

[therealjjj77]

Everytime I enter the:
ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT( UNSIGNED NOT
NULL DEFAULT '0';

I get this error that says I'm not using the right MYSQL syntax. I currently have 4.0.0.23.

Do I need MYSQL 5.0? And if I do how can I replace it without running into problems? I am trying to upgrade from the 3.52 Cavedude pack to the most recent binary. Thank you for the help in advance.

EDIT: I think I see the problem. lol. NM this post. (`) looks a lot like (')