typhoon
03-20-2006, 09:23 AM
This was probably in the previous versions of 0.6.6, but when the new guild structure was updated the query and table for character_backup wasn't updated. So now, whenever the auto character_backup kicks in I get an error about guild not being in the update and then it looks like the connection is lost and the characters are hung in the zone.
When the character table was altered to take the guilds out of it, it was never done to the character_backup table.
Looks like this needs to be done to the character_backup table:
ALTER TABLE character_backup ADD class TINYINT NOT NULL DEFAULT 0;
ALTER TABLE character_backup ADD level MEDIUMINT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE character_backup DROP guild;
ALTER TABLE character_backup DROP guildrank;
ALTER TABLE character_backup DROP publicnote;
I didn't go through the code yet but I but I am sure the query needs to be updated also so the insert into the character_backup will work.
When the character table was altered to take the guilds out of it, it was never done to the character_backup table.
Looks like this needs to be done to the character_backup table:
ALTER TABLE character_backup ADD class TINYINT NOT NULL DEFAULT 0;
ALTER TABLE character_backup ADD level MEDIUMINT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE character_backup DROP guild;
ALTER TABLE character_backup DROP guildrank;
ALTER TABLE character_backup DROP publicnote;
I didn't go through the code yet but I but I am sure the query needs to be updated also so the insert into the character_backup will work.