Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-13-2015, 01:37 AM
JimB_1958
Sarnak
 
Join Date: Mar 2013
Location: Springfield MO
Posts: 66
Default

An update...

I ended up installing akka's repak on another machine and got it up and going a few minnutes ago. From what I have read from the 12123327875 web posts I have read sice this happened, something got totaly borked with my mariadb. I unistalled, deleted the mariadb folders, and combed through the registry to remove any references to mysql and maria. Nothing worked. So.., short of taking a sledge hammer to it, there's not much else I know to do.

Meawhile, on my new install, I came up with an error in world on startup.

Code:
[09-13-2015 :: 00:01:41] [World Server] Starting HTTP world service...
[09-13-2015 :: 00:01:41] [World Server] Checking Database Conversions..
[09-13-2015 :: 00:01:41] [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;  
[09-13-2015 :: 00:01:41] [MySQL Error] 1050: Table 'character_corpses' already exists 
 RENAME TABLE `player_corpses` TO `character_corpses`
[09-13-2015 :: 00:01:41] [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`;						

[09-13-2015 :: 00:01:41] [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` 

[09-13-2015 :: 00:01:43] [World Server] Loading variables..
[09-13-2015 :: 00:01:43] [World Server] Loading zones..
[09-13-2015 :: 00:01:43] [World Server] Clearing groups..
[09-13-2015 :: 00:01:43] [World Server] Clearing raids..
[09-13-2015 :: 00:01:43] [World Server] Loading items..
[09-13-2015 :: 00:01:43] [World Server] Loading skill caps..
[09-13-2015 :: 00:01:43] [World Server] Loading guilds..
[09-13-2015 :: 00:01:43] [World Server] Loaded default rule set 'default'
[09-13-2015 :: 00:01:43] [World Server] Loading EQ time of day..
[09-13-2015 :: 00:01:43] [World Server] Loading launcher list..
[09-13-2015 :: 00:01:43] [World Server] Reboot zone modes OFF
[09-13-2015 :: 00:01:43] [World Server] Deleted 0 stale player corpses from database
[09-13-2015 :: 00:01:43] [World Server] Loading adventures...
[09-13-2015 :: 00:01:43] [World Server] Purging expired instances
[09-13-2015 :: 00:01:43] [World Server] Loading char create info...
[09-13-2015 :: 00:01:43] [World Server] Zone (TCP) listener started.
[09-13-2015 :: 00:01:43] [World Server] Client (UDP) listener started.
[09-13-2015 :: 00:01:50] [World Server] New TCP connection from 127.0.0.1:51461
[09-13-2015 :: 00:01:50] [World Server] New TCP connection from 127.0.0.1:51464
[09-13-2015 :: 00:01:50] [World Server] New TCP connection from 127.0.0.1:51465
[09-13-2015 :: 00:01:55] [World Server] New TCP connection from 127.0.0.1:51468
[09-13-2015 :: 00:03:05] [World Server] New TCP connection from 127.0.0.1:51472
[09-13-2015 :: 00:03:05] [World Server] New TCP connection from 127.0.0.1:51474
[09-13-2015 :: 00:03:05] [World Server] New TCP connection from 127.0.0.1:51476
[09-13-2015 :: 00:03:05] [World Server] New TCP connection from 127.0.0.1:51478
It doesn't seem to be critical, Everything seems to work and I even tested it by taking a newb character out to kill him and there was a new entry for him in character_corpses.
__________________
"We are all on the same team, and I think not enough people realize this."
- Leetsauce
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:45 AM.


 

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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3