Jump to content

  • Announcements

    • Xmat

      Pravidlo pro postování v TTT

      Do sekce Tipy, triky, tutoriály nepatří žádné dotazy.   Postujte sem vaše návody, tipy a různé další věci jež uznáte za vhodné sdělit zdejšímu osazenstvu, ale veškeré dotazy směřujte do sekce Všeobecná diskuse.
    • Replik

      Seznam návodů a důležitých témat v této sekci

      Pro lepší přehlednost jsem vytvořil tento seznam, který vás, méně zkušené, lépe provede touto sekcí. Věřím, že zde najdete, co hledáte. Vypsané jsou návody, které jsou oficiálně uznané jako návody. Běžné diskuze, které neposkytují postupy a rady zvěřejněny nejsou.   Instalace vlastního MaNGOS Serveru Díky těmto návodům budete (měli by jste být) schopni vytvořit a následně spustit váš vlastní server. Nastavení je pro verze s i bez datadisku.   Instalace MaNGOS Serveru (bez datadisku TBC) - Autor Benny Instalace MaNGOS Serveru (s datadiskem TBC) - Autor Malfik Instalace MaNGOS Serveru v prostředí Linux - Autor charlie Instalace MaNGOS Serveru v prostředí Linux - Autor kupkoid   Chyby a jejich řešení při přihlašování k serveru - Autor Cybe   Zálohování uživatelských dat   Dávkový soubor (BAT soubor) pro vytvoření SQL záloh - Autor Replik   Kompilování - tvoření vlastních release (revizí)   Tvorba kompilací pro Win32 (MangoScript) - Autor bLuma   Ostatní - těžko zařaditelné, ale neznamená to, že nejsou dobré   VIP Systém - Autor charlie Tvorba Webových stránek pro MaNGOS - Autor zahuba Tvorba teleportačních NPC (MangoScript) - Autor Replik Registrační web (původně předělaná SPORA) Funkční pro Antrix i MaNGOS - Autor Replik Nastavení a spuštění Minimanager pro MaNGOS - Autor BlackMartin Nastavení MaNGOS Website - Autor Artorius   Samozřejmě jsou zde i jiné návody, ale tyto jsou nejvíce používané, proto věřím, že vám budou nápomocné. Tuto sekci budeme upravovat podle potřeby. Pokud by jste něco nenašli nebo si nevěděli rady, hledejte na fóru a teprve potom založte vlastní topik. Pokud nějaký autor vytvoří kvalitní návod a chtěl by ho zveřejnit i v tomto seznamu, doporučuji, aby mi napsal zprávu skrze PM.   Díky a přeji hezký den na WoWResource   Replik
    • Aristo

      Příspěvky tam, kde nemají co dělat

      Dodržujte zákaz přispívání do topiků s repaky pokud si to zakladatelé nepřejí!! Opakované psaní příspěvků bude trestáno warnem.
    • Aristo

      Používání spoilerů

      Poslední dobou má většina uživatelů fora zvláštní nutkání postovat extrémně dlouhé texty nebo kódy, které zabírají v nejedenom případu i 80% obsahu celé stránky a hodně tak zvedají nepřehlednost v topiku. Chtěl bych všechny uživatele požádat, aby při postování citací, jakýchkoliv kódů, errorů, atp... delších než 30 řádků používali funkci spoileru.   Funkci vyvoláte příkazem [spoiler] text [/spoiler]   Ukázka:  
Kaylo

Problem s kompilaci

By Kaylo, in MaNGOS

Recommended Posts

Kaylo    1

Kaylo
Posted

Pri nahazovani sql filu do db mi vyhazuje tenhle error:

 

 

There was an error while executing a query.
The query and the error message has been loged at C:/User/Kaylo/appdata/roaming/sqlyog/sqlyog.err.

Please click on open error.

 

 

Za pomoc naoplatku pomuzu se skriptami pro web atd...

Share this post

Link to post
Share on other sites

Kaylo    1

Kaylo
Posted (edited)

Kliknu na open error file a otevre mi skript

 

kompilaci proto sem zacatecnik a jeste nevim jak se cemu rika .... tak promin spletl jsem se .... taky te nevysmeju kdyz reknes neco spatne v oblasti PHP kde se vyznam ja ...

 

prikladam i screen:

dberr.th.jpg

 

 


Query:
UPDATE npc_vendor SET maxcount=1 WHERE entry=10118 AND item=6533

Error occured at:2009-11-29 01:14:10
Line no.:1
Error Code: 1146 - Table 'realmd.npc_vendor' doesn't exist

Query:
UPDATE npc_vendor SET maxcount=1 WHERE entry=10118 AND item=6533

Error occured at:2009-11-29 01:14:17
Line no.:1
Error Code: 1146 - Table 'realmd.npc_vendor' doesn't exist

Query:
/*Table structure for table `auctionhousebot` */
ALTER TABLE `auctionhousebot`
 ADD COLUMN `percentgreytradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Grey Trade Goods auction items' AFTER `maxtime`,
 ADD COLUMN `percentorangetradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Orange Trade Goods auction items' AFTER `percentpurpletradegoods`,
 ADD COLUMN `percentyellowtradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Yellow Trade Goods auction items' AFTER `percentorangetradegoods`,
 ADD COLUMN `percentgreyitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Grey auction items' AFTER `percentyellowtradegoods`,
 ADD COLUMN `percentorangeitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Orange auction items' AFTER `percentpurpleitems`,
 ADD COLUMN `percentyellowitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Yellow auction items' AFTER `percentorangeitems`,
 ADD COLUMN `minpricegrey` int(11) default '100' COMMENT 'Minimum price of Grey items (percentage).' AFTER `percentyellowitems`,
 ADD COLUMN `maxpricegrey` int(11) default '150' COMMENT 'Maximum price of Grey items (percentage).' AFTER `minpricegrey`,
 ADD COLUMN `minpriceorange` int(11) default '3250' COMMENT 'Minimum price of Orange items (percentage).' AFTER `maxpricepurple`,
 ADD COLUMN `maxpriceorange` int(11) default '5550' COMMENT 'Maximum price of Orange items (percentage).' AFTER `minpriceorange`,
 ADD COLUMN `minpriceyellow` int(11) default '5250' COMMENT 'Minimum price of Yellow items (percentage).' AFTER `maxpriceorange`,
 ADD COLUMN `maxpriceyellow` int(11) default '6550' COMMENT 'Maximum price of Yellow items (percentage).' AFTER `minpriceyellow`,
 ADD COLUMN `minbidpricegrey` int(11) default '70' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 70' AFTER `maxpriceyellow`,
 ADD COLUMN `maxbidpricegrey` int(11) default '100' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 100' AFTER `minbidpricegrey`,
 ADD COLUMN `minbidpriceorange` int(11) default '80' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 80' AFTER `maxbidpricepurple`,
 ADD COLUMN `maxbidpriceorange` int(11) default '100' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 100' AFTER `minbidpriceorange`,
 ADD COLUMN `minbidpriceyellow` int(11) default '80' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 80' AFTER `maxbidpriceorange`,
 ADD COLUMN `maxbidpriceyellow` int(11) default '100' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 100' AFTER `minbidpriceyellow`,
 ADD COLUMN `maxstackgrey` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.' AFTER `maxbidpriceyellow`,
 ADD COLUMN `maxstackorange` int(11) default '1' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.' AFTER `maxstackpurple`,
 ADD COLUMN `maxstackyellow` int(11) default '1' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.' AFTER `maxstackorange`,
 ADD COLUMN `buyerpriceorange` int(11) default '20' COMMENT 'Multiplier to vendorprice when buying orange items from auctionhouse' AFTER `buyerpricepurple`,
 ADD COLUMN `buyerpriceyellow` int(11) default '22' COMMENT 'Multiplier to vendorprice when buying yellow items from auctionhouse' AFTER `buyerpriceorange`

Error occured at:2009-12-02 01:29:28
Line no.:40
Error Code: 1060 - Duplicate column name 'percentgreytradegoods'

Query:
/*Table structure for table `auctionhousebot` */
ALTER TABLE `auctionhousebot`
 ADD COLUMN `percentgreytradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Grey Trade Goods auction items' AFTER `maxtime`,
 ADD COLUMN `percentorangetradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Orange Trade Goods auction items' AFTER `percentpurpletradegoods`,
 ADD COLUMN `percentyellowtradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Yellow Trade Goods auction items' AFTER `percentorangetradegoods`,
 ADD COLUMN `percentgreyitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Grey auction items' AFTER `percentyellowtradegoods`,
 ADD COLUMN `percentorangeitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Orange auction items' AFTER `percentpurpleitems`,
 ADD COLUMN `percentyellowitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Yellow auction items' AFTER `percentorangeitems`,
 ADD COLUMN `minpricegrey` int(11) default '100' COMMENT 'Minimum price of Grey items (percentage).' AFTER `percentyellowitems`,
 ADD COLUMN `maxpricegrey` int(11) default '150' COMMENT 'Maximum price of Grey items (percentage).' AFTER `minpricegrey`,
 ADD COLUMN `minpriceorange` int(11) default '3250' COMMENT 'Minimum price of Orange items (percentage).' AFTER `maxpricepurple`,
 ADD COLUMN `maxpriceorange` int(11) default '5550' COMMENT 'Maximum price of Orange items (percentage).' AFTER `minpriceorange`,
 ADD COLUMN `minpriceyellow` int(11) default '5250' COMMENT 'Minimum price of Yellow items (percentage).' AFTER `maxpriceorange`,
 ADD COLUMN `maxpriceyellow` int(11) default '6550' COMMENT 'Maximum price of Yellow items (percentage).' AFTER `minpriceyellow`,
 ADD COLUMN `minbidpricegrey` int(11) default '70' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 70' AFTER `maxpriceyellow`,
 ADD COLUMN `maxbidpricegrey` int(11) default '100' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 100' AFTER `minbidpricegrey`,
 ADD COLUMN `minbidpriceorange` int(11) default '80' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 80' AFTER `maxbidpricepurple`,
 ADD COLUMN `maxbidpriceorange` int(11) default '100' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 100' AFTER `minbidpriceorange`,
 ADD COLUMN `minbidpriceyellow` int(11) default '80' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 80' AFTER `maxbidpriceorange`,
 ADD COLUMN `maxbidpriceyellow` int(11) default '100' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 100' AFTER `minbidpriceyellow`,
 ADD COLUMN `maxstackgrey` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.' AFTER `maxbidpriceyellow`,
 ADD COLUMN `maxstackorange` int(11) default '1' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.' AFTER `maxstackpurple`,
 ADD COLUMN `maxstackyellow` int(11) default '1' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.' AFTER `maxstackorange`,
 ADD COLUMN `buyerpriceorange` int(11) default '20' COMMENT 'Multiplier to vendorprice when buying orange items from auctionhouse' AFTER `buyerpricepurple`,
 ADD COLUMN `buyerpriceyellow` int(11) default '22' COMMENT 'Multiplier to vendorprice when buying yellow items from auctionhouse' AFTER `buyerpriceorange`

Error occured at:2009-12-02 01:30:00
Line no.:40
Error Code: 1060 - Duplicate column name 'percentgreytradegoods'

Query:
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2009-12-02 01:32:56
Line no.:1
Error Code: 1007 - Can't create database 'scriptdev2'; database exists

Query:
CREATE TABLE custom_texts (
   entry bigint NOT NULL,
   content_default text NOT NULL,
   content_loc1 text,
   content_loc2 text,
   content_loc3 text,
   content_loc4 text,
   content_loc5 text,
   content_loc6 text,
   content_loc7 text,
   content_loc8 text,
   sound integer DEFAULT 0 NOT NULL,
   type smallint DEFAULT (0)::smallint NOT NULL,
   language smallint DEFAULT (0)::smallint NOT NULL,
   emote smallint DEFAULT (0)::smallint NOT NULL,
   comment text,
   PRIMARY KEY(entry)
)

Error occured at:2009-12-02 01:33:46
Line no.:18
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 '(0)::smallint NOT NULL,
   language smallint DEFAULT (0)::smallint NOT NULL,
 ' at line 13

