Jump to content
TrinityCore

kaotik0fx

Plebs
  • Posts

    2
  • Joined

  • Last visited

kaotik0fx's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. 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.
  2. -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
×
×
  • Create New...