I get this error when i try to execute the mysql files (Character, realmd):
Realmd (i just continue on error):
Code:
[Err] 1146 - Table 'mysql.time_zone_name' doesn't exist
[Err] /*!40103 SET TIME_ZONE='+00:00' */;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/*
--
-- Table structure for table `character_db_version`
--
DROP TABLE IF EXI' at line 7
[Err] /*
--
-- Table structure for table `character_db_version`
--
DROP TABLE IF EXISTS `character_db_version`;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/
--
-- Table structure for table `account_data`
--
DROP TABLE IF EXISTS `acc' at line 1
[Err] */
--
-- Table structure for table `account_data`
--
DROP TABLE IF EXISTS `account_data`;
[Err] 1146 - Table 'mysql.time_zone_name' doesn't exist
[Err] /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Character (i just continue on error):
Code:
[Err] 1146 - Table 'mysql.time_zone_name' doesn't exist
[Err] /*!40103 SET TIME_ZONE='+00:00' */;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/*
--
-- Table structure for table `character_db_version`
--
DROP TABLE IF EXI' at line 7
[Err] /*
--
-- Table structure for table `character_db_version`
--
DROP TABLE IF EXISTS `character_db_version`;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/
--
-- Table structure for table `account_data`
--
DROP TABLE IF EXISTS `acc' at line 1
[Err] */
--
-- Table structure for table `account_data`
--
DROP TABLE IF EXISTS `account_data`;
[Err] 1146 - Table 'mysql.time_zone_name' doesn't exist
[Err] /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
When i run the TrinityCore i get this error:
Code:
2009-09-23 16:56:26 MySQL client library: 5.0.56
2009-09-23 16:56:26 MySQL server ver: 5.0.67-community-nt
2009-09-23 16:56:26 MySQL client library: 5.0.56
2009-09-23 16:56:26 MySQL server ver: 5.0.67-community-nt
2009-09-23 16:56:26 MySQL client library: 5.0.56
2009-09-23 16:56:26 MySQL server ver: 5.0.67-community-nt
2009-09-23 16:56:26 Realm running as realm ID 1
2009-09-23 16:56:26 Using World DB: YTDB 509 For Trinity
2009-09-23 16:56:26 Using creature EventAI: ACID 3.0.0 - Full Release
2009-09-23 16:56:26 Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
2009-09-23 16:56:26 Visibility. Distance .Creature can't be greater 165.666656
2009-09-23 16:56:26 Visibility.Distance.Object can't be greater 156.666656
2009-09-23 16:56:26 Using DataDir ./
2009-09-23 16:56:26 WORLD: VMap support included. LineOfSight:0, getHeight:0
2009-09-23 16:56:26 WORLD: VMap data directory is: ./vmaps
2009-09-23 16:56:26 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2009-09-23 16:56:26 ERROR: Check existing of map file './maps/0004331.map': not exist!
2009-09-23 16:56:26 ERROR: Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the Trinityd.conf file.
Any idea?