Query:
CREATE TABLE custom_texts (
   entry bigint NOT NULL,
   content_default text NOT NULL,
   content_loc1 text,
   content_loc2 text,
   content_loc3 text,
   content_loc4 text,
   content_loc5 text,
   content_loc6 text,
   content_loc7 text,
   content_loc8 text,
   sound integer DEFAULT 0 NOT NULL,
   type smallint DEFAULT (0)::smallint NOT NULL,
   language smallint DEFAULT (0)::smallint NOT NULL,
   emote smallint DEFAULT (0)::smallint NOT NULL,
   comment text,
   PRIMARY KEY(entry)
)

Error occured at:2009-12-02 01:34:06
Line no.:18
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 '(0)::smallint NOT NULL,
   language smallint DEFAULT (0)::smallint NOT NULL,
 ' at line 13

Query:
ALTER TABLE `jail_conf`
ADD COLUMN `ban_acc` tinyint(4) NOT NULL default '0' COMMENT 'Ban account if max_jails is reached?' AFTER `horde_m`

Error occured at:2009-12-02 01:37:53
Line no.:2
Error Code: 1054 - Unknown column 'horde_m' in 'jail_conf'

Query:
ALTER TABLE `jail_conf`
ADD COLUMN `radius` int(11) unsigned NOT NULL default '10' COMMENT 'Radius in yards (3D) within the jailed player can move' AFTER `ban_acc`

Error occured at:2009-12-02 01:38:07
Line no.:2
Error Code: 1054 - Unknown column 'ban_acc' in 'jail_conf'

Query:
REPLACE INTO `mangos_string` VALUES ('980', 'Be carefull!\nOnly one more jailtime and your account will be banned!', null, null, '!!! ACHTUNG - WICHTIG - WARNUNG !!!\nBeim nächsten Knastbesuch wird dein Account gebannt!', null, null, null, null)

Error occured at:2009-12-02 01:38:25
Line no.:3
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
UPDATE `creature_template` SET`ScriptName` = '' WHERE `entry` = 3209

Error occured at:2009-12-02 01:42:26
Line no.:1
Error Code: 1146 - Table 'characters.creature_template' doesn't exist

Query:
UPDATE creature_template SET faction=35 WHERE entry=13020

Error occured at:2009-12-02 01:42:49
Line no.:1
Error Code: 1054 - Unknown column 'faction' in 'field list'

Query:
UPDATE creature_template SET faction=35 WHERE entry=13020

Error occured at:2009-12-02 01:43:01
Line no.:1
Error Code: 1146 - Table 'characters.creature_template' doesn't exist

Query:
UPDATE creature_template SET faction=35 WHERE entry=13020

Error occured at:2009-12-02 01:43:16
Line no.:1
Error Code: 1146 - Table 'scriptdev2.creature_template' doesn't exist

Query:
UPDATE creature_template SET faction=35 WHERE entry=13020

Error occured at:2009-12-02 01:43:25
Line no.:1
Error Code: 1146 - Table 'realmd.creature_template' doesn't exist

Query:
UPDATE creature_template SET faction=35 WHERE entry=13020

Error occured at:2009-12-02 01:43:32
Line no.:1
Error Code: 1146 - Table 'mysql.creature_template' doesn't exist

Query:
REPLACE INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `ScriptName`) VALUES (19577, 16946, 16946, 'Arcane Orb Target', '', 70, 70, 1, 1, 0, 0, 0, 35, 35, 0, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 'mob_arcane_orb_target')

Error occured at:2009-12-02 01:48:52
Line no.:5
Error Code: 1054 - Unknown column 'flags' in 'field list'

Query:
UPDATE `creature_template` SET `ScriptName` = 'boss_void_reaver' WHERE `entry` = 19516

Error occured at:2009-12-02 01:49:30
Line no.:2
Error Code: 1146 - Table 'characters.creature_template' doesn't exist

Query:
UPDATE `creature_template` SET `ScriptName` = 'boss_void_reaver' WHERE `entry` = 19516

Error occured at:2009-12-02 01:49:38
Line no.:2
Error Code: 1146 - Table 'mysql.creature_template' doesn't exist

Query:
UPDATE `creature_template` SET `ScriptName` = 'boss_void_reaver' WHERE `entry` = 19516

Error occured at:2009-12-02 01:49:59
Line no.:2
Error Code: 1146 - Table 'realmd.creature_template' doesn't exist

Query:
UPDATE `creature_template` SET `ScriptName` = 'boss_void_reaver' WHERE `entry` = 19516

Error occured at:2009-12-02 01:50:06
Line no.:2
Error Code: 1146 - Table 'scriptdev2.creature_template' doesn't exist

Query:
INSERT IGNORE `spell_teleport` VALUES (6766, 1,-2354.03,-1902.07,95.78,4.6)

Error occured at:2009-12-02 01:56:10
Line no.:12
Error Code: 1146 - Table 'mangos.spell_teleport' doesn't exist

Query:
UPDATE `creature_template` SET `ScriptName` = 'npc_parqual_fintallas' WHERE `entry` = 4488

Error occured at:2009-12-02 01:56:20
Line no.:2
Error Code: 1146 - Table 'characters.creature_template' doesn't exist

Query:
UPDATE `creature_template` SET `ScriptName` = 'npc_parqual_fintallas' WHERE `entry` = 4488

Error occured at:2009-12-02 01:56:27
Line no.:2
Error Code: 1146 - Table 'mysql.creature_template' doesn't exist

Query:
UPDATE `creature_template` SET `ScriptName` = 'npc_parqual_fintallas' WHERE `entry` = 4488

Error occured at:2009-12-02 01:56:34
Line no.:2
Error Code: 1146 - Table 'realmd.creature_template' doesn't exist

Query:
UPDATE `creature_template` SET `ScriptName` = 'npc_parqual_fintallas' WHERE `entry` = 4488

Error occured at:2009-12-02 01:56:40
Line no.:2
Error Code: 1146 - Table 'scriptdev2.creature_template' doesn't exist

Query:
ALTER TABLE `eventai_Scripts` RENAME TO `eventai_scripts`

Error occured at:2009-12-02 01:59:53
Line no.:1
Error Code: 1146 - Table 'scriptdev2.eventai_scripts' doesn't exist

