Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-03-2015, 03:56 PM
Xaeyr
Sarnak
 
Join Date: Oct 2014
Posts: 45
Default 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.
Reply With Quote
  #2  
Old 10-03-2015, 07:39 PM
Cilraaz
Sarnak
 
Join Date: Mar 2010
Posts: 77
Default

Back up your database and run option 10 on the updater to make sure you have the bot sql tables loaded. Also, have you compiled your binaries with bots enabled?
Reply With Quote
  #3  
Old 10-03-2015, 08:09 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

I disabled the return argument for enabling the bots update portion of the updater script.

You can still use 'load_bots.sql' to install the schema..but, use the one in the git repo and not the one from the peq db download.

It should be in this sub-directory of your local repo: https://github.com/EQEmu/Server/blob.../load_bots.sql


EDIT: There is a new sql incoming and the updater script will be enabled at that time.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #4  
Old 10-04-2015, 06:49 AM
Xaeyr
Sarnak
 
Join Date: Oct 2014
Posts: 45
Default

Thanks for the replies. The bot tables were loaded, but apparently when I compiled the binaries for bots I didn't do it correctly. Tried again and that took care of the world.exe errors. I also downloaded the load_bots.sql file mentioned and sourced it in. I can now summon the bot
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 03:47 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3