urlick

Problem solved , now still only another 1. When i start AUTHSERVER it start w/o problems, WORLDSERVER stuck at Loading Items . . . No errors in log file.

i will try

its TDB_full_335.11.39_2011_04_02 downloaded from the wiki site -.-

Hello. I followed the guidance offered dall'info of Trinity. I ran all the steps without any problem, but came to setting the databse I found some problems. The first was to use the file create_mysql, which offers me an error 1146 TABLE user.mysql dosent exist The second is to upload the file FULL_DB trinity which returns me the following errors, including the former. Query: DROP TABLE IF EXISTS `custom_texts` Error occured at:2011-05-16 00:38:48 Line no.:1 Error Code: 1046 - No database selected Query: DROP TABLE IF EXISTS `custom_texts` Error occured at:2011-05-16 00:38:51 Line no.:1 Error Code: 1046 - No database selected Query: ALTER TABLE character_db_version CHANGE COLUMN required_10254_01_characters_auctionhouse required_10312_01_characters_character_aura bit Error occured at:2011-05-16 01:18:23 Line no.:2 Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist Query: ALTER TABLE db_version CHANGE COLUMN required_10257_01_mangos_command required_10263_01_mangos_pool_creature bit Error occured at:2011-05-16 01:18:57 Line no.:2 Error Code: 1054 - Unknown column 'required_10257_01_mangos_command' in 'db_version' Query: ALTER TABLE db_version CHANGE COLUMN required_10257_01_mangos_command required_10263_01_mangos_pool_creature bit Error occured at:2011-05-16 01:20:10 Line no.:2 Error Code: 1054 - Unknown column 'required_10257_01_mangos_command' in 'db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_10664_01_characters_arena_team_stats required_10862_01_characters_mail bit Error occured at:2011-05-16 01:20:59 Line no.:2 Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist Query: ALTER TABLE character_db_version CHANGE COLUMN required_10254_01_characters_auctionhouse required_10312_01_characters_character_aura bit Error occured at:2011-05-16 01:25:09 Line no.:2 Error Code: 1054 - Unknown column 'required_10254_01_characters_auctionhouse' in 'character_db_version' Query: ALTER TABLE db_version CHANGE COLUMN required_10365_01_mangos_creature_ai_scripts required_10381_01_mangos_creature_model_race bit Error occured at:2011-05-16 01:30:01 Line no.:1 Error Code: 1054 - Unknown column 'required_10365_01_mangos_creature_ai_scripts' in 'db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_11299_02_characters_pet_aura required_11391_01_characters_auction bit Error occured at:2011-05-16 01:31:10 Line no.:1 Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist Query: ALTER TABLE db_version CHANGE COLUMN required_11453_01_mangos_spell_proc_event required_11489_01_mangos_creature_template bit Error occured at:2011-05-16 01:41:55 Line no.:1 Error Code: 1054 - Unknown column 'required_11453_01_mangos_spell_proc_event' in 'db_version' Query: /*!50003 DROP PROCEDURE IF EXISTS `sp_delete_loot` */ Error occured at:2011-06-17 10:57:01 Line no.:5267 Error Code: 1146 - Table 'mysql.proc' doesn't exist Query: /*!50003 DROP PROCEDURE IF EXISTS `sp_delete_loot` */ Error occured at:2011-06-17 10:59:07 Line no.:4 Error Code: 1146 - Table 'mysql.proc' doesn't exist Query: DROP TABLE IF EXISTS `access_requirement` Error occured at:2011-06-17 11:00:12 Line no.:22 Error Code: 1044 - Access denied for user 'root'@'localhost' to database 'information_schema' Query: /*!50003 DROP PROCEDURE IF EXISTS `sp_delete_loot` */ Error occured at:2011-06-17 11:01:32 Line no.:5267 Error Code: 1146 - Table 'mysql.proc' doesn't exist Query: GRANT USAGE ON * . * TO 'trinity'@'localhost' IDENTIFIED BY 'trinity' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 Error occured at:2011-06-17 11:02:50 Line no.:1 Error Code: 1146 - Table 'mysql.user' doesn't exist Query: GRANT USAGE ON * . * TO 'trinity'@'localhost' IDENTIFIED BY 'trinity' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 Error occured at:2011-06-17 11:03:02 Line no.:1 Error Code: 1146 - Table 'mysql.user' doesn't exist Query: GRANT USAGE ON * . * TO 'trinity'@'localhost' IDENTIFIED BY 'trinity' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 Error occured at:2011-06-17 11:03:08 Line no.:1 Error Code: 1146 - Table 'mysql.user' doesn't exist Query: /*!50003 DROP PROCEDURE IF EXISTS `sp_delete_loot` */ Error occured at:2011-06-17 11:07:38 Line no.:5267 Error Code: 1146 - Table 'mysql.proc' doesn't exist Query: +++DO NOT IMPORT THIS UNLESS YOU WANT A *BLANK* DATABASE.+++ /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */ Error occured at:2011-06-17 11:08:15 Line no.:9 Error Code: 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 '+++DO NOT IMPORT THIS UNLESS YOU WANT A *BLANK* DATABASE.+++ /*!40101 SET @OLD_C' at line 1 Query: /*!50003 DROP PROCEDURE IF EXISTS `sp_delete_loot` */ Error occured at:2011-06-17 14:33:39 Line no.:5267 Error Code: 1146 - Table 'mysql.proc' doesn't exist 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-06-17 15:38:12 Line no.:8 Error Code: 1054 - Unknown column 'm_name' in 'channels' Query: /*!50003 DROP PROCEDURE IF EXISTS `sp_delete_loot` */ Error occured at:2011-06-17 15:38:55 Line no.:5241 Error Code: 1146 - Table 'mysql.proc' doesn't exist Query: /*!50003 DROP PROCEDURE IF EXISTS `sp_delete_loot` */ Error occured at:2011-06-17 15:47:29 Line no.:5241 Error Code: 1146 - Table 'mysql.proc' doesn't exist