Jump to content
  • 0

[Zero] [SOLVED]I need help to import BD

hudinho

Asked by hudinho,

Question

hudinho Member

hudinho

Posted
Posted

whenever I try to import s1900_12370_02_mangos_npc_vendor_template.sql of error in SQLyog and I already have s1900_12370_01_mangos_npc_vendor.sql someone help me?

what is missing?

sorry my bad english

7 answers to this question

Recommended Posts

hudinho Member

hudinho

Posted
  • Author
Posted

I first try to import s1900_12370_01_mangos_npc_vendor.sql, everything working

imagem2sy.png

then i try to import the file last necessary s1900_12370_02_mangos_npc_vendor_template.sql

imagem3gj.png

hudinho Member

hudinho

Posted
  • Author
Posted

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-10 09:06:18

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-10 09:06:56

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1894_12364_01_mangos_spell_script_target required_s1900_12370_01_mangos_npc_vendor bit

Error occured at:2013-03-10 09:07:19

Line no.:1

Error Code: 1054 - Unknown column 'required_s1894_12364_01_mangos_spell_script_target' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1894_12364_01_mangos_spell_script_target required_s1900_12370_01_mangos_npc_vendor bit

Error occured at:2013-03-10 09:07:24

Line no.:1

Error Code: 1054 - Unknown column 'required_s1894_12364_01_mangos_spell_script_target' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1820_12269_12_mangos_gossip_menu_option required_s1825_12278_01_mangos_creature_template bit

Error occured at:2013-03-10 09:07:42

Line no.:1

Error Code: 1054 - Unknown column 'required_s1820_12269_12_mangos_gossip_menu_option' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1894_12364_01_mangos_spell_script_target required_s1900_12370_01_mangos_npc_vendor bit

Error occured at:2013-03-10 09:12:26

Line no.:1

Error Code: 1054 - Unknown column 'required_s1894_12364_01_mangos_spell_script_target' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1820_12269_12_mangos_gossip_menu_option required_s1825_12278_01_mangos_creature_template bit

Error occured at:2013-03-10 09:49:39

Line no.:1

Error Code: 1054 - Unknown column 'required_s1820_12269_12_mangos_gossip_menu_option' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s0298_7196_02_mangos_spell_bonus_data required_s0308_7560_01_mangos_gameobject_template bit

Error occured at:2013-03-10 09:50:26

Line no.:1

Error Code: 1054 - Unknown column 'required_s0298_7196_02_mangos_spell_bonus_data' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1878_12344_01_mangos_command required_s1886_12349_01_mangos_dbscripts_on_creature_death bit

Error occured at:2013-03-10 09:53:48

Line no.:1

Error Code: 1054 - Unknown column 'required_s1878_12344_01_mangos_command' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1820_12269_12_mangos_gossip_menu_option required_s1825_12278_01_mangos_creature_template bit

Error occured at:2013-03-10 09:53:53

Line no.:1

Error Code: 1054 - Unknown column 'required_s1820_12269_12_mangos_gossip_menu_option' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1825_12278_01_mangos_creature_template required_s1826_12279_01_mangos_creature_template bit

Error occured at:2013-03-10 09:54:00

Line no.:1

Error Code: 1054 - Unknown column 'required_s1825_12278_01_mangos_creature_template' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1826_12279_01_mangos_creature_template required_s1878_12344_01_mangos_command bit

Error occured at:2013-03-10 09:54:05

Line no.:1

Error Code: 1054 - Unknown column 'required_s1826_12279_01_mangos_creature_template' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1886_12349_01_mangos_dbscripts_on_creature_death required_s1894_12364_01_mangos_spell_script_target bit

Error occured at:2013-03-10 09:54:11

Line no.:1

Error Code: 1054 - Unknown column 'required_s1886_12349_01_mangos_dbscripts_on_creature_death' in 'db_version'

Query:

ALTER TABLE `character_inventory` ADD `bag` TINYINT( 3 ) DEFAULT '0' NOT NULL AFTER `guid`

Error occured at:2013-03-10 09:54:42

Line no.:1

Error Code: 1146 - Table 'mangos.character_inventory' doesn't exist

Query:

ALTER TABLE `npc_trainer` CHANGE `guid` `entry` INT( 11 ) NOT NULL DEFAULT '0'

Error occured at:2013-03-10 09:54:56

Line no.:1

Error Code: 1054 - Unknown column 'guid' in 'npc_trainer'

Query:

ALTER TABLE `item_template` CHANGE `RequiredRaputationRank` `RequiredReputationRank` INT( 30 ) unsigned NOT NULL DEFAULT '0'

