| Xaeyr |
10-03-2015 03:56 PM |
Errors when running world.exe
Hi all. Been playing around with my own local private server for a month or so now and been having a fun time. For the past few days I've been pulling my hair out, however, trying to get bots to work. Well, in my quest (so to speak) to get them working, I seem to have broken something and I'm not sure what. I can still get into my server, but when running world.exe I get these errors. Any ideas? And, and fyi, I'm running with Titanium if it makes a difference here.
Code:
[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.1.3
[World Server] Added loginserver 127.0.0.1:5998
[World Server] Connecting to MySQL...
[Status] Starting File Log 'logs/world_4424.log'
[World Server] HTTP world service disabled.
[World Server] Checking Database Conversions..
[MySQL Error] 1050: Table 'character_corpse_items' already exists
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 DEFAULT '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 = InnoDB DEFAULT CHARSET = latin1;
[MySQL Error] 1050: Table 'character_corpses' already exists
RENAME TABLE `player_corpses` TO `character_corpses`
[MySQL Error] 1054: Unknown column 'WasAtGraveyard' in 'character_corpses'
ALTER TABLE `character_corpses`
ADD COLUMN `is_locked` tinyint(11) NULL DEFAULT 0 AFTER `WasAtGraveyard`,
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 `charname`,
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 `time_of_death`,
CHANGE COLUMN `IsBurried` `is_buried` tinyint(3) NOT NULL DEFAULT 0 AFTER `is_rezzed`;
[MySQL Error] 1054: Unknown column 'WasAtGraveyard' in 'character_corpses'
ALTER TABLE `character_corpses`
CHANGE COLUMN `WasAtGraveyard` `was_at_graveyard` tinyint(3) NOT NULL DEFAULT 0 AFTER `is_buried`
[Upgrade Script] No script update necessary
Perl Version is 5.12.3
============================================================
EQEmu: Automatic Upgrade Check
============================================================
(Windows) MySQL is in system path
Path = C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin/mysql
============================================================
Binary Revision / Local: (9077 / 1000)
ERROR 1054 (42S22) at line 1: Unknown column 'bots_version' in 'field list'
You have missing database updates, type 1 or 2 to backup your database before running them as recommended...
EQEmu Update Utility Menu:
1) Backup Database - (Saves to Backups folder)
2) Backup Database Compressed - (Saves to Backups folder)
3) Check and stage pending REQUIRED Database updates
4) AAs - Download Latest AA's from PEQ (This overwrites existing data)
5) OPCodes - Download latest opcodes
6) Maps - Download latest map and water files
7) Plugins - Download latest Perl plugins
8) Quests - Download latest PEQ quests and stage updates
9) LUA Modules - Download latest LUA Modules (Required for Lua)
10) Check for Bot REQUIRED database updates...
20) Force update this script (Redownload)
0) Exit
Enter numbered option and press enter...
> 0
[World Server] Loading variables..
[World Server] Loading zones..
[World Server] Clearing groups..
[World Server] Clearing raids..
[World Server] Loading items..
[World Server] Loading skill caps..
[World Server] Loading guilds..
[World Server] Loaded default rule set 'default'
[World Server] Loading EQ time of day..
[World Server] Loading launcher list..
[World Server] Reboot zone modes ON
[World Server] Deleted 0 stale player corpses from database
[World Server] Loading adventures...
[World Server] Purging expired instances
[World Server] Loading char create info...
[World Server] Zone (TCP) listener started.
[World Server] Client (UDP) listener started.
|