lol553

ok, got it working, but i have 1 more question how do you teleport to alterac valley?

Ok i updated the db now but i get: ERROR:Error in item_template table, probably sql file format was updated (there should be 138 fields in sql).

What is wrong with it right now?

Ok, from the guides I've read, it seems that to update mangos alone, you have to like manually execute all the sql files, which is like a 100. Am I doing it the wrong way?

i dont get it?

UDB forums have been down for like 2 weeks.

Well... none of the guides explain what to do after you execute mangos.sql and the udb.sql file to update it. Can someone please explain what files to execute in order.

i get Query: DROP TABLE IF EXISTS `access_requirement` Error occured at:2010-08-28 08:47:47 Line no.:22 Error Code: 1046 - No database selected Query: DROP TABLE IF EXISTS `account_data` Error occured at:2010-08-28 08:58:05 Line no.:22 Error Code: 1109 - Unknown table 'account_data' in information_schema Query: CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci Error occured at:2010-08-28 08:59:20 Line no.:3 Error Code: 1007 - Can't create database 'world'; database exists Query: ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit Error occured at:2010-08-28 16:56:33 Line no.:2 Error Code: 1054 - Unknown column 'required_9250_01_characters_character' in 'character_db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit Error occured at:2010-08-28 16:57:00 Line no.:2 Error Code: 1054 - Unknown column 'required_9250_01_characters_character' in 'character_db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit Error occured at:2010-08-28 16:58:45 Line no.:2 Error Code: 1054 - Unknown column 'required_9250_01_characters_character' in 'character_db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_9246_01_characters_character required_9250_01_characters_character bit Error occured at:2010-08-28 16:59:33 Line no.:1 Error Code: 1054 - Unknown column 'required_9246_01_characters_character' in 'character_db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_9246_01_characters_character required_9250_01_characters_character bit Error occured at:2010-08-28 17:06:05 Line no.:1 Error Code: 1054 - Unknown column 'required_9246_01_characters_character' in 'character_db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_9246_01_characters_character required_9250_01_characters_character bit Error occured at:2010-08-28 17:06:55 Line no.:1 Error Code: 1054 - Unknown column 'required_9246_01_characters_character' in 'character_db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_9246_01_characters_character required_9250_01_characters_character bit Error occured at:2010-08-28 17:07:30 Line no.:1 Error Code: 1054 - Unknown column 'required_9246_01_characters_character' in 'character_db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_9246_01_characters_character required_9250_01_characters_character bit Error occured at:2010-08-28 17:07:32 Line no.:1 Error Code: 1054 - Unknown column 'required_9246_01_characters_character' in 'character_db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit Error occured at:2010-08-28 17:09:14 Line no.:2 Error Code: 1054 - Unknown column 'required_9250_01_characters_character' in 'character_db_version' when i try to do the first update