Trouble with zones

Bandor · #1 01-16-2015, 09:21 PM

Ok fixed the DB connection issue,world.exe is saying the following upon boot up

Code:

[Status] Using database 'peq' at 127.0.0.1:3306

[MYSQL ERR] 1050: Table 'character_corpse_items' already exists [Query]:
CREATE TABLE `character_corpse_items` (   `corpse_id` int(11) unsigned NOT NULL,
                  `equip_slot` int(11) unsigned NOT NULL,         `item_id` int(
11) unsigned DEFAULT NULL,        `charges` int(11) unsigned DEFAULT NULL,
  `aug_1` int(11) unsigned DEFAULT '0',           `aug_2` int(11) unsigned DEFAU
LT '0',           `aug_3` int(11) unsigned DEFAULT '0',           `aug_4` int(11
) unsigned DEFAULT '0',           `aug_5` int(11) unsigned DEFAULT '0',
  `aug_6` int(11) unsigned DEFAULT '0',           `attuned` smallint(5) NOT NULL
 DEFAULT '0',  PRIMARY KEY(`corpse_id`, `equip_slot`)             ) ENGINE = Inn
oDB DEFAULT CHARSET = latin1;


[MYSQL ERR] 1050: Table 'character_corpses' already exists [Query]:
RENAME TABLE `player_corpses` TO `character_corpses`


[MYSQL ERR] 1054: Unknown column 'WasAtGraveyard' in 'character_corpses' [Query]
:
 ALTER TABLE `character_corpses`


 ADD COLUMN `is_locked`                    tinyint(11) NULL DEFAULT 0 AFTER `Was
AtGraveyard`,
 ADD COLUMN `exp`                              int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `size`                  int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `level`                 int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `race`                  int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `gender`                int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `class`                 int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `deity`                 int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `texture`               int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `helm_texture`          int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `copper`                int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `silver`                int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `gold`                  int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `platinum`              int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `hair_color`            int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `beard_color`           int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `eye_color_1`           int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `eye_color_2`           int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `hair_style`            int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `face`                  int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `beard`                 int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `drakkin_heritage`      int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `drakkin_tattoo`        int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `drakkin_details`       int(11) UNSIGNED NULL DEFAULT 0,

 ADD COLUMN `wc_1`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_2`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_3`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_4`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_5`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_6`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_7`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_8`                         int(11) UNSIGNED NULL DEFAULT 0,


 ADD COLUMN `wc_9`                         int(11) UNSIGNED NULL DEFAULT 0,


 CHANGE COLUMN `zoneid` `zone_id`  smallint(5) NOT NULL DEFAULT 0 AFTER `charnam
e`,
 CHANGE COLUMN `instanceid` `instance_id`  smallint(5) UNSIGNED NOT NULL DEFAULT
 0 AFTER `zone_id`,
 CHANGE COLUMN `timeofdeath` `time_of_death`  datetime NOT NULL DEFAULT '0000-00
-00 00:00:00' AFTER `data`,
 CHANGE COLUMN `rezzed` `is_rezzed`  tinyint(3) UNSIGNED NULL DEFAULT 0 AFTER `t
ime_of_death`,
 CHANGE COLUMN `IsBurried` `is_buried`  tinyint(3) NOT NULL DEFAULT 0 AFTER `is_
rezzed`;



[MYSQL ERR] 1054: Unknown column 'WasAtGraveyard' in 'character_corpses' [Query]
:
 ALTER TABLE `character_corpses`


 CHANGE COLUMN `WasAtGraveyard` `was_at_graveyard`  tinyint(3) NOT NULL DEFAULT
0 AFTER `is_buried`


Pulling down automatic database upgrade script...

No update necessary
Perl Version is 5.12.3
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
============================================================
           EQEmu: Automatic Database Upgrade Check
============================================================
        Operating System is: MSWin32
        (Windows) MySQL is in system path
        Path = C:\xampp\mysql\bin/mysql
============================================================
        Binary Database Version: (9066)
        Local Database Version: (9066)

        Database up to Date: Continuing World Bootup...
============================================================

[MYSQL ERR] 1932: Table 'peq.group_leaders' doesn't exist in engine [Query]:
DELETE from group_leaders

Unable to clear group leaders: #1932: Table 'peq.group_leaders' doesn't exist in
 engine

Was not getting the table errors before the DB connection issue so not sure what is going on there now. When I updated my source I did select option 3,two times once to check for updates then to update. That is all I did,was I suppose to source anything in? Everything was working fine when I first updated.

**trevius** · #2 01-17-2015, 02:25 AM

I am not sure what happened when you PC was restarted, but it looked like your DB has some major issues with missing tables and such. If you have a full DB backup from before the updates, I would suggest reverting to it. Otherwise, it may be a pain to get whatever is missing in your tables restored manually.