Error occured at:2013-03-10 09:55:10

Line no.:1

Error Code: 1054 - Unknown column 'RequiredRaputationRank' in 'item_template'

Query:

ALTER TABLE `character_inventory` ADD `bag` TINYINT( 3 ) DEFAULT '0' NOT NULL AFTER `guid`

Error occured at:2013-03-10 09:55:28

Line no.:1

Error Code: 1146 - Table 'mangos.character_inventory' doesn't exist

Query:

CREATE DATABASE `realmd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2013-03-10 10:08:39

Line no.:5

Error Code: 1007 - Can't create database 'realmd'; database exists

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1878_12344_01_mangos_command required_s1886_12349_01_mangos_dbscripts_on_creature_death bit

Error occured at:2013-03-10 11:06:24

Line no.:1

Error Code: 1146 - Table 'mangos.db_version' doesn't exist

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1820_12269_12_mangos_gossip_menu_option required_s1825_12278_01_mangos_creature_template bit

Error occured at:2013-03-10 11:33:09

Line no.:1

Error Code: 1054 - Unknown column 'required_s1820_12269_12_mangos_gossip_menu_option' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1820_12269_12_mangos_gossip_menu_option required_s1825_12278_01_mangos_creature_template bit

Error occured at:2013-03-10 12:28:09

Line no.:1

Error Code: 1054 - Unknown column 'required_s1820_12269_12_mangos_gossip_menu_option' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-10 12:29:49

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-10 12:30:08

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1894_12364_01_mangos_spell_script_target required_s1900_12370_01_mangos_npc_vendor bit

Error occured at:2013-03-10 12:30:34

Line no.:1

Error Code: 1054 - Unknown column 'required_s1894_12364_01_mangos_spell_script_target' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1894_12364_01_mangos_spell_script_target required_s1900_12370_01_mangos_npc_vendor bit

Error occured at:2013-03-10 12:30:39

Line no.:1

Error Code: 1054 - Unknown column 'required_s1894_12364_01_mangos_spell_script_target' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1894_12364_01_mangos_spell_script_target required_s1900_12370_01_mangos_npc_vendor bit

Error occured at:2013-03-10 12:31:30

Line no.:1

Error Code: 1146 - Table 'characters.db_version' doesn't exist

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-10 12:31:36

Line no.:1

Error Code: 1146 - Table 'characters.db_version' doesn't exist

Query:

CREATE DATABASE `mangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2013-03-10 12:32:31

Line no.:1

Error Code: 1007 - Can't create database 'mangos'; database exists

Query:

CREATE OR REPLACE FUNCTION unix_timestamp() RETURNS bigint AS '

SELECT EXTRACT(EPOCH FROM CURRENT_TIMESTAMP(0))::bigint AS result;

' LANGUAGE 'SQL'

Error occured at:2013-03-10 12:32:50

Line no.:12

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 'FUNCTION unix_timestamp() RETURNS bigint AS '

