If you are using a newer verserion of EQEmu than the wiki (say like you are using: EQEmu-0.7.0-965 instead of EQEmu-0.7.0-845) you need to apply all the required SQL as well. I didn't do this and kept being able to log in but just hung in mid air as the zone more or less crashed.
It was hard to decipher the crashes until I made one of the zones static and saw the errors a bit more clearly.
This may not be your problem, but hopefully it'll help some!
If you are going from 0.7.0-845 to 0.7.0-965 you'll want to apply these SQL statements:
CREATE TABLE skill_caps (
skillID TINYINT UNSIGNED NOT NULL,
class TINYINT UNSIGNED NOT NULL,
level TINYINT UNSIGNED NOT NULL,
cap MEDIUMINT UNSIGNED NOT NULL,
PRIMARY KEY(skillID,class,level)
);
ALTER TABLE `zone` ADD `cancombat` tinyint(4) NOT NULL default '1';
UPDATE `zone` SET `cancombat` = 0 WHERE short_name = 'nexus';
UPDATE `zone` SET `cancombat` = 0 WHERE short_name = 'poknowledge';
UPDATE `zone` SET `cancombat` = 0 WHERE short_name = 'potranquility';
ALTER TABLE `npc_types` ADD `see_hide` tinyint(4) NOT NULL default '0';
ALTER TABLE `npc_types` ADD `see_improved_hide` tinyint(4) NOT NULL default '0';
UPDATE `npc_types` SET `see_hide` = 1 WHERE see_invis = '1';
UPDATE `npc_types` SET `see_hide` = 1 WHERE see_invis_undead = '1';
|