Query:
ALTER TABLE `eventai_scripts`
 DROP PRIMARY KEY,
 DROP `id`,
 ADD `id` int(11) unsigned NOT NULL COMMENT 'Identifier' PRIMARY KEY AUTO_INCREMENT FIRST,
 MODIFY `event_param1` int(11) signed NOT NULL default '0',
 MODIFY `event_param2` int(11) signed NOT NULL default '0',
 MODIFY `event_param3` int(11) signed NOT NULL default '0',
 MODIFY `action1_param1` int(11) signed NOT NULL default '0',
 MODIFY `action1_param2` int(11) signed NOT NULL default '0',
 MODIFY `action1_param3` int(11) signed NOT NULL default '0',
 MODIFY `action2_param1` int(11) signed NOT NULL default '0',
 MODIFY `action2_param2` int(11) signed NOT NULL default '0',
 MODIFY `action2_param3` int(11) signed NOT NULL default '0',
 MODIFY `action3_param1` int(11) signed NOT NULL default '0',
 MODIFY `action3_param2` int(11) signed NOT NULL default '0',
 MODIFY `action3_param3` int(11) signed NOT NULL default '0',
 ADD `comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment'

Error occured at:2009-12-02 02:00:11
Line no.:22
Error Code: 1146 - Table 'scriptdev2.eventai_scripts' doesn't exist

Query:
ALTER TABLE `eventai_Scripts` RENAME TO `eventai_scripts`

Error occured at:2009-12-02 02:00:33
Line no.:1
Error Code: 1146 - Table 'mangos.eventai_scripts' doesn't exist

Query:
ALTER TABLE `eventai_scripts`
ADD `event_inverse_phase_mask` int(11) signed NOT NULL default '0', COMMENT 'Mask which phases this event will not trigger in'

Error occured at:2009-12-02 02:01:45
Line no.:2
Error Code: 1146 - Table 'mangos.eventai_scripts' doesn't exist

Query:
ALTER TABLE `eventai_scripts`
ADD `event_inverse_phase_mask` int(11) signed NOT NULL default '0', COMMENT 'Mask which phases this event will not trigger in'

Error occured at:2009-12-02 02:02:08
Line no.:2
Error Code: 1146 - Table 'scriptdev2.eventai_scripts' doesn't exist

Query:
ALTER TABLE eventai_scripts
ADD event_chance tinyint(3) unsigned NOT NULL default 100 AFTER event_inverse_phase_mask

Error occured at:2009-12-02 02:08:20
Line no.:2
Error Code: 1146 - Table 'mangos.eventai_scripts' doesn't exist

Query:
ALTER TABLE eventai_scripts
ADD event_chance tinyint(3) unsigned NOT NULL default 100 AFTER event_inverse_phase_mask

Error occured at:2009-12-02 02:08:27
Line no.:2
Error Code: 1146 - Table 'scriptdev2.eventai_scripts' doesn't exist

Query:
UPDATE eventai_scripts SET event_param3 = event_param2, event_param2 = -1 WHERE event_type = 10

Error occured at:2009-12-02 02:10:38
Line no.:2
Error Code: 1146 - Table 'mangos.eventai_scripts' doesn't exist

Query:
UPDATE eventai_scripts SET event_param3 = event_param2, event_param2 = -1 WHERE event_type = 10

Error occured at:2009-12-02 02:10:47
Line no.:2
Error Code: 1146 - Table 'scriptdev2.eventai_scripts' doesn't exist

Query:
CREATE TABLE `eventai_summons` (
`id` int(11) unsigned NOT NULL COMMENT 'Location Identifier' AUTO_INCREMENT,
`position_x` float NOT NULL default '0',
`position_y` float NOT NULL default '0',
`position_z` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`spawntimesecs` int(11) unsigned NOT NULL default '120',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations'

Error occured at:2009-12-02 02:11:01
Line no.:9
Error Code: 1050 - Table 'eventai_summons' already exists

Query:
CREATE TABLE `eventai_summons` (
`id` int(11) unsigned NOT NULL COMMENT 'Location Identifier' AUTO_INCREMENT,
`position_x` float NOT NULL default '0',
`position_y` float NOT NULL default '0',
`position_z` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`spawntimesecs` int(11) unsigned NOT NULL default '120',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations'

Error occured at:2009-12-02 02:11:06
Line no.:9
Error Code: 1050 - Table 'eventai_summons' already exists

Query:
ALTER TABLE db_version CHANGE COLUMN required_2008_12_22_03_mangos_item_template required_2008_12_22_04_mangos_item_template bit

Error occured at:2009-12-02 17:19:45
Line no.:1
Error Code: 1054 - Unknown column 'required_2008_12_22_03_mangos_item_template' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_2008_12_22_01_mangos_creature_equip_template required_2008_12_22_03_mangos_item_template bit

Error occured at:2009-12-02 17:19:52
Line no.:1
Error Code: 1054 - Unknown column 'required_2008_12_22_01_mangos_creature_equip_template' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_2008_12_22_04_mangos_item_template required_2008_12_22_07_mangos_quest_template bit

Error occured at:2009-12-02 17:20:01
Line no.:1
Error Code: 1054 - Unknown column 'required_2008_12_22_04_mangos_item_template' in 'db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_2008_12_22_18_characters_characters required_2008_12_22_19_characters_item_instance bit

Error occured at:2009-12-02 17:20:09
Line no.:1
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE db_version CHANGE COLUMN required_7002_01_mangos_spell_chain required_7015_01_mangos_item_template bit

Error occured at:2009-12-02 17:20:20
Line no.:1
Error Code: 1054 - Unknown column 'required_7002_01_mangos_spell_chain' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_7988_04_mangos_creature_template required_7988_05_mangos_item_template bit

Error occured at:2009-12-02 17:21:00
Line no.:1
Error Code: 1054 - Unknown column 'required_7988_04_mangos_creature_template' in 'db_version'

Query:
CREATE TABLE item_test
SELECT w.`item_guid`,w.`source`,w.`count` FROM
 (SELECT u.`item_guid`,u.`source`,COUNT(u.`item_guid`) as `count` FROM
   ((SELECT c.`item`      as `item_guid`, 'i' as `source` FROM character_inventory c) UNION
    (SELECT a.`itemguid`  as `item_guid`, 'a' as `source` FROM auctionhouse        a) UNION
    (SELECT m.`item_guid` as `item_guid`, 'm' as `source` FROM mail_items          m) UNION
    (SELECT g.`item_guid` as `item_guid`, 'g' as `source` FROM guild_bank_item     g)
   ) as u
  GROUP BY u.`item_guid`
 ) as w
WHERE w.`count` > 1

Error occured at:2009-12-04 16:07:37
Line no.:12
Error Code: 1146 - Table 'mangos.character_inventory' doesn't exist

Query:
ALTER TABLE db_version CHANGE COLUMN required_7980_01_mangos_item_required_target required_7988_01_mangos_item_template bit

Error occured at:2009-12-04 16:37:59
Line no.:1
Error Code: 1054 - Unknown column 'required_7980_01_mangos_item_required_target' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_7980_01_mangos_item_required_target required_7988_01_mangos_item_template bit

Error occured at:2009-12-04 16:38:36
Line no.:1
Error Code: 1054 - Unknown column 'required_7980_01_mangos_item_required_target' in 'db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_7932_01_characters_character_pet required_7988_02_characters_character_equipmentsets bit

Error occured at:2009-12-04 16:38:46
Line no.:1
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_7932_01_characters_character_pet required_7988_02_characters_character_equipmentsets bit

Error occured at:2009-12-04 16:38:58
Line no.:1
Error Code: 1054 - Unknown column 'required_7932_01_characters_character_pet' in 'character_db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_7932_01_characters_character_pet required_7988_02_characters_character_equipmentsets bit

Error occured at:2009-12-04 16:39:06
Line no.:1
Error Code: 1054 - Unknown column 'required_7932_01_characters_character_pet' in 'character_db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_7932_01_characters_character_pet required_7988_02_characters_character_equipmentsets bit

Error occured at:2009-12-04 16:41:04
Line no.:1
Error Code: 1054 - Unknown column 'required_7932_01_characters_character_pet' in 'character_db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_7932_01_characters_character_pet required_7988_02_characters_character_equipmentsets bit

Error occured at:2009-12-04 16:41:23
Line no.:1
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_7932_01_characters_character_pet required_7988_02_characters_character_equipmentsets bit

Error occured at:2009-12-04 16:41:51
Line no.:1
Error Code: 1054 - Unknown column 'required_7932_01_characters_character_pet' in 'character_db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_7932_01_characters_character_pet required_7988_02_characters_character_equipmentsets bit

Error occured at:2009-12-04 16:42:05
Line no.:1
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE db_version CHANGE COLUMN required_7988_01_mangos_item_template required_7988_03_mangos_spell_chain bit

Error occured at:2009-12-04 16:42:25
Line no.:1
Error Code: 1054 - Unknown column 'required_7988_01_mangos_item_template' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_7988_03_mangos_spell_chain required_7988_04_mangos_creature_template bit

Error occured at:2009-12-04 16:42:56
Line no.:1
Error Code: 1054 - Unknown column 'required_7988_03_mangos_spell_chain' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_7988_03_mangos_spell_chain required_7988_04_mangos_creature_template bit

Error occured at:2009-12-04 16:43:10
Line no.:1
Error Code: 1054 - Unknown column 'required_7988_03_mangos_spell_chain' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_7988_04_mangos_creature_template required_7988_05_mangos_item_template bit

Error occured at:2009-12-04 16:43:22
Line no.:1
Error Code: 1054 - Unknown column 'required_7988_04_mangos_creature_template' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_7988_05_mangos_item_template required_7988_06_mangos_gameobject_template bit

Error occured at:2009-12-04 16:43:44
Line no.:1
Error Code: 1054 - Unknown column 'required_7988_05_mangos_item_template' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_7988_08_mangos_spell_bonus_data required_7988_09_mangos_spell_proc_event bit

Error occured at:2009-12-04 16:44:03
Line no.:1
Error Code: 1054 - Unknown column 'required_7988_08_mangos_spell_bonus_data' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_7988_09_mangos_spell_proc_event required_8016_01_mangos_npc_spellclick_spells bit

Error occured at:2009-12-04 16:44:13
Line no.:1
Error Code: 1054 - Unknown column 'required_7988_09_mangos_spell_proc_event' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_8016_01_mangos_npc_spellclick_spells required_8021_01_mangos_spell_proc_event bit

Error occured at:2009-12-04 16:44:24
Line no.:1
Error Code: 1054 - Unknown column 'required_8016_01_mangos_npc_spellclick_spells' in 'db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_7988_07_characters_characters required_8030_01_characters_character_spell bit

Error occured at:2009-12-04 16:44:37
Line no.:1
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_8030_01_characters_character_spell required_8030_02_characters_character_action bit

Error occured at:2009-12-04 16:45:33
Line no.:1
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE db_version CHANGE COLUMN required_8021_01_mangos_spell_proc_event required_8030_03_mangos_npc_trainer bit

Error occured at:2009-12-04 16:45:45
Line no.:1
Error Code: 1054 - Unknown column 'required_8021_01_mangos_spell_proc_event' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_8050_01_mangos_spell_proc_event required_8050_02_mangos_spell_bonus_data bit

Error occured at:2009-12-04 16:46:08
Line no.:1
Error Code: 1054 - Unknown column 'required_8050_01_mangos_spell_proc_event' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_8050_01_mangos_spell_proc_event required_8050_02_mangos_spell_bonus_data bit

Error occured at:2009-12-04 16:46:11
Line no.:1
Error Code: 1054 - Unknown column 'required_8050_01_mangos_spell_proc_event' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_8050_02_mangos_spell_bonus_data required_8053_01_mangos_command bit

Error occured at:2009-12-04 16:46:24
Line no.:1
Error Code: 1054 - Unknown column 'required_8050_02_mangos_spell_bonus_data' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_8053_01_mangos_command required_8060_01_mangos_spell_pet_auras bit

Error occured at:2009-12-04 16:46:32
Line no.:1
Error Code: 1054 - Unknown column 'required_8053_01_mangos_command' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_8060_01_mangos_spell_pet_auras required_8064_01_mangos_spell_chain bit

Error occured at:2009-12-04 16:46:40
Line no.:1
Error Code: 1054 - Unknown column 'required_8060_01_mangos_spell_pet_auras' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_8064_01_mangos_spell_chain required_8065_01_mangos_spell_proc_event bit

Error occured at:2009-12-04 16:46:50
Line no.:1
Error Code: 1054 - Unknown column 'required_8064_01_mangos_spell_chain' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_8065_01_mangos_spell_proc_event required_8071_01_mangos_command bit

Error occured at:2009-12-04 16:46:57
Line no.:1
Error Code: 1054 - Unknown column 'required_8065_01_mangos_spell_proc_event' in 'db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_8030_02_characters_character_action required_8072_01_characters_characters bit

Error occured at:2009-12-04 16:47:06
Line no.:1
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_8072_01_characters_characters required_8072_02_characters_characters bit

Error occured at:2009-12-04 16:47:13
Line no.:1
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_8072_02_characters_characters required_8098_01_characters_character_action bit

Error occured at:2009-12-04 16:47:29
Line no.:1
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE db_version CHANGE COLUMN required_8071_01_mangos_command required_8098_02_mangos_playercreateinfo_action bit

Error occured at:2009-12-04 16:47:38
Line no.:1
Error Code: 1054 - Unknown column 'required_8071_01_mangos_command' in 'db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_8098_01_characters_character_action required_8098_03_characters_character_pet bit

Error occured at:2009-12-04 16:47:45
Line no.:1
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_8098_03_characters_character_pet required_8098_04_characters_pet_spell bit

Error occured at:2009-12-04 16:47:52
Line no.:1
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_8098_03_characters_character_pet required_8098_04_characters_pet_spell bit

Error occured at:2009-12-04 16:48:17
Line no.:1
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_7988_02_characters_character_equipmentsets required_7988_07_characters_characters bit

Error occured at:2009-12-04 16:52:56
Line no.:1
Error Code: 1054 - Unknown column 'required_7988_02_characters_character_equipmentsets' in 'character_db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_7988_07_characters_characters required_8030_01_characters_character_spell bit

Error occured at:2009-12-04 16:53:04
Line no.:1
Error Code: 1054 - Unknown column 'required_7988_07_characters_characters' in 'character_db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_8030_01_characters_character_spell required_8030_02_characters_character_action bit

Error occured at:2009-12-04 16:53:12
Line no.:1
Error Code: 1054 - Unknown column 'required_8030_01_characters_character_spell' in 'character_db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_8030_02_characters_character_action required_8072_01_characters_characters bit

Error occured at:2009-12-04 16:53:50
Line no.:1
Error Code: 1054 - Unknown column 'required_8030_02_characters_character_action' in 'character_db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_8072_01_characters_characters required_8072_02_characters_characters bit

Error occured at:2009-12-04 16:54:06
Line no.:1
Error Code: 1054 - Unknown column 'required_8072_01_characters_characters' in 'character_db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_8098_01_characters_character_action required_8098_03_characters_character_pet bit

Error occured at:2009-12-04 16:55:58
Line no.:1
Error Code: 1054 - Unknown column 'required_8098_01_characters_character_action' in 'character_db_version'

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

Error occured at:2009-12-04 16:59:24
Line no.:1
Error Code: 1146 - Table 'mangos.character_inventory' doesn't exist

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

Error occured at:2009-12-04 16:59:39
Line no.:1
Error Code: 1060 - Duplicate column name 'bag'

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

Error occured at:2009-12-04 17:00:21
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:2009-12-04 17:00:29
Line no.:1
Error Code: 1054 - Unknown column 'RequiredRaputationRank' in 'item_template'

Query:
ALTER TABLE `areatrigger_tavern`
   CHANGE `triggerid` `id` int(11) unsigned NOT NULL default '0' ,
   CHANGE `Triggername` `name` text ,
   DROP KEY `acct`,
   DROP PRIMARY KEY ,
   ADD PRIMARY KEY (`id`) 

Error occured at:2009-12-04 17:00:40
Line no.:6
Error Code: 1054 - Unknown column 'triggerid' in 'areatrigger_tavern'

Query:
ALTER TABLE `game_graveyard` RENAME TO `areatrigger_graveyard`

Error occured at:2009-12-04 17:00:48
Line no.:1
Error Code: 1146 - Table 'mangos.game_graveyard' doesn't exist

Query:
INSERT INTO `playercreateinfo` VALUES (1,1,1,0,12,-8949,-132,84,49,23,20,22,20,21,40,60,0,1000,0,0,29,5,6,0,0),(2,1,2,0,12,-8949,-132,84,49,22,20,22,20,22,40,68,79,0,0,0,27,4,5,0,0),(3,1,4,0,12,-8949,-132,84,49,21,23,21,20,20,40,55,0,0,0,100,27,10,13,0,0),(4,1,5,0,12,-8949,-132,84,49,20,20,20,22,24,40,61,128,0,0,0,30,4,4,0,0),(5,1,8,0,12,-8949,-132,84,49,20,20,20,23,22,40,61,119,0,0,0,30,4,4,0,0),(6,1,9,0,12,-8949,-132,84,49,20,20,21,22,22,40,53,109,0,0,0,30,4,4,0,0),(7,2,1,1,14,-618,-4251,39,51,26,17,24,17,23,0,80,0,1000,0,0,35,6,6,0,0),(8,2,3,1,14,-618,-4251,39,51,23,20,23,17,24,0,76,80,0,0,0,25,4,5,0,0),(9,2,4,1,14,-618,-4251,39,51,24,20,23,17,23,0,75,0,0,0,100,30,4,4,0,0),(10,2,7,1,14,-618,-4251,39,51,24,17,23,18,25,0,97,71,0,0,0,30,4,4,0,0),(11,2,9,1,14,-618,-4251,39,51,23,17,23,19,25,0,73,109,0,0,0,30,4,4,0,0),(12,3,1,0,1,-6240,331,383,53,25,16,25,19,19,0,90,0,1000,0,0,33,5,6,0,0),(13,3,2,0,1,-6240,331,383,53,24,16,25,19,20,0,88,79,0,0,0,31,5,6,0,0),(14,3,3,0,1,-6240,331,383,53,22,19,24,19,20,0,86,80,0,0,0,24,4,5,0,0),(15,3,4,0,1,-6240,331,383,53,23,19,24,19,19,0,85,0,0,0,100,30,4,4,0,0),(16,3,5,0,1,-6240,331,383,53,22,16,23,21,22,0,91,128,0,0,0,30,4,4,0,0),(17,4,1,1,141,10311,832,1327,55,20,25,21,20,20,0,50,0,1000,0,0,21,4,4,0,0),(18,4,3,1,141,10311,832,1327,55,17,28,20,20,21,0,46,80,0,0,0,26,4,5,0,0),(19,4,4,1,141,10311,832,1327,55,18,28,20,20,20,0,45,0,0,0,100,30,4,4,0,0),(20,4,5,1,141,10311,832,1327,55,17,25,19,22,23,0,51,128,0,0,0,30,4,4,0,0),(21,4,11,1,141,10311,832,1327,55,18,25,19,22,22,0,53,67,0,0,0,30,4,4,0,0),(22,5,1,0,85,1676,1677,122,57,22,18,23,18,25,0,70,0,1000,0,0,27,4,5,0,0),(23,5,4,0,85,1676,1677,122,57,20,21,22,18,25,0,65,0,0,0,100,30,4,4,0,0),(24,5,5,0,85,1676,1677,122,57,19,18,21,20,28,0,71,128,0,0,0,30,4,4,0,0),(25,5,8,0,85,1676,1677,122,57,19,18,21,21,27,0,71,119,0,0,0,30,4,4,0,0),(26,5,9,0,85,1676,1677,122,57,19,18,22,20,27,0,63,109,0,0,0,30,4,4,0,0),(27,6,1,1,215,-2917,-257,53,59,28,15,24,15,22,0,80,0,1000,0,0,39,6,7,0,0),(28,6,3,1,215,-2917,-257,53,59,25,18,23,15,23,0,76,80,0,0,0,16,5,7,0,0),(29,6,7,1,215,-2917,-257,53,59,26,15,23,16,24,0,97,71,0,0,0,30,4,4,0,0),(30,6,11,1,215,-2917,-257,53,59,26,15,22,17,24,0,97,67,0,0,0,30,4,4,0,0),(31,7,1,0,1,-6240,331,383,1563,18,23,21,23,20,0,50,0,1000,0,0,10,3,4,0,0),(32,7,4,0,1,-6340,331,383,1563,16,26,20,23,20,0,45,0,0,0,100,30,4,4,0,0),(33,7,8,0,1,-6340,331,383,1563,15,23,19,26,22,0,51,119,0,0,0,30,4,4,0,0),(34,7,9,0,1,-6340,331,383,1563,15,23,20,25,22,0,43,109,0,0,0,30,4,4,0,0),(35,8,1,1,14,-618,-4251,39,1478,24,22,23,16,21,0,70,0,1000,0,0,29,5,7,0,0),(36,8,3,1,14,-618,-4251,39,1478,21,25,22,16,22,0,66,80,0,0,0,16,5,7,0,0),(37,8,4,1,14,-618,-4251,39,1478,22,25,22,16,21,0,65,0,0,0,100,30,4,4,0,0),(38,8,5,1,14,-618,-4251,39,1478,21,22,21,18,24,0,71,128,0,0,0,30,4,4,0,0),(39,8,7,1,14,-618,-4251,39,1478,22,22,22,17,23,0,87,71,0,0,0,30,4,4,0,0),(40,8,8,1,14,-618,-4251,39,1478,21,22,21,19,23,0,71,119,0,0,0,30,4,4,0,0)

Error occured at:2009-12-04 17:00:59
Line no.:4
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `playercreateinfo_item` VALUES (1,38,255,3,1),(1,39,255,6,1),(1,40,255,7,1),(1,25,255,15,1),(1,2362,255,16,1),(1,65020,255,23,4),(1,6948,255,24,1),(1,14646,255,25,1),(2,45,255,3,1),(2,44,255,6,1),(2,43,255,7,1),(2,2361,255,15,1),(2,6948,255,23,1),(2,65021,255,24,2),(2,65022,255,25,4),(2,14646,255,26,1),(3,49,255,3,1),(3,48,255,6,1),(3,47,255,7,1),(3,2092,255,15,1),(3,65023,255,17,100),(3,65022,255,23,4),(3,6948,255,24,1),(3,14646,255,25,1),(4,53,255,3,1),(4,6098,255,4,1),(4,52,255,6,1),(4,51,255,7,1),(4,36,255,15,1),(4,65021,255,23,2),(4,65022,255,24,4),(4,6948,255,25,1),(4,14646,255,26,1),(5,6096,255,3,1),(5,56,255,4,1),(5,1395,255,6,1),(5,55,255,7,1),(5,35,255,15,1),(5,65022,255,23,4),(5,65021,255,24,2),(5,6948,255,25,1),(5,14646,255,26,1),(6,6097,255,3,1),(6,57,255,4,1),(6,1396,255,6,1),(6,59,255,7,1),(6,2092,255,15,1),(6,65027,255,23,4),(6,65021,255,24,2),(6,6948,255,25,1),(6,14646,255,26,1),(7,6125,255,3,1),(7,139,255,6,1),(7,140,255,7,1),(7,12282,255,15,1),(7,6948,255,23,1),(7,65020,255,24,4),(7,14649,255,25,1),(8,127,255,3,1),(8,6126,255,6,1),(8,6127,255,7,1),(8,37,255,15,1),(8,2504,255,17,1),(8,65021,255,23,2),(8,65020,255,24,4),(8,6948,255,25,1),(8,14649,255,26,1),(8,2512,255,27,200),(8,2101,255,28,1),(9,2105,255,3,1),(9,120,255,6,1),(9,121,255,7,1),(9,2092,255,15,1),(9,65024,255,17,100),(9,65020,255,23,4),(9,6948,255,24,1),(9,14649,255,25,1),(10,154,255,3,1),(10,153,255,6,1),(10,36,255,15,1),(10,6948,255,23,1),(10,65020,255,24,4),(10,65021,255,25,2),(10,14649,255,26,1),(11,6129,255,4,1),(11,1396,255,6,1),(11,59,255,7,1),(11,2092,255,15,1),(11,6948,255,23,1),(11,65020,255,24,4),(11,65021,255,25,2),(11,14649,255,26,1),(12,38,255,3,1),(12,39,255,6,1),(12,40,255,7,1),(12,12282,255,15,1),(12,6948,255,23,1),(12,65020,255,24,4),(12,14647,255,25,1),(13,45,255,3,1),(13,44,255,6,1),(13,43,255,7,1),(13,2361,255,15,1),(13,65026,255,23,4),(13,65021,255,24,2),(13,6948,255,25,1),(13,14647,255,26,1),(14,148,255,3,1),(14,147,255,6,1),(14,129,255,7,1),(14,37,255,15,1),(14,2508,255,17,1),(14,65021,255,23,2),(14,65020,255,24,4),(14,6948,255,25,1),(14,14647,255,26,1),(14,2516,255,27,200),(14,2102,255,28,1),(15,49,255,3,1),(15,48,255,6,1),(15,47,255,7,1),(15,2092,255,15,1),(15,65024,255,17,100),(15,65026,255,23,4),(15,6948,255,24,1),(15,14647,255,25,1),(16,53,255,3,1),(16,6098,255,4,1),(16,52,255,6,1),(16,51,255,7,1),(16,36,255,15,1),(16,65021,255,23,2),(16,65026,255,24,4),(16,6948,255,25,1),(16,14647,255,26,1),(17,38,255,3,1),(17,39,255,6,1),(17,40,255,7,1),(17,25,255,15,1),(17,2362,255,16,1),(17,65020,255,23,4),(17,6948,255,24,1),(17,14648,255,25,1),(18,148,255,3,1),(18,147,255,6,1),(18,129,255,7,1),(18,2092,255,15,1),(18,2504,255,17,1),(18,65021,255,23,2),(18,65020,255,24,4),(18,6948,255,25,1),(18,14648,255,26,1),(18,2512,255,27,200),(18,2101,255,28,1),(19,49,255,3,1),(19,48,255,6,1),(19,47,255,7,1),(19,2092,255,15,1),(19,65023,255,17,100),(19,65026,255,23,4),(19,6948,255,24,1),(19,14648,255,25,1),(20,53,255,3,1),(20,6119,255,4,1),(20,52,255,6,1),(20,51,255,7,1),(20,36,255,15,1),(20,65022,255,23,4),(20,65021,255,24,2),(20,6948,255,25,1),(20,14648,255,26,1),(21,6123,255,4,1),(21,44,255,6,1),(21,3661,255,15,1),(21,65021,255,23,2),(21,65025,255,24,4),(21,6948,255,25,1),(21,14648,255,26,1),(22,6125,255,3,1),(22,139,255,6,1),(22,140,255,7,1),(22,25,255,15,1),(22,2362,255,16,1),(22,65027,255,23,4),(22,6948,255,24,1),(22,14651,255,25,1),(23,2105,255,3,1),(23,120,255,6,1),(23,121,255,7,1),(23,2092,255,15,1),(23,65023,255,17,100),(23,65027,255,23,4),(23,6948,255,24,1),(23,14651,255,25,1),(24,53,255,3,1),(24,6144,255,4,1),(24,52,255,6,1),(24,51,255,7,1),(24,36,255,15,1),(24,65027,255,23,4),(24,65021,255,24,2),(24,6948,255,25,1),(24,14651,255,26,1),(25,6096,255,3,1),(25,6140,255,4,1),(25,1395,255,6,1),(25,55,255,7,1),(25,35,255,15,1),(25,65027,255,23,4),(25,65021,255,24,2),(25,6948,255,25,1),(25,14651,255,26,1),(26,6129,255,4,1),(26,1396,255,6,1),(26,59,255,7,1),(26,2092,255,15,1),(26,65027,255,23,4),(26,65021,255,24,2),(26,6948,255,25,1),(26,14651,255,26,1),(27,6125,255,3,1),(27,139,255,6,1),(27,2361,255,15,1),(27,6948,255,23,1),(27,65026,255,24,4),(27,14650,255,25,1),(28,127,255,3,1),(28,6126,255,6,1),(28,37,255,15,1),(28,2508,255,17,1),(28,65021,255,23,2),(28,65020,255,24,4),(28,6948,255,25,1),(28,14650,255,26,1),(28,2516,255,27,200),(28,2102,255,28,1),(29,154,255,3,1),(29,153,255,6,1),(29,36,255,15,1),(29,6948,255,23,1),(29,65027,255,24,4),(29,65021,255,25,2),(29,14650,255,26,1),(30,6139,255,4,1),(30,6124,255,6,1),(30,35,255,15,1),(30,65021,255,23,2),(30,65025,255,24,4),(30,6948,255,25,1),(30,14650,255,26,1),(31,38,255,4,1),(31,39,255,6,1),(31,40,255,7,1),(31,25,255,15,1),(31,2362,255,16,1),(31,65020,255,23,4),(31,6948,255,24,1),(31,14647,255,25,1),(32,49,255,3,1),(32,48,255,6,1),(32,47,255,7,1),(32,2092,255,15,1),(32,65023,255,17,100),(32,65020,255,23,4),(32,6948,255,24,1),(32,14647,255,25,1),(33,6096,255,3,1),(33,56,255,4,1),(33,1395,255,6,1),(33,55,255,7,1),(33,35,255,15,1),(33,65025,255,23,4),(33,65021,255,24,2),(33,6948,255,25,1),(33,14647,255,26,1),(34,6097,255,3,1),(34,57,255,4,1),(34,1396,255,6,1),(34,59,255,7,1),(34,2092,255,15,1),(34,65021,255,23,2),(34,65027,255,24,4),(34,6948,255,25,1),(34,14647,255,26,1),(35,6125,255,3,1),(35,139,255,6,1),(35,140,255,7,1),(35,37,255,15,1),(35,2362,255,16,1),(35,65024,255,17,100),(35,65020,255,23,4),(35,6948,255,24,1),(35,14649,255,25,1),(36,127,255,3,1),(36,6126,255,6,1),(36,6127,255,7,1),(36,37,255,15,1),(36,2504,255,17,1),(36,65027,255,23,4),(36,65021,255,24,2),(36,2512,255,27,200),(36,2101,255,28,1),(36,14649,255,26,1),(36,6948,255,25,1),(37,2105,255,3,1),(37,120,255,6,1),(37,121,255,7,1),(37,2092,255,15,1),(37,65024,255,17,100),(37,65020,255,23,4),(37,6948,255,24,1),(37,14649,255,25,1),(38,53,255,3,1),(38,6144,255,4,1),(38,52,255,6,1),(38,36,255,15,1),(38,65026,255,23,4),(38,65021,255,24,2),(38,6948,255,25,1),(38,14649,255,26,1),(39,6134,255,3,1),(39,6135,255,6,1),(39,36,255,15,1),(39,65020,255,23,4),(39,65021,255,24,2),(39,6948,255,25,1),(39,14649,255,26,1),(40,6096,255,3,1),(40,6140,255,4,1),(40,1395,255,6,1),(40,55,255,7,1),(40,35,255,15,1),(40,65020,255,23,4),(40,65021,255,24,2),(40,6948,255,25,1),(40,14649,255,26,1)

Error occured at:2009-12-04 17:01:09
Line no.:4
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
ALTER TABLE `loot_template`
   CHANGE `itemid`        `item`   int(11) unsigned NOT NULL default '0' ,
   CHANGE `percentchance` `chance` float            NOT NULL default '100' ,
   DROP KEY `i_creature_loot_creatureid` ,
   DROP KEY `creatureloot_index` ,
   ADD PRIMARY KEY (`entry`,`item`) 

Error occured at:2009-12-04 17:01:16
Line no.:6
Error Code: 1146 - Table 'mangos.loot_template' doesn't exist

Query:
ALTER TABLE `character_queststatus`
   CHANGE `playerid`        `guid`       bigint(20) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
   CHANGE `questid`         `quest`      int(11)    unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
   CHANGE `status`          `status`     int(11)    unsigned NOT NULL default '0',
   CHANGE `rewarded`        `rewarded`   int(11)    unsigned NOT NULL default '0',
   CHANGE `explored`        `explored`   int(11)    unsigned NOT NULL default '0' AFTER `rewarded` ,
   CHANGE `timer`           `timer`      bigint(20) unsigned NOT NULL default '0' AFTER `explored` ,
   CHANGE `questMobCount1`  `mobcount1`  int(11)    unsigned NOT NULL default '0',
   CHANGE `questMobCount2`  `mobcount2`  int(11)    unsigned NOT NULL default '0',
   CHANGE `questMobCount3`  `mobcount3`  int(11)    unsigned NOT NULL default '0',
   CHANGE `questMobCount4`  `mobcount4`  int(11)    unsigned NOT NULL default '0',
   CHANGE `questItemCount1` `itemcount1` int(11)    unsigned NOT NULL default '0',
   CHANGE `questItemCount2` `itemcount2` int(11)    unsigned NOT NULL default '0',
   CHANGE `questItemCount3` `itemcount3` int(11)    unsigned NOT NULL default '0',
   CHANGE `questItemCount4` `itemcount4` int(11)    unsigned NOT NULL default '0',
   DROP `id` ,
   DROP PRIMARY KEY ,
   ADD  PRIMARY KEY  (`guid`,`quest`) 

Error occured at:2009-12-04 17:01:23
Line no.:18
Error Code: 1146 - Table 'mangos.character_queststatus' doesn't exist

Query:
ALTER TABLE `item_template` ADD `RangedModRange` float NOT NULL default '0' AFTER `ammo_type` 

Error occured at:2009-12-04 17:01:28
Line no.:1
Error Code: 1060 - Duplicate column name 'RangedModRange'

Query:
ALTER TABLE `areatrigger_involvedrelation` DROP `creature` 

Error occured at:2009-12-04 17:01:53
Line no.:1
Error Code: 1091 - Can't DROP 'creature'; check that column/key exists

Query:
ALTER TABLE `creature_template`
   DROP KEY `entry` ,
   ADD PRIMARY KEY (`entry`) 

Error occured at:2009-12-04 17:02:00
Line no.:3
Error Code: 1091 - Can't DROP 'entry'; check that column/key exists

Query:
ALTER TABLE `gameobject_template`
   DROP KEY `id` ,
   ADD PRIMARY KEY (`entry`) 

Error occured at:2009-12-04 17:02:08
Line no.:3
Error Code: 1091 - Can't DROP 'id'; check that column/key exists

Query:
ALTER TABLE `character_inventory`
   DROP KEY `idx_guid` ,
   ADD PRIMARY KEY  (`guid`,`bag`,`slot`) 

Error occured at:2009-12-04 17:02:32
Line no.:3
Error Code: 1146 - Table 'mangos.character_inventory' doesn't exist

Query:
ALTER TABLE `character_inventory`
   DROP KEY `idx_guid` ,
   ADD PRIMARY KEY  (`guid`,`bag`,`slot`) 

Error occured at:2009-12-04 17:02:39
Line no.:3
Error Code: 1146 - Table 'mangos.character_inventory' doesn't exist

Query:
ALTER TABLE `item_template`
   CHANGE `dmg_min1` `dmg_min1` float NOT NULL default '0',
   CHANGE `dmg_max1` `dmg_max1` float NOT NULL default '0',
   CHANGE `dmg_min2` `dmg_min2` float NOT NULL default '0',
   CHANGE `dmg_max2` `dmg_max2` float NOT NULL default '0',
   CHANGE `dmg_min3` `dmg_min3` float NOT NULL default '0',
   CHANGE `dmg_max3` `dmg_max3` float NOT NULL default '0',
   CHANGE `dmg_min4` `dmg_min4` float NOT NULL default '0',
   CHANGE `dmg_max4` `dmg_max4` float NOT NULL default '0',
   CHANGE `dmg_min5` `dmg_min5` float NOT NULL default '0',
   CHANGE `dmg_max5` `dmg_max5` float NOT NULL default '0'

Error occured at:2009-12-04 17:02:47
Line no.:11
Error Code: 1054 - Unknown column 'dmg_min3' in 'item_template'

Query:
ALTER TABLE `quest_template`
   CHANGE `Title`          `Title`          text,
   CHANGE `Details`        `Details`        text,
   CHANGE `Objectives`     `Objectives`     text,
   CHANGE `CompletionText` `CompletionText` text,
   CHANGE `IncompleteText` `IncompleteText` text,
   CHANGE `EndText`        `EndText`        text,
   CHANGE `ObjectiveText1` `ObjectiveText1` text,
   CHANGE `ObjectiveText2` `ObjectiveText2` text,
   CHANGE `ObjectiveText3` `ObjectiveText3` text,
   CHANGE `ObjectiveText4` `ObjectiveText4` text

Error occured at:2009-12-04 17:03:07
Line no.:11
Error Code: 1054 - Unknown column 'CompletionText' in 'quest_template'

Query:
CREATE DATABASE `realmd` 

Error occured at:2009-12-04 17:03:25
Line no.:2
Error Code: 1007 - Can't create database 'realmd'; database exists

Query:
insert into realmd.realmlist
select `id`, `name`, `address`, `icon`, `color`, `timezone` from mangos.realmlist

Error occured at:2009-12-04 17:03:35
Line no.:3
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
ALTER TABLE `object_involvedrelation`
   RENAME TO `gameobject_involvedrelation`,
   DROP PRIMARY KEY,
   DROP `Id`,
   CHANGE `objectId` `id` int(11) unsigned NOT NULL default '0',
   CHANGE `questId` `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier' AFTER `id`,
   ADD PRIMARY KEY  (`id`,`quest`)