SELECT EXTRACT(EPOCH FROM CURR' at line 1

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-10 12:33:10

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_s1350_11716_08_characters_instance_reset required_s1350_11716_09_characters_mail bit

Error occured at:2013-03-10 12:35:03

Line no.:1

Error Code: 1146 - Table 'characters.character_db_version' doesn't exist

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-10 13:48:25

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1820_12269_12_mangos_gossip_menu_option required_s1825_12278_01_mangos_creature_template bit

Error occured at:2013-03-10 13:48:29

Line no.:1

Error Code: 1054 - Unknown column 'required_s1820_12269_12_mangos_gossip_menu_option' in 'db_version'

Query:

DELETE FROM sd2_db_version

Error occured at:2013-03-10 14:51:59

Line no.:5

Error Code: 1146 - Table 'scriptdev2.sd2_db_version' doesn't exist

Query:

CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2013-03-10 14:52:08

Line no.:1

Error Code: 1007 - Can't create database 'scriptdev2'; database exists

Query:

/* */

/* AREATRIGGER */

DELETE FROM scripted_areatrigger WHERE entry=4591

Error occured at:2013-03-10 14:52:33

Line no.:4

Error Code: 1146 - Table 'scriptdev2.scripted_areatrigger' doesn't exist

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1894_12364_01_mangos_spell_script_target required_s1900_12370_01_mangos_npc_vendor bit

Error occured at:2013-03-10 14:55:24

Line no.:1

Error Code: 1054 - Unknown column 'required_s1894_12364_01_mangos_spell_script_target' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1894_12364_01_mangos_spell_script_target required_s1900_12370_01_mangos_npc_vendor bit

Error occured at:2013-03-10 14:56:23

Line no.:1

Error Code: 1054 - Unknown column 'required_s1894_12364_01_mangos_spell_script_target' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-10 15:02:48

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_020_7643_01_mangos_db_version required_029_7393_01_mangos_game_event bit

Error occured at:2013-03-10 15:03:02

Line no.:1

Error Code: 1054 - Unknown column 'required_020_7643_01_mangos_db_version' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_020_7643_01_mangos_db_version required_029_7393_01_mangos_game_event bit

Error occured at:2013-03-10 15:03:23

Line no.:1

Error Code: 1054 - Unknown column 'required_020_7643_01_mangos_db_version' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1820_12269_12_mangos_gossip_menu_option required_s1825_12278_01_mangos_creature_template bit

Error occured at:2013-03-10 15:10:06

Line no.:1

Error Code: 1054 - Unknown column 'required_s1820_12269_12_mangos_gossip_menu_option' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1825_12278_01_mangos_creature_template required_s1826_12279_01_mangos_creature_template bit

Error occured at:2013-03-10 15:10:12

Line no.:1

Error Code: 1054 - Unknown column 'required_s1825_12278_01_mangos_creature_template' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1826_12279_01_mangos_creature_template required_s1878_12344_01_mangos_command bit

Error occured at:2013-03-10 15:10:17

Line no.:1

Error Code: 1054 - Unknown column 'required_s1826_12279_01_mangos_creature_template' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1878_12344_01_mangos_command required_s1886_12349_01_mangos_dbscripts_on_creature_death bit

Error occured at:2013-03-10 15:10:23

Line no.:1

Error Code: 1054 - Unknown column 'required_s1878_12344_01_mangos_command' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1886_12349_01_mangos_dbscripts_on_creature_death required_s1894_12364_01_mangos_spell_script_target bit

Error occured at:2013-03-10 15:10:31

Line no.:1

Error Code: 1054 - Unknown column 'required_s1886_12349_01_mangos_dbscripts_on_creature_death' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1894_12364_01_mangos_spell_script_target required_s1900_12370_01_mangos_npc_vendor bit

Error occured at:2013-03-10 15:10:36

Line no.:1

Error Code: 1054 - Unknown column 'required_s1894_12364_01_mangos_spell_script_target' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-10 15:10:42

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s0298_7196_02_mangos_spell_bonus_data required_s0308_7560_01_mangos_gameobject_template bit

Error occured at:2013-03-10 15:15:54

Line no.:1

Error Code: 1054 - Unknown column 'required_s0298_7196_02_mangos_spell_bonus_data' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_020_7643_01_mangos_db_version required_029_7393_01_mangos_game_event bit

Error occured at:2013-03-10 15:22:02

Line no.:1

Error Code: 1054 - Unknown column 'required_020_7643_01_mangos_db_version' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_2008_12_15_01_mangos_arenas required_020_7643_01_mangos_db_version bit

Error occured at:2013-03-10 15:22:58

Line no.:1

Error Code: 1054 - Unknown column 'required_2008_12_15_01_mangos_arenas' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_2008_11_29_02_mangos_spell_elixir required_2008_12_15_01_mangos_arenas bit

Error occured at:2013-03-10 15:23:34

Line no.:1

Error Code: 1054 - Unknown column 'required_2008_11_29_02_mangos_spell_elixir' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-11 15:50:48

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-11 15:52:17

Line no.:1

Error Code: 1146 - Table 'characters.db_version' doesn't exist

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_s1099_11299_02_characters_pet_aura required_11391_01_characters_auction bit

Error occured at:2013-03-11 17:47:23

Line no.:11

Error Code: 1054 - Unknown column 'required_s1099_11299_02_characters_pet_aura' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_s1099_11299_02_characters_pet_aura required_11391_01_characters_auction bit

Error occured at:2013-03-11 17:47:35

Line no.:11

Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-11 18:02:07

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1820_12269_12_mangos_gossip_menu_option required_s1825_12278_01_mangos_creature_template bit

Error occured at:2013-03-11 18:02:28

Line no.:1

Error Code: 1054 - Unknown column 'required_s1820_12269_12_mangos_gossip_menu_option' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1825_12278_01_mangos_creature_template required_s1826_12279_01_mangos_creature_template bit

Error occured at:2013-03-11 18:02:33

Line no.:1

Error Code: 1054 - Unknown column 'required_s1825_12278_01_mangos_creature_template' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1826_12279_01_mangos_creature_template required_s1878_12344_01_mangos_command bit

Error occured at:2013-03-11 18:02:40

Line no.:1

Error Code: 1054 - Unknown column 'required_s1826_12279_01_mangos_creature_template' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s0298_7196_02_mangos_spell_bonus_data required_s0308_7560_01_mangos_gameobject_template bit

Error occured at:2013-03-11 18:03:04

Line no.:1

Error Code: 1054 - Unknown column 'required_s0298_7196_02_mangos_spell_bonus_data' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-12 13:36:51

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

CREATE DATABASE `mangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2013-03-12 13:38:22

Line no.:1

Error Code: 1007 - Can't create database 'mangos'; database exists

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1894_12364_01_mangos_spell_script_target required_s1900_12370_01_mangos_npc_vendor bit

Error occured at:2013-03-12 13:47:40

Line no.:1

Error Code: 1054 - Unknown column 'required_s1894_12364_01_mangos_spell_script_target' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1826_12279_01_mangos_creature_template required_s1878_12344_01_mangos_command bit

Error occured at:2013-03-12 13:48:57

Line no.:1

Error Code: 1054 - Unknown column 'required_s1826_12279_01_mangos_creature_template' in 'db_version'

Query:

ALTER TABLE characters

CHANGE COLUMN gmstate extra_flags int(11) unsigned NOT NULL default '0'

Error occured at:2013-03-12 13:49:35

Line no.:2

Error Code: 1146 - Table 'mangos.characters' doesn't exist

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1894_12364_01_mangos_spell_script_target required_s1900_12370_01_mangos_npc_vendor bit

Error occured at:2013-03-12 13:50:17

Line no.:1

Error Code: 1054 - Unknown column 'required_s1894_12364_01_mangos_spell_script_target' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1691_12112_01_mangos_spell_template required_s1692_12113_01_mangos_spell_template bit

Error occured at:2013-03-12 13:53:22

Line no.:1

Error Code: 1054 - Unknown column 'required_s1691_12112_01_mangos_spell_template' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_035_7855_01_mangos_pools required_039_7896_01_mangos_creature_template bit

Error occured at:2013-03-12 13:53:28

Line no.:1

Error Code: 1054 - Unknown column 'required_035_7855_01_mangos_pools' in 'db_version'

Query:

/*

DROP TABLE IF EXISTS script_waypoint;

CREATE TABLE `script_waypoint` (

`entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template `entry`',

pointid mediumint(8) unsigned NOT NULL DEFAULT '0',

location_x float NOT NULL DEFAULT '0',

location_y float NOT NULL DEFAULT '0',

location_z float NOT NULL DEFAULT '0',

waittime int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'waittime in millisecs',

point_comment text,

PRIMARY KEY (entry, pointid)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints';

*/

DELETE FROM `script_waypoint` WHERE `entry`=24156

Error occured at:2013-03-12 20:43:13

Line no.:16

Error Code: 1146 - Table 'world.script_waypoint' doesn't exist

Query:

CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2013-03-12 21:04:12

Line no.:1

Error Code: 1007 - Can't create database 'scriptdev2'; database exists

Query:

Unable to establish connection

Error occured at:2013-03-13 19:18:14

Line no.:0

Error Code: 1045 - Access denied for user 'root'@'localhost' (using password: YES)

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-13 19:37:19

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-13 19:38:09

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-13 19:39:09

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-13 19:42:16

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-13 19:50:52

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1886_12349_01_mangos_dbscripts_on_creature_death required_s1894_12364_01_mangos_spell_script_target bit

Error occured at:2013-03-13 19:53:27

Line no.:1

Error Code: 1054 - Unknown column 'required_s1886_12349_01_mangos_dbscripts_on_creature_death' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-13 20:37:58

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-13 20:38:00

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-14 11:43:24

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-14 11:44:20

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-14 11:46:45

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-14 11:46:55

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_s1900_12370_01_mangos_npc_vendor required_s1900_12370_02_mangos_npc_vendor_template bit

Error occured at:2013-03-14 15:20:32

Line no.:1

Error Code: 1054 - Unknown column 'required_s1900_12370_01_mangos_npc_vendor' in 'db_version'

japtenks Advanced Member

japtenks

Posted
Posted

Manually with your sql editor, edit the table db_version properties, and set the column name to "required_s1900_12370_01_mangos_npc_vendor ",

then rerun the query and it should work.

Archived

This topic is now archived and is closed to further replies.

Go to question listing

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use