["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

Tried Runner85sx's fix here. Tried starting worldserver.exe, throws failed to connect to character db error. Auth and world connects fine.

Update:

Fixed.

Changed:

 KEY `Idx_player` (`player`),

To:

KEY `Idx_player` (`guid`),

Thanks pek2011.

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

-Core Commit: c9fb6011743fe2cf95c9

-DB Commit(Attempted): 3993b73925c8ef344100

-OS: Windows Web Server 2008 R2

-SQL GUI: SQLyog Community v9.0

-SQL GUI2: Navicat Lite v9.1.9

-MySQL: MySQL Workbench 5.2.31

Query:

ALTER TABLE `channels` CHANGE COLUMN `m_name` `name` varchar(128) NOT NULL,

  CHANGE COLUMN `m_team` `team` int(10) unsigned NOT NULL,

  CHANGE COLUMN `m_announce` `announce` tinyint(3) unsigned NOT NULL DEFAULT '1',

  CHANGE COLUMN `m_ownership` `ownership` tinyint(3) unsigned NOT NULL DEFAULT '1',

  CHANGE COLUMN `m_password` `password` varchar(32) DEFAULT NULL,

  CHANGE COLUMN `BannedList` `bannedList` text,

  CHANGE COLUMN `last_used` `lastUsed` int(10) unsigned NOT NULL


Error occured at:2011-04-14 03:23:24

Line no.:8

Error Code: 1146 - Table 'aero_characters.channels' doesn't exist


Query:

CREATE TABLE `corpse` (

  `corpseGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',

  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',

  `posX` float NOT NULL DEFAULT '0',

  `posY` float NOT NULL DEFAULT '0',

  `posZ` float NOT NULL DEFAULT '0',

  `orientation` float NOT NULL DEFAULT '0',

  `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',

  `phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1',

  `displayId` int(10) unsigned NOT NULL DEFAULT '0',

  `itemCache` text NOT NULL,

  `bytes1` int(10) unsigned NOT NULL DEFAULT '0',

  `bytes2` int(10) unsigned NOT NULL DEFAULT '0',

  `guildId` int(10) unsigned NOT NULL DEFAULT '0',

  `flags` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `dynFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `time` int(10) unsigned NOT NULL DEFAULT '0',

  `corpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',

  PRIMARY KEY (`guid`),

  KEY `idx_type` (`corpseType`),

  KEY `instance` (`instanceId`),

  KEY `Idx_player` (`player`),

  KEY `Idx_time` (`time`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Death System'


Error occured at:2011-04-14 03:24:03

Line no.:1220

Error Code: 1072 - Key column 'player' doesn't exist in table


Query:

INSERT INTO character_queststatus_rewarded SELECT guid, quest FROM character_queststatus WHERE rewarded = 1


Error occured at:2011-04-14 03:27:30

Line no.:9

Error Code: 1054 - Unknown column 'rewarded' in 'where clause'


Query:

CREATE TABLE `corpse` (

  `corpseGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',

  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',

  `posX` float NOT NULL DEFAULT '0',

  `posY` float NOT NULL DEFAULT '0',

  `posZ` float NOT NULL DEFAULT '0',

  `orientation` float NOT NULL DEFAULT '0',

  `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',

  `phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1',

  `displayId` int(10) unsigned NOT NULL DEFAULT '0',

  `itemCache` text NOT NULL,

  `bytes1` int(10) unsigned NOT NULL DEFAULT '0',

  `bytes2` int(10) unsigned NOT NULL DEFAULT '0',

  `guildId` int(10) unsigned NOT NULL DEFAULT '0',

  `flags` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `dynFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `time` int(10) unsigned NOT NULL DEFAULT '0',

  `corpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',

  PRIMARY KEY (`guid`),

  KEY `idx_type` (`corpseType`),

  KEY `instance` (`instanceId`),

  KEY `Idx_player` (`player`),

  KEY `Idx_time` (`time`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Death System'


Error occured at:2011-04-14 04:39:13

Line no.:1220

Error Code: 1072 - Key column 'player' doesn't exist in tabl