Error occured at:2009-12-04 17:03:50
Line no.:7
Error Code: 1146 - Table 'mangos.object_involvedrelation' doesn't exist

Query:
ALTER TABLE `object_questrelation`
   RENAME TO `gameobject_questrelation`,
   DROP PRIMARY KEY,
   DROP `Id`,
   CHANGE `objectId` `id` int(11) unsigned NOT NULL default '0',
   CHANGE `questId` `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier' AFTER `id`,
   ADD PRIMARY KEY  (`id`,`quest`)

Error occured at:2009-12-04 17:03:55
Line no.:7
Error Code: 1146 - Table 'mangos.object_questrelation' doesn't exist

Query:
ALTER TABLE `npc_vendor`
   DROP PRIMARY KEY,
   DROP KEY `vendor_id` ,
   DROP `index_id`,
   CHANGE `entry`    `entry`    int(11) unsigned NOT NULL default '0',
   CHANGE `itemguid` `item`     int(11) unsigned NOT NULL default '0',
   CHANGE `amount`   `buycount` int(11) unsigned NOT NULL default '1',
   ADD               `maxcount` int(11) unsigned NOT NULL default '0',
   ADD               `incrtime` int(11) unsigned NOT NULL default '0'

Error occured at:2009-12-04 17:04:04
Line no.:9
Error Code: 1054 - Unknown column 'itemguid' in 'npc_vendor'

Query:
ALTER TABLE `creature_template`
   ADD `mingold` int(30) unsigned NOT NULL default '0' AFTER `spell4` ,
   ADD `maxgold` int(30) unsigned NOT NULL default '0' AFTER `mingold`

Error occured at:2009-12-04 17:04:11
Line no.:3
Error Code: 1060 - Duplicate column name 'mingold'

Query:
INSERT INTO `command` VALUES ('additemset',3,'Syntax: .additemset #itemsetid\r\n\r\nAdd items from itemset of id #itemsetid to your inventory. Will add by one example each item from itemset.')

Error occured at:2009-12-04 17:04:19
Line no.:1
Error Code: 1062 - Duplicate entry 'additemset' for key 1

Query:
CREATE TABLE `areatrigger_graveyard_zone` AS SELECT
  `areatrigger_graveyard`.`id` AS `id`,
  `areatrigger_graveyard`.`map`  AS `ghost_map`,
  `areatrigger_graveyard`.`zone` AS `ghost_zone`
FROM `areatrigger_graveyard` 

Error occured at:2009-12-04 17:04:26
Line no.:7
Error Code: 1146 - Table 'mangos.areatrigger_graveyard' doesn't exist

Query:
ALTER TABLE `areatrigger_graveyard`
   CHANGE `id` `id` int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier'

Error occured at:2009-12-04 17:04:42
Line no.:2
Error Code: 1146 - Table 'mangos.areatrigger_graveyard' doesn't exist

Query:
ALTER TABLE `character` CHANGE `honor` `highest_rank` INT( 11 ) DEFAULT '0' NOT NULL ,
CHANGE `last_week_honor` `standing` INT( 11 ) DEFAULT '0' NOT NULL 

Error occured at:2009-12-04 17:04:51
Line no.:2
Error Code: 1146 - Table 'mangos.character' doesn't exist

Query:
ALTER TABLE `character_spell`
   ADD `active` int(11) unsigned NOT NULL default '1'

Error occured at:2009-12-04 17:04:58
Line no.:2
Error Code: 1146 - Table 'mangos.character_spell' doesn't exist

Query:
ALTER TABLE `areatrigger_graveyard`
   RENAME TO `game_graveyard`

Error occured at:2009-12-04 17:05:05
Line no.:2
Error Code: 1146 - Table 'mangos.areatrigger_graveyard' doesn't exist

Query:
CREATE TABLE `game_tele` (
 `id` int(11) unsigned NOT NULL auto_increment,
 `position_x` float NOT NULL default '0',
 `position_y` float NOT NULL default '0',
 `position_z` float NOT NULL default '0',
 `orientation` float NOT NULL default '0',
 `map` int(11) unsigned NOT NULL default '0',
 `name` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Tele Command'

Error occured at:2009-12-04 17:05:14
Line no.:10
Error Code: 1050 - Table 'game_tele' already exists

Query:
ALTER TABLE `loot_template`
   ADD `questchance` float NOT NULL default '0'

Error occured at:2009-12-04 17:05:24
Line no.:2
Error Code: 1146 - Table 'mangos.loot_template' doesn't exist

Query:
ALTER TABLE `item_template` ADD COLUMN `BuyCount` TINYINT(3) UNSIGNED NOT NULL DEFAULT 1 AFTER `Flags`

Error occured at:2009-12-04 17:05:30
Line no.:1
Error Code: 1060 - Duplicate column name 'BuyCount'

Query:
ALTER TABLE `quest_template`
   ADD COLUMN `RequiredRepFaction` int(11) unsigned NOT NULL default '0' AFTER `RequiredTradeskill`,
   ADD COLUMN `RequiredRepValue` int(11) unsigned NOT NULL default '0' AFTER `RequiredRepFaction`,
   CHANGE `ReqKillMobId1` `ReqKillMobOrGOId1` int(11) NOT NULL default '0',
   CHANGE `ReqKillMobId2` `ReqKillMobOrGOId2` int(11) NOT NULL default '0',
   CHANGE `ReqKillMobId3` `ReqKillMobOrGOId3` int(11) NOT NULL default '0',
   CHANGE `ReqKillMobId4` `ReqKillMobOrGOId4` int(11) NOT NULL default '0',
   CHANGE `ReqKillMobCount1` `ReqKillMobOrGOCount1` int(11) unsigned NOT NULL default '0',
   CHANGE `ReqKillMobCount2` `ReqKillMobOrGOCount2` int(11) unsigned NOT NULL default '0',
   CHANGE `ReqKillMobCount3` `ReqKillMobOrGOCount3` int(11) unsigned NOT NULL default '0',
   CHANGE `ReqKillMobCount4` `ReqKillMobOrGOCount4` int(11) unsigned NOT NULL default '0'

Error occured at:2009-12-04 17:05:34
Line no.:11
Error Code: 1054 - Unknown column 'RequiredTradeskill' in 'quest_template'

Query:
ALTER TABLE `game_corpse` DROP INDEX `idx_player`

Error occured at:2009-12-04 17:05:39
Line no.:1
Error Code: 1146 - Table 'mangos.game_corpse' doesn't exist

Query:
insert into command values('maxskill','3','Usage: .maxskill\r\nSets all skills of the targeted player to their maximum values for its current level.')

Error occured at:2009-12-04 17:06:04
Line no.:1
Error Code: 1062 - Duplicate entry 'maxskill' for key 1

Query:
ALTER TABLE `quest_template`
   ADD COLUMN `QuestSort` int(11) unsigned NOT NULL default '0' AFTER `ZoneId`

Error occured at:2009-12-04 17:06:09
Line no.:2
Error Code: 1054 - Unknown column 'ZoneId' in 'quest_template'

Query:
CREATE TABLE `creature_loot_template` AS SELECT DISTINCT
  `loot_template`.`entry`        AS `entry`,
  `loot_template`.`item`         AS `item`,
  `loot_template`.`chance`       AS `chance`,
  `loot_template`.`questchance`  AS `questchance`
FROM `loot_template`, `creature_template` WHERE `loot_template`.`entry` = `creature_template`.`lootid`

Error occured at:2009-12-04 17:06:14
Line no.:6
Error Code: 1146 - Table 'mangos.loot_template' doesn't exist

Query:
INSERT INTO command VALUES('whispers','1','Usage: .whispers on|off\r\nEnable/disable accepting whispers by GM from players. By default use mangosd.conf setting.')

Error occured at:2009-12-04 17:06:25
Line no.:1
Error Code: 1062 - Duplicate entry 'whispers' for key 1

Query:
ALTER TABLE `game_corpse`
   RENAME TO `corpse`

Error occured at:2009-12-04 17:06:30
Line no.:2
Error Code: 1146 - Table 'mangos.game_corpse' doesn't exist

Query:
ALTER IGNORE TABLE `playercreateinfo_skill`
   ADD PRIMARY KEY (`createid`,`Skill`)

Error occured at:2009-12-04 17:06:37
Line no.:2
Error Code: 1146 - Table 'mangos.playercreateinfo_skill' doesn't exist

Query:
ALTER IGNORE TABLE `playercreateinfo_spell`
   ADD PRIMARY KEY (`createid`,`Spell`)

Error occured at:2009-12-04 17:06:45
Line no.:2
Error Code: 1072 - Key column 'createid' doesn't exist in table

Query:
ALTER IGNORE TABLE `playercreateinfo_spell`
   ADD PRIMARY KEY (`createid`,`Spell`)

Error occured at:2009-12-04 17:06:52
Line no.:2
Error Code: 1072 - Key column 'createid' doesn't exist in table

Query:
ALTER TABLE `quest_template`
   CHANGE `MaxLevel` `QuestLevel` int(11) unsigned NOT NULL default '0',
   CHANGE `RewMoney` `RewOrReqMoney` int(11) NOT NULL default '0'

Error occured at:2009-12-04 17:07:06
Line no.:3
Error Code: 1054 - Unknown column 'MaxLevel' in 'quest_template'

Query:
ALTER TABLE `creature_template`
   ADD `trainer_spell` int(11) unsigned default '0' AFTER `trainer_type`,
   ADD `race`          int(11) unsigned default '0' AFTER `class`

Error occured at:2009-12-04 17:08:03
Line no.:3
Error Code: 1054 - Unknown column 'class' in 'creature_template'

Query:
ALTER TABLE `quest_template`
   CHANGE `RequiredTradeskill` `RequiredSkill` int(11) unsigned NOT NULL default '0',
   ADD COLUMN `RequiredSkillValue` int(11) unsigned NOT NULL default '1' AFTER `RequiredSkill`

Error occured at:2009-12-04 17:08:09
Line no.:3
Error Code: 1054 - Unknown column 'RequiredTradeskill' in 'quest_template'

Query:
ALTER TABLE `npc_trainer`
   CHANGE `reqspell` `reqspell` int(11) unsigned default '0',
   CHANGE `reqskill` `reqskill` int(11) unsigned default '0',
   CHANGE `reqskillvalue` `reqskillvalue` int(11) unsigned default '0',
   ADD COLUMN `reqlevel` int(11) unsigned default '0'

Error occured at:2009-12-04 17:08:26
Line no.:5
Error Code: 1054 - Unknown column 'reqspell' in 'npc_trainer'

Query:
INSERT INTO `playercreateinfo_spell` VALUES ('21', '3025', 'Cat Form Passive', '0')

Error occured at:2009-12-04 17:08:41
Line no.:2
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
ALTER TABLE `character`
   ADD `totaltime` int(11) unsigned NOT NULL default '0',
   ADD `leveltime` int(11) unsigned NOT NULL default '0'

Error occured at:2009-12-04 17:09:03
Line no.:3
Error Code: 1146 - Table 'mangos.character' doesn't exist

Query:
ALTER TABLE `npc_trainer`
   DROP PRIMARY KEY,
   DROP `rowid`,
   ADD UNIQUE KEY `entry_spell` (`entry`,`spell`)

Error occured at:2009-12-04 17:09:21
Line no.:4
Error Code: 1091 - Can't DROP 'PRIMARY'; check that column/key exists

Query:
ALTER TABLE `playercreateinfo`
   DROP `attackpower`,
   DROP `mindmg`,
   DROP `maxdmg`,
   DROP `ranmindmg`,
   DROP `ranmaxdmg`

Error occured at:2009-12-04 17:09:26
Line no.:6
Error Code: 1091 - Can't DROP 'attackpower'; check that column/key exists

Query:
ALTER TABLE `character_pet`
   DROP `name`,
   ADD `loyalty` int(11) unsigned NOT NULL default '1',
   ADD `trainpoint` int(11) unsigned NOT NULL default '0'

Error occured at:2009-12-04 17:10:35
Line no.:4
Error Code: 1146 - Table 'mangos.character_pet' doesn't exist

Query:
ALTER TABLE `realmd`.`realmlist`
   ADD `port` int(11) NOT NULL default '8085' AFTER `address`

Error occured at:2009-12-04 17:10:41
Line no.:2
Error Code: 1060 - Duplicate column name 'port'

Query:
ALTER TABLE `realmd`.`realmlist`
   ADD `port` int(11) NOT NULL default '8085' AFTER `address`

Error occured at:2009-12-04 17:11:01
Line no.:2
Error Code: 1060 - Duplicate column name 'port'

Query:
ALTER TABLE `character`
   ADD `logout_time` int(11) NOT NULL DEFAULT '0',
   ADD `is_logout_resting` int(11) NOT NULL DEFAULT '0',
   ADD `rest_bonus` FLOAT NOT NULL DEFAULT '0'

Error occured at:2009-12-04 17:11:08
Line no.:4
Error Code: 1146 - Table 'mangos.character' doesn't exist

Query:
ALTER TABLE `quest_template`
 CHANGE `ReqKillMobOrGOId1` `ReqCreatureOrGOId1` int(11) NOT NULL default '0',
 CHANGE `ReqKillMobOrGOId2` `ReqCreatureOrGOId2` int(11) NOT NULL default '0',
 CHANGE `ReqKillMobOrGOId3` `ReqCreatureOrGOId3` int(11) NOT NULL default '0',
 CHANGE `ReqKillMobOrGOId4` `ReqCreatureOrGOId4` int(11) NOT NULL default '0',
 CHANGE `ReqKillMobOrGOCount1` `ReqCreatureOrGOCount1` int(11) unsigned NOT NULL default '0',
 CHANGE `ReqKillMobOrGOCount2` `ReqCreatureOrGOCount2` int(11) unsigned NOT NULL default '0',
 CHANGE `ReqKillMobOrGOCount3` `ReqCreatureOrGOCount3` int(11) unsigned NOT NULL default '0',
 CHANGE `ReqKillMobOrGOCount4` `ReqCreatureOrGOCount4` int(11) unsigned NOT NULL default '0',
 ADD COLUMN `ReqSpellCast1` int(11) unsigned NOT NULL default '0' AFTER `ReqCreatureOrGOCount4`,
 ADD COLUMN `ReqSpellCast2` int(11) unsigned NOT NULL default '0' AFTER `ReqSpellCast1`,
 ADD COLUMN `ReqSpellCast3` int(11) unsigned NOT NULL default '0' AFTER `ReqSpellCast2`,
 ADD COLUMN `ReqSpellCast4` int(11) unsigned NOT NULL default '0' AFTER `ReqSpellCast3`

Error occured at:2009-12-04 17:11:15
Line no.:13
Error Code: 1054 - Unknown column 'ReqKillMobOrGOId1' in 'quest_template'

Query:
ALTER TABLE `playercreateinfo_action`
 DROP KEY `playercreateinfo_actions_index`,
 ADD KEY `playercreateinfo_actions_index` (`createid`,`button`)

Error occured at:2009-12-04 17:11:26
Line no.:3
Error Code: 1091 - Can't DROP 'playercreateinfo_actions_index'; check that column/key exists

Query:
INSERT INTO command VALUES('shutdown','3','Syntax: .shutdown #delay|stop\r\n\r\nShutting down server after #delay seconds or stop shutting down if stop value used.')

Error occured at:2009-12-04 17:11:32
Line no.:1
Error Code: 1062 - Duplicate entry 'shutdown' for key 1

Query:
ALTER TABLE `creature_template`
 ADD COLUMN `MovementType` int(11) unsigned NOT NULL default '0' AFTER `MoveName`

Error occured at:2009-12-04 17:11:38
Line no.:2
Error Code: 1054 - Unknown column 'MoveName' in 'creature_template'

Query:
ALTER TABLE `areatrigger_template`
   CHANGE `trigger_postion_x` `trigger_position_x` FLOAT NOT NULL DEFAULT '0'

Error occured at:2009-12-04 17:11:44
Line no.:2
Error Code: 1146 - Table 'mangos.areatrigger_template' doesn't exist

Query:
ALTER TABLE `creature_template`
 CHANGE `level`     `minlevel`  int(3) unsigned default '1',
 CHANGE `level_max` `maxlevel`  int(3) unsigned default '1' AFTER `minlevel`,
 ADD COLUMN         `minhealth` int(5) unsigned default '0' AFTER `maxlevel`,
 CHANGE `maxhealth` `maxhealth` int(5) unsigned default '0' AFTER `minhealth`,
 ADD COLUMN         `minmana`   int(5) unsigned default '0' AFTER `maxhealth`,
 CHANGE `maxmana`   `maxmana`   int(5) unsigned default '0' AFTER `minmana`

Error occured at:2009-12-04 17:11:57
Line no.:7
Error Code: 1054 - Unknown column 'level' in 'creature_template'

Query:
ALTER TABLE `character_queststatus`
 CHANGE `rewarded` `rewarded` tinyint(1) unsigned NOT NULL default '0',
 CHANGE `explored` `explored` tinyint(1) unsigned NOT NULL default '0',
 ADD COLUMN `completed_once`  tinyint(1) unsigned NOT NULL default '0' AFTER `explored`

Error occured at:2009-12-04 17:12:03
Line no.:4
Error Code: 1146 - Table 'mangos.character_queststatus' doesn't exist

Query:
ALTER TABLE `quest_template`
 ADD `ReqSourceId1`  int(11) unsigned NOT NULL default '0' AFTER `ReqItemCount4` ,
 ADD `ReqSourceId2`  int(11) unsigned NOT NULL default '0' AFTER `ReqSourceId1`  ,
 ADD `ReqSourceId3`  int(11) unsigned NOT NULL default '0' AFTER `ReqSourceId2`  ,
 ADD `ReqSourceId4`  int(11) unsigned NOT NULL default '0' AFTER `ReqSourceId3`  ,
 ADD `ReqSourceRef1` int(11) unsigned NOT NULL default '0' AFTER `ReqSourceId4`  ,
 ADD `ReqSourceRef2` int(11) unsigned NOT NULL default '0' AFTER `ReqSourceRef1` ,
 ADD `ReqSourceRef3` int(11) unsigned NOT NULL default '0' AFTER `ReqSourceRef2` ,
 ADD `ReqSourceRef4` int(11) unsigned NOT NULL default '0' AFTER `ReqSourceRef3` 

Error occured at:2009-12-04 17:12:31
Line no.:9
Error Code: 1060 - Duplicate column name 'ReqSourceId1'

Query:
ALTER TABLE `quest_template`
    ADD `DetailsEmote` int(11) NOT NULL default '0',
    ADD `IncompleteEmote` int(11) NOT NULL default '0',
    ADD `CompleteEmote` int(11) NOT NULL default '0'

Error occured at:2009-12-04 17:12:39
Line no.:4
Error Code: 1060 - Duplicate column name 'IncompleteEmote'

Query:
INSERT INTO command VALUES('pinfo','2','Syntax: .pinfo [$player_name]\r\n\r\nOutput account information for selected player or player find by $player_name.')

Error occured at:2009-12-04 17:13:03
Line no.:1
Error Code: 1062 - Duplicate entry 'pinfo' for key 1

Query:
ALTER TABLE `game_graveyard_zone`
 ADD COLUMN `faction` int(11) unsigned NOT NULL default '0' AFTER `ghost_zone`

Error occured at:2009-12-04 17:13:23
Line no.:2
Error Code: 1060 - Duplicate column name 'faction'

Query:
ALTER TABLE `quest_template`
 ADD `ExclusiveGroup` int(11) unsigned NOT NULL default '0' AFTER `NextQuestId`

Error occured at:2009-12-04 17:13:33
Line no.:2
Error Code: 1060 - Duplicate column name 'ExclusiveGroup'

Query:
ALTER TABLE `creature_loot_template`
 ADD `maxcount` int(11) unsigned NOT NULL default '1'

Error occured at:2009-12-04 17:13:49
Line no.:2
Error Code: 1060 - Duplicate column name 'maxcount'

Query:
CREATE TABLE `item_loot_template` (
 `entry` int(11) unsigned NOT NULL default '0',
 `item` int(11) unsigned NOT NULL default '0',
 `chance` float NOT NULL default '100',
 `questchance` float NOT NULL default '0',
 `maxcount` int(11) unsigned NOT NULL default '1',
 PRIMARY KEY  (`entry`,`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'

Error occured at:2009-12-04 17:14:02
Line no.:8
Error Code: 1050 - Table 'item_loot_template' already exists

Query:
ALTER TABLE `guild_rank`
 ADD `rid` int(11) unsigned NOT NULL AFTER `guildid`,
 ADD PRIMARY KEY (`guildid`,`rid`)

Error occured at:2009-12-04 17:14:23
Line no.:3
Error Code: 1146 - Table 'mangos.guild_rank' doesn't exist

Query:
DELETE FROM `auctionhouse`

Error occured at:2009-12-04 17:14:29
Line no.:1
Error Code: 1146 - Table 'mangos.auctionhouse' doesn't exist

Query:
ALTER TABLE `guild`
 ADD `info` TEXT NOT NULL AFTER `BackgroundColor` 

Error occured at:2009-12-04 17:14:40
Line no.:2
Error Code: 1146 - Table 'mangos.guild' doesn't exist

Query:
ALTER TABLE skinning_loot_template ADD COLUMN quest_freeforall int(1) unsigned NOT NULL default '1' AFTER `maxcount`

Error occured at:2009-12-04 17:14:49
Line no.:6
Error Code: 1054 - Unknown column 'maxcount' in 'skinning_loot_template'

Query:
UPDATE `character` SET `name` = CONCAT(UCASE(SUBSTRING(`name`,1,1)),LCASE(SUBSTRING(`name`,2)))

Error occured at:2009-12-04 17:14:55
Line no.:1
Error Code: 1146 - Table 'mangos.character' doesn't exist

Query:
ALTER TABLE `quest_template`
 CHANGE `srcItem` `SrcItemId` int(11) unsigned NOT NULL default '0',
 ADD `SrcSpell` int(11) unsigned NOT NULL default '0' AFTER `SrcItemCount`

Error occured at:2009-12-04 17:15:05
Line no.:3
Error Code: 1054 - Unknown column 'srcItem' in 'quest_template'

Query:
ALTER TABLE `creature_template`
   CHANGE  `modelid` `modelid_m` int(11) unsigned default '0',
   ADD `modelid_f` int(11) unsigned default '0' AFTER `modelid_m`

Error occured at:2009-12-04 17:15:10
Line no.:3
Error Code: 1054 - Unknown column 'modelid' in 'creature_template'

Query:
ALTER TABLE `character`
   ADD `resettalents_cost` int(11) unsigned NOT NULL default '0',
   ADD `resettalents_time` bigint(20) unsigned NOT NULL default '0'

Error occured at:2009-12-04 17:15:16
Line no.:3
Error Code: 1146 - Table 'mangos.character' doesn't exist

Query:
ALTER TABLE `character`
 ADD `instanceid` int(11) unsigned NOT NULL default '0' AFTER `map`

Error occured at:2009-12-04 17:15:21
Line no.:2
Error Code: 1146 - Table 'mangos.character' doesn't exist

Query:
ALTER TABLE `character`
 DROP `instanceid`

Error occured at:2009-12-04 17:15:31
Line no.:2
Error Code: 1146 - Table 'mangos.character' doesn't exist

Query:
ALTER TABLE `playercreateinfo_action`
 ADD `race` tinyint(3) unsigned NOT NULL default '0' FIRST,
 ADD `class` tinyint(3) unsigned NOT NULL default '0' AFTER `race`

Error occured at:2009-12-04 17:15:42
Line no.:3
Error Code: 1060 - Duplicate column name 'race'

Query:
ALTER TABLE `playercreateinfo_item`
 ADD `race` tinyint(3) unsigned NOT NULL default '0' FIRST,
 ADD `class` tinyint(3) unsigned NOT NULL default '0' AFTER `race`

Error occured at:2009-12-04 17:15:48
Line no.:3
Error Code: 1060 - Duplicate column name 'race'

Query:
ALTER TABLE `playercreateinfo_reputation`
 ADD `race` tinyint(3) unsigned NOT NULL default '0' FIRST,
 ADD `class` tinyint(3) unsigned NOT NULL default '0' AFTER `race`

Error occured at:2009-12-04 17:15:56
Line no.:3
Error Code: 1146 - Table 'mangos.playercreateinfo_reputation' doesn't exist

Query:
ALTER TABLE `playercreateinfo_skill`
 ADD `race` tinyint(3) unsigned NOT NULL default '0' FIRST,
 ADD `class` tinyint(3) unsigned NOT NULL default '0' AFTER `race`

Error occured at:2009-12-04 17:16:01
Line no.:3
Error Code: 1146 - Table 'mangos.playercreateinfo_skill' doesn't exist

Query:
ALTER TABLE `playercreateinfo_spell`
 ADD `race` tinyint(3) unsigned NOT NULL default '0' FIRST,
 ADD `class` tinyint(3) unsigned NOT NULL default '0' AFTER `race`

Error occured at:2009-12-04 17:16:07
Line no.:3
Error Code: 1060 - Duplicate column name 'race'

Query:
ALTER TABLE `playercreateinfo`
 DROP KEY `playercreateinfo_index`,
 DROP PRIMARY KEY ,
 DROP `createId` ,
 ADD PRIMARY KEY `playercreateinfo_race_class_index` (`race`,`class`) 

Error occured at:2009-12-04 17:16:14
Line no.:5
Error Code: 1091 - Can't DROP 'playercreateinfo_index'; check that column/key exists

Query:
ALTER TABLE `realmd`.`account`
 ADD `v` longtext AFTER `sessionkey`,
 ADD `s` longtext AFTER `v`

Error occured at:2009-12-04 17:16:27
Line no.:3
Error Code: 1060 - Duplicate column name 'v'

Query:
UPDATE `character` SET `logout_time` = '0', `rest_bonus` = '0'

Error occured at:2009-12-04 17:16:33
Line no.:1
Error Code: 1146 - Table 'mangos.character' doesn't exist

Query:
ALTER TABLE gameobject ADD COLUMN `animprogress` int(11) unsigned NOT NULL default '0'

Error occured at:2009-12-04 17:16:45
Line no.:1
Error Code: 1060 - Duplicate column name 'animprogress'

Query:
ALTER TABLE `character` ADD COLUMN `trans_x` float NOT NULL default '0'

Error occured at:2009-12-04 17:16:50
Line no.:1
Error Code: 1146 - Table 'mangos.character' doesn't exist

Query:
ALTER TABLE `auctionhouse`
 ADD `item_template` int(11) unsigned NOT NULL default '0' AFTER `itemguid`

Error occured at:2009-12-04 17:17:12
Line no.:2
Error Code: 1146 - Table 'mangos.auctionhouse' doesn't exist

Query:
ALTER TABLE `mail`
 ADD `item_template` int(11) unsigned NOT NULL default '0' AFTER `item`

Error occured at:2009-12-04 17:17:19
Line no.:2
Error Code: 1146 - Table 'mangos.mail' doesn't exist

Query:
ALTER TABLE `creature_loot_template`
 CHANGE `chance`      `ChanceOrRef` float NOT NULL default '100',
 CHANGE `questchance` `QuestChanceOrGroup` tinyint(3) NOT NULL default '0'

Error occured at:2009-12-04 17:17:34
Line no.:3
Error Code: 1054 - Unknown column 'chance' in 'creature_loot_template'

Query:
INSERT INTO `command` VALUES('saveall',1,'Syntax: .saveallr\n\r\nSave all characters in game.')

Error occured at:2009-12-04 17:17:40
Line no.:1
Error Code: 1062 - Duplicate entry 'saveall' for key 1

Query:
INSERT INTO `command` VALUES('modify money',1,'Syntax:\r\n.modify money #money\r\n.money #money\r\n\r\nAdd or remove money to the selected player. If no player is selected, modify your money.\r\n\r\n #gold can be negative to remove money.')

Error occured at:2009-12-04 17:17:55
Line no.:2
Error Code: 1062 - Duplicate entry 'modify money' for key 1

Query:
alter table quest_template
add column
 `CompleteScript` int(11) unsigned NOT NULL default '0'

Error occured at:2009-12-04 17:18:00
Line no.:11
Error Code: 1060 - Duplicate column name 'CompleteScript'

Query:
CREATE TABLE `scripts` (
 `id` int(11) unsigned NOT NULL default '0',
 `delay` int(11) unsigned NOT NULL default '0',
 `command` int(11) unsigned NOT NULL default '0',
 `datalong` int(11) unsigned NOT NULL default '0',
 `datalong2` int(11) unsigned NOT NULL default '0',
 `datatext` text NOT NULL default "",
 `x` float NOT NULL default '0',
 `y` float NOT NULL default '0',
 `z` float NOT NULL default '0',
 `o` float NOT NULL default '0'
)

Error occured at:2009-12-04 17:18:05
Line no.:13
Error Code: 1101 - BLOB/TEXT column 'datatext' can't have a default value

Query:
alter table quest_template
 change column `IncompleteText` `RequestItemsText` text

Error occured at:2009-12-04 17:18:30
Line no.:6
Error Code: 1054 - Unknown column 'IncompleteText' in 'quest_template'

Query:
ALTER TABLE `playercreateinfo`
 DROP `BaseStrength`,
 DROP `BaseAgility`,
 DROP `BaseStamina`,
 DROP `BaseIntellect`,
 DROP `BaseSpirit`,
 DROP `BaseArmor`,
 DROP `BaseHealth`,
 DROP `BaseMana`,
 DROP `BaseRage`,
 DROP `BaseFocus`,
 DROP `BaseEnergy`

Error occured at:2009-12-04 17:18:48
Line no.:12
Error Code: 1091 - Can't DROP 'BaseStrength'; check that column/key exists

Query:
UPDATE character_inventory SET bag = 0 WHERE bag = 255

Error occured at:2009-12-04 17:19:10
Line no.:1
Error Code: 1146 - Table 'mangos.character_inventory' doesn't exist

Query:
alter table quest_template
 drop column detailsemote

Error occured at:2009-12-04 17:19:23
Line no.:2
Error Code: 1091 - Can't DROP 'detailsemote'; check that column/key exists

Query:
ALTER TABLE `creature`
   DROP `npcflags`,
   DROP `faction`

Error occured at:2009-12-04 17:19:39
Line no.:3
Error Code: 1091 - Can't DROP 'npcflags'; check that column/key exists

Query:
UPDATE `item_instance`
 SET `data` = CONCAT(`data`,' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ')
 WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',3),' ',-1) = 7 AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',91),' ',-1) = ''

Error occured at:2009-12-04 17:20:13
Line no.:3
Error Code: 1146 - Table 'mangos.item_instance' doesn't exist

Query:
ALTER TABLE `character_pet`
 ADD `name` varchar(12) default 'Pet' AFTER `trainpoint`

Error occured at:2009-12-04 17:20:38
Line no.:2
Error Code: 1146 - Table 'mangos.character_pet' doesn't exist

Query:
ALTER TABLE `character_pet`
 CHANGE COLUMN `name` `name` varchar(100) NULL DEFAULT 'Pet'

Error occured at:2009-12-04 17:20:49
Line no.:2
Error Code: 1146 - Table 'mangos.character_pet' doesn't exist

Query:
ALTER TABLE `character`                DROP KEY `idx_name`, ENGINE = InnoDB

Error occured at:2009-12-04 17:20:58
Line no.:2
Error Code: 1146 - Table 'mangos.character' doesn't exist

Query:
ALTER TABLE `corpse_grid`     ENGINE = MEMORY

Error occured at:2009-12-04 17:21:03
Line no.:1
Error Code: 1146 - Table 'mangos.corpse_grid' doesn't exist

Query:
ALTER TABLE `creature_grid`   ENGINE = MEMORY

Error occured at:2009-12-04 17:21:08
Line no.:1
Error Code: 1146 - Table 'mangos.creature_grid' doesn't exist

Query:
ALTER TABLE `gameobject_grid` ENGINE = MEMORY

Error occured at:2009-12-04 17:21:13
Line no.:1
Error Code: 1146 - Table 'mangos.gameobject_grid' doesn't exist

Query:
ALTER TABLE `character_pet`
 ADD COLUMN `modelid` int(11) unsigned default '0' after `owner`

Error occured at:2009-12-04 17:21:19
Line no.:2
Error Code: 1146 - Table 'mangos.character_pet' doesn't exist

Query:
ALTER TABLE `character_pet`
 ADD COLUMN `renamed` tinyint(1) unsigned NOT NULL default '0' after `name`

Error occured at:2009-12-04 17:21:33
Line no.:2
Error Code: 1146 - Table 'mangos.character_pet' doesn't exist

Query:
ALTER TABLE `npc_trainer`
 DROP `reqspell`

Error occured at:2009-12-04 17:21:54
Line no.:2
Error Code: 1091 - Can't DROP 'reqspell'; check that column/key exists

Query:
ALTER TABLE `character`
   DROP `realm`

Error occured at:2009-12-04 17:22:17
Line no.:2
Error Code: 1146 - Table 'mangos.character' doesn't exist

Query:
ALTER TABLE `areatrigger_template` ADD `required_level` SMALLINT NOT NULL DEFAULT '0' AFTER `name` 

Error occured at:2009-12-04 17:22:26
Line no.:1
Error Code: 1146 - Table 'mangos.areatrigger_template' doesn't exist

Query:
ALTER TABLE `character`
   ADD `gmstate` tinyint(3) unsigned NOT NULL default '0'

Error occured at:2009-12-04 17:22:32
Line no.:2
Error Code: 1146 - Table 'mangos.character' doesn't exist

Query:
DELETE FROM `playercreateinfo_skill` WHERE `Skill` = 633

Error occured at:2009-12-04 17:22:46
Line no.:1
Error Code: 1146 - Table 'mangos.playercreateinfo_skill' doesn't exist

Query:
ALTER TABLE `scripts`
 CHANGE COLUMN `datatext` `datatext` text NOT NULL

Error occured at:2009-12-04 17:23:00
Line no.:2
Error Code: 1146 - Table 'mangos.scripts' doesn't exist

Query:
ALTER TABLE db_version CHANGE COLUMN required_7980_01_mangos_item_required_target required_7988_01_mangos_item_template bit

Error occured at:2009-12-04 17:23:45
Line no.:1
Error Code: 1054 - Unknown column 'required_7980_01_mangos_item_required_target' in 'db_version'

Query:
ALTER TABLE db_version CHANGE COLUMN required_7980_01_mangos_item_required_target required_7988_01_mangos_item_template bit

Error occured at:2009-12-04 17:25:12
Line no.:1
Error Code: 1054 - Unknown column 'required_7980_01_mangos_item_required_target' in 'db_version'

Edited by Kaylo

Share this post

Link to post
Share on other sites

Eessencia    1069

Eessencia
Posted (edited)

počítá se jen poslední error... což je

Query:
ALTER TABLE db_version CHANGE COLUMN required_7980_01_mangos_item_required_target required_7988_01_mangos_item_template bit

Error occured at:2009-12-04 17:25:12
Line no.:1
Error Code: 1054 - Unknown column 'required_7980_01_mangos_item_required_target' in 'db_version'

 

takže nahraj do DB

UPDATE `db_version` SET `required_7980_01_mangos_item_required_target` = 'required_7988_01_mangos_item_template';

Pokud to nepujde, tak musíš ručně pomocí ALTER TABLE v SQLYOGU přejmenovat v tabulce db_version tu tabulku na "required_7988_01_mangos_item_template"

Edited by nEcr(o_V)isiOn

Share this post

Link to post
Share on other sites

Kaylo    1

Kaylo
Posted

počítá se jen poslední error... což je

Query:
ALTER TABLE db_version CHANGE COLUMN required_7980_01_mangos_item_required_target required_7988_01_mangos_item_template bit

Error occured at:2009-12-04 17:25:12
Line no.:1
Error Code: 1054 - Unknown column 'required_7980_01_mangos_item_required_target' in 'db_version'

 

takže nahraj do DB

UPDATE `db_version` SET `required_7980_01_mangos_item_required_target` = 'required_7988_01_mangos_item_template';

Pokud to nepujde, tak musíš ručně pomocí ALTER TABLE v SQLYOGU přejmenovat v tabulce db_version tu tabulku na "required_7988_01_mangos_item_template"

 

 

jo to se povedlo ale ted vznikl novy problem kteremu uz nerozumim ..... s necim si vim rady sam ale s timhle sem se jeste nesetkal pri normalnim sql atd chyba hlasi

 

 

 

 



Error occured at:2009-12-04 18:19:49
Line no.:140
Error Code: 1062 - Duplicate entry '0' for key 1

Query:
INSERT INTO spell_chain VALUES
/*------------------
/*Fiery Payback*/
(64353,0,64353,1,0),
(64357,64353,64353,2,0),
/*------------------
/*Body and Soul*/
(64127,0,64127,1,0),
(64129,64127,64127,2,0),
/*Empowered Renew*/
(63534,0,63534,1,0),
(63542,63534,63534,2,0),
(63543,63542,63534,3,0),
/*Serendipity*/
(63730,0,63730,1,0),
(63733,63730,63730,2,0),
(63737,63733,63730,3,0),
/*------------------
/*Improved Devouring Plague*/
(63625,0,63625,1,0),
(63626,63625,63625,2,0),
(63627,63626,63625,3,0),
/*------------------
/*Divinity*/
(63646,0,63646,1,0),
(63647,63646,63646,2,0),
(63648,63647,63646,3,0),
(63649,63648,63646,4,0),
(63650,63649,63646,5,0),
/*------------------
/*Shark Attack*/
(62759,0,62759,1,0),
(62760,62759,62759,2,0),
/*Silverback*/
(62764,0,62764,1,0),
(62765,62764,62764,2,0),
/*Wild Hunt*/
(62758,0,62758,1,0),
(62762,62758,62758,2,0),
/*------------------
/*Decimation*/
(63156,0,63156,1,0),
(63158,63156,63156,2,0),
/*Nemesis*/
(63117,0,63117,1,0),
(63121,63117,63117,2,0),
(63123,63121,63117,3,0),
/*------------------
/*Frozen Power*/
(63373,0,63373,1,0),
(63374,63373,63373,2,0),
/*------------------
/*Booming Echoes*/
(63370,0,63370,1,0),
(63372,63370,63370,2,0),
/*------------------
/*Improved Barkskin*/
(63410,0,63410,1,0),
(63411,63410,63410,2,0),
/*------------------
/*Molten Skin*/
(63349,0,63349,1,0),
(63350,63349,63349,2,0),
(63351,63350,63349,3,0),
/*------------------
/*Improved Flash Heal*/
(63504,0,63504,1,0),
(63505,63504,63504,2,0),
(63506,63505,63504,3,0),
/*------------------
/*Death Coil*/
(62900,0,62900,1,0),
(62901,62900,62900,2,0),
(62902,62901,62900,3,0),
(62903,62902,62900,4,0),
(62904,62903,62900,5,0),
/*Improved Blood Presence*/
(50365,0,50365,1,0),
(50371,50365,50365,2,0),
/*Improved Death Strike*/
(62905,0,62905,1,0),
(62908,62905,62905,2,0),
/*------------------
/*Howling Blast*/
(49184,0,49184,1,0),
(51409,49184,49184,2,0),
(51410,51409,49184,3,0),
(51411,51410,49184,4,0),
/*Improved Frost Presence*/
(50384,0,50384,1,0),
(50385,50384,50384,2,0),
/*------------------
/*Improved Unholy Presence*/
(50391,0,50391,1,0),
(50392,50391,50391,2,0),
/*Magic Suppression*/
(49224,0,49224,1,0),
(49610,49224,49224,2,0),
(49611,49610,49224,3,0)

Error occured at:2009-12-04 18:22:14
Line no.:140
Error Code: 1062 - Duplicate entry '0' for key 1

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Go To Topic Listing MaNGOS
×