zenko

May 14, 2013

Basicly I was having a problem starting the server, got the error : [1054] Unknown column 'id' in 'field list'

I tried to apply all the update patches, but got some errors due to previsouly attempts? So I decided to execute drop_mysql file and start over.

I executed create_mysql and auth_database.sql without problems, but when I executed characters_database.sql I got the error:

USE `characters`;
/*!40000 ALTER TABLE `calendar_events` ENABLE KEYS */;UNLOCK TABLES;--
-- Table structure for table `calendar_invites`
--

DROP TABLE IF EXISTS `calendar_invites`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `calendar_invites` (
  `id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `event` bigint(20) unsigned NOT NULL DEFAULT '0',
  `invitee` int(10) unsigned NOT NULL DEFAULT '0',
  `sender` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `statustime` int(10) unsigned NOT NULL DEFAULT '0',
  `rank` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `text` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `calendar_invites`
--

LOCK TABLES `calendar_invites` WRITE;/*!40000 ALTER TABLE `calendar_invites` DISABLE KEYS */;/*!40000 ALTER TABLE `calendar_invites` ENABLE KEYS */;UNLOCK TABLES;--
-- Table structure for table `channels`
--

DROP TABLE IF EXISTS `channels`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `channels` (
  `name` varchar(128) NOT NULL,
  `team` int(10) unsigned NOT NULL,
  `announce` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `ownership` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `password` varchar(32) DEFAULT NULL,
  `bannedList` text,
  `lastUsed` int(10) unsigned NOT NULL,
  PRIMARY KEY (`name`,`team`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Channel System';/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `channels`
--

LOCK TABLES `channels` WRITE;/*!40000 ALTER TABLE `channels` DISABLE KEYS */;/*!40000 ALTER TABLE `channels` ENABLE KEYS */;UNLOCK TABLES;--
-- Table structure for table `character_account_data`
--

DROP TABLE IF EXISTS `character_account_data`;/* large SQL query (4,4 KB), snipped at 2 000 characters */
/* SQL Error (1146): Table 'characters.calendar_events' doesn't exist */
/* 0 rows affected, 0 rows found. Duration for 98 of 776 queries: 0,873 sec. */

May 14, 2013

So I had to start over again at heidisql, with some errors in the worldserver.exe

After I've dropped all tables and started all over again, I entered a new problem trying to execute characters_database.sql in "characters"

I get this error:

/* SQL Error (1146): Table 'characters.calendar_events' doesn't exist */
/* 0 rows affected, 0 rows found. Duration for 98 of 776 queries: 0,951 sec. */

How do I fix this (im not the best in mysql), and why does this happen now, when it didnt before?

May 13, 2013

Can't seem to get this problem fixed:


Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1c 10 May 2012 (library: OpenSSL 1.0.1e 11 Feb 2013)
Using ACE version: 6.1.4
TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                       __
/__  _       __          __/ __
/_/ / _ __ /_    ___ /_ , _  __  __
     /`'__/  /' _ `/   / / / 
        /   / /     _  _ 
      _ _   _ _ _ _ __/`____ 
      /_//_/   /_//_//_//_//__/ `/___/> 
                                 C O R E  /___/
http://TrinityCore.org                    /__/

Realm running as realm ID 1
Using World DB: TDB 434.04
Using enUS DBC Locale
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir ./
WORLD: MMap data directory is: ./mmaps
VMap support included. LineOfSight: 1, getHeight: 1, indoorCheck: 1
VMap data directory is: ./vmaps
Loading Trinity strings...
>> Loaded 942 Trinity strings from table trinity_string in 2 ms
Initialize data stores...
Index 3136 already exists in dbc:'spelldifficulty_dbc'
spelldifficulty_dbc: spell 71356 at field id:2108 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 71803 at field id:2108 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 72111 at field id:2136 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 72125 at field id:2136 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 70816 at field id:2146 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 72233 at field id:2146 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 72234 at field id:2146 at spellid2 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 72235 at field id:2146 at spellid3 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 42636 at field id:2202 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 45433 at field id:2203 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 90120 at field id:3251 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 92943 at field id:3251 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 90059 at field id:3255 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 92948 at field id:3255 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 89289 at field id:3258 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 92951 at field id:3258 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 75621 at field id:3523 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 94991 at field id:3523 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 75708 at field id:3579 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 95858 at field id:3579 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 92666 at field id:3582 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 95884 at field id:3582 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 98192 at field id:3741 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 98846 at field id:3741 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 98900 at field id:3749 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 99288 at field id:3749 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 98899 at field id:3752 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 99551 at field id:3752 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 99877 at field id:3764 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 99878 at field id:3764 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 107352 at field id:4343 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 108859 at field id:4343 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110615 at field id:4343 at spellid2 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110614 at field id:4343 at spellid3 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110035 at field id:4444 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110034 at field id:4444 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110033 at field id:4444 at spellid2 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110032 at field id:4444 at spellid3 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 103179 at field id:4469 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110515 at field id:4469 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
Some required *.dbc files (1 from 138) not found or not compatible:
./dbc/SpellDifficulty.dbc exists, and has 5 field(s) (expected 5). Extracted file might be from wrong client version or a database-update has been forgotten.

I've seen more people with this problem. I've added 2012_12_27_00_world_spelldifficulty_dbc_434.sql, 2013_05_11_00_world_spelleffect_dbc_434.sql etc..

May 13, 2013

Problem solved, sorry for taking your time

ALTER TABLE `creature_template` ADD COLUMN `unit_flags2` INT(10) NULL DEFAULT '1' AFTER `unit_flags`;

Just had to add this to creature_template in mysql

May 13, 2013

Im following this one: http://collab.kpsn.org/display/tc/How-To_Win+4.3.4#How-To_Win4.3.4-MySQLServerCommunityEdition

Still the same error: "SQL Error (1054): Unknown column 'unit_flags2' in 'field list'"

May 13, 2013

Found this https://github.com/WoWCyberzone/Database-4.3.4 and executed world_updates.sql, but it stops half way with the error: "SQL Error (1054): Unknown column 'unit_flags2' in 'field list'"

May 13, 2013

Now it is required to apply current, existing updates.

Located in the C:TrinityDBUpdates_02 folder:
You will find a Windows Batch File named merge_updates_windows.bat - run it, and a new file will appear called world_updates.sql

I've cloned and downloaded the content for TrinityDB, but there is no "Updates_02" folder, nor a merge_updates_windows.bat in any of these folders.

There is a tool folder where merge_windows.bat is, but when I push it, the screen flashes and nothing is happening.

Any idea what I have to do?

Sign In

zenko

Posts

Joined

Last visited

Content Type

Forums

Posts posted by zenko

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

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

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

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

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

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

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

Repos

Browse

Activity