zenko

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. */

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?

Can't seem to get this problem fixed: 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..

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

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'"

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'"

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?