View Single Post
  #11  
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