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