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