Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

urlick

Plebs
 View Profile  See their activity

  • Posts

    4

  • Joined

  • Last visited

 Content Type 

Posts posted by urlick

  4. "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

    in Help and Support

    Posted

    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

×
×
  • Create New...