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.