rendered paste body[Err] 1265 - Data truncated for column 'currentwaypoint' at row 51335
[Err] ALTER TABLE `creature`
CHANGE COLUMN `guid` `guid` int(11) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier',
CHANGE COLUMN `id` `id` int(11) unsigned NOT NULL default '0' COMMENT 'Creature Identifier',
CHANGE COLUMN `map` `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
CHANGE COLUMN `spawntimesecs` `spawntimesecs` int(11) unsigned NOT NULL default '120',
CHANGE COLUMN `currentwaypoint` `currentwaypoint` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `curhealth` `curhealth` int(11) unsigned NOT NULL default '1',
CHANGE COLUMN `curmana` `curmana` int(11) unsigned NOT NULL default '0';
[Err] 1265 - Data truncated for column 'mount' at row 16547
[Err] ALTER TABLE `creature_addon`
CHANGE COLUMN `mount` `mount` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `bytes0` `bytes0` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `bytes1` `bytes1` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `bytes2` `bytes2` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `emote` `emote` int(11) unsigned NOT NULL default '0';
[Err] 1264 - Out of range value adjusted for column 'race' at row 16429
[Err] ALTER TABLE `creature_template`
CHANGE COLUMN `entry` `entry` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `name` `name` char(100) NOT NULL default '0',
CHANGE COLUMN `subname` `subname` char(100) default NULL,
CHANGE COLUMN `npcflag` `npcflag` int(4) unsigned default '0',
CHANGE COLUMN `rank` `rank` tinyint(3) unsigned default '0',
CHANGE COLUMN `flags` `flags` int(11) unsigned default '0',
CHANGE COLUMN `dynamicflags` `dynamicflags` int(11) unsigned default '0',
CHANGE COLUMN `trainer_type` `trainer_type` tinyint(3) default '0',
CHANGE COLUMN `trainer_spell` `trainer_spell` int(11) unsigned default '0',
CHANGE COLUMN `class` `class` tinyint(3) unsigned default '0',
CHANGE COLUMN `race` `race` tinyint(3) unsigned default '0',
CHANGE COLUMN `type` `type` tinyint(3) unsigned default '0',
CHANGE COLUMN `civilian` `civilian` tinyint(3) unsigned NOT NULL default '0',
CHANGE COLUMN `flag1` `flag1` int(11) unsigned default '0',
CHANGE COLUMN `spell1` `spell1` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spell2` `spell2` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spell3` `spell3` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spell4` `spell4` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `mingold` `mingold` int(30) unsigned NOT NULL default '0',
CHANGE COLUMN `maxgold` `maxgold` int(30) unsigned NOT NULL default '0',
CHANGE COLUMN `AIName` `AIName` char(128) NOT NULL default '',
CHANGE COLUMN `MovementType` `MovementType` tinyint(3) unsigned NOT NULL default '0',
CHANGE COLUMN `ScriptName` `ScriptName` char(128) NOT NULL default '';
[Err] 1054 - Unknown column 'CondExtendedCost' in 'item_template'
[Err] -- not like mangos
-- Item_template of MaNGOS is crazy, I won't duplicate this mess, will fix later in MaNGOS svn
ALTER TABLE `item_template`
CHANGE COLUMN `entry` `entry` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `displayid` `displayid` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `Flags` `Flags` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `BuyPrice` `BuyPrice` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `SellPrice` `SellPrice` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `ItemLevel` `ItemLevel` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `RequiredSkill` `RequiredSkill` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `RequiredSkillRank` `RequiredSkillRank` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `requiredspell` `requiredspell` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `requiredhonorrank` `requiredhonorrank` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `RequiredCityRank` `RequiredCityRank` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `RequiredReputationFaction` `RequiredReputationFaction` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `RequiredReputationRank` `RequiredReputationRank` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `armor` `armor` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `holy_res` `holy_res` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `fire_res` `fire_res` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `nature_res` `nature_res` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `frost_res` `frost_res` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `shadow_res` `shadow_res` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `arcane_res` `arcane_res` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `delay` `delay` int(11) unsigned NOT NULL default '1000',
CHANGE COLUMN `ammo_type` `ammo_type` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spellid_1` `spellid_1` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spelltrigger_1` `spelltrigger_1` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spellcharges_1` `spellcharges_1` int(11) NOT NULL default '0',
CHANGE COLUMN `spellcooldown_1` `spellcooldown_1` int(11) NOT NULL default '-1',
CHANGE COLUMN `spellcategory_1` `spellcategory_1` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spellcategorycooldown_1` `spellcategorycooldown_1` int(11) NOT NULL default '-1',
CHANGE COLUMN `spellid_2` `spellid_2` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spelltrigger_2` `spelltrigger_2` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spellcharges_2` `spellcharges_2` int(11) NOT NULL default '0',
CHANGE COLUMN `spellcooldown_2` `spellcooldown_2` int(11) NOT NULL default '-1',
CHANGE COLUMN `spellcategory_2` `spellcategory_2` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spellcategorycooldown_2` `spellcategorycooldown_2` int(11) NOT NULL default '-1',
CHANGE COLUMN `spellid_3` `spellid_3` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spelltrigger_3` `spelltrigger_3` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spellcharges_3` `spellcharges_3` int(11) NOT NULL default '0',
CHANGE COLUMN `spellcooldown_3` `spellcooldown_3` int(11) NOT NULL default '-1',
CHANGE COLUMN `spellcategory_3` `spellcategory_3` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spellcategorycooldown_3` `spellcategorycooldown_3` int(11) NOT NULL default '-1',
CHANGE COLUMN `spellid_4` `spellid_4` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spelltrigger_4` `spelltrigger_4` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spellcharges_4` `spellcharges_4` int(11) NOT NULL default '0',
CHANGE COLUMN `spellcooldown_4` `spellcooldown_4` int(11) NOT NULL default '-1',
CHANGE COLUMN `spellcategory_4` `spellcategory_4` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spellcategorycooldown_4` `spellcategorycooldown_4` int(11) NOT NULL default '-1',
CHANGE COLUMN `spellid_5` `spellid_5` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spelltrigger_5` `spelltrigger_5` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spellcharges_5` `spellcharges_5` int(11) NOT NULL default '0',
CHANGE COLUMN `spellcooldown_5` `spellcooldown_5` int(11) NOT NULL default '-1',
CHANGE COLUMN `spellcategory_5` `spellcategory_5` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `spellcategorycooldown_5` `spellcategorycooldown_5` int(11) NOT NULL default '-1',
CHANGE COLUMN `PageText` `PageText` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `LanguageID` `LanguageID` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `PageMaterial` `PageMaterial` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `startquest` `startquest` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `lockid` `lockid` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `Material` `Material` int(11) NOT NULL default '0',
CHANGE COLUMN `sheath` `sheath` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `RandomProperty` `RandomProperty` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `RandomSuffix` `RandomSuffix` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `block` `block` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `itemset` `itemset` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `MaxDurability` `MaxDurability` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `area` `area` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `Map` `Map` int(11) NOT NULL default '0',
CHANGE COLUMN `BagFamily` `BagFamily` int(11) NOT NULL default '0',
CHANGE COLUMN `TotemCategory` `TotemCategory` int(11) NOT NULL default '0',
CHANGE COLUMN `socketColor_1` `socketColor_1` int(11) NOT NULL default '0',
CHANGE COLUMN `socketContent_1` `socketContent_1` int(11) NOT NULL default '0',
CHANGE COLUMN `socketColor_2` `socketColor_2` int(11) NOT NULL default '0',
CHANGE COLUMN `socketContent_2` `socketContent_2` int(11) NOT NULL default '0',
CHANGE COLUMN `socketColor_3` `socketColor_3` int(11) NOT NULL default '0',
CHANGE COLUMN `socketContent_3` `socketContent_3` int(11) NOT NULL default '0',
CHANGE COLUMN `socketBonus` `socketBonus` int(11) NOT NULL default '0',
CHANGE COLUMN `GemProperties` `GemProperties` int(11) NOT NULL default '0',
CHANGE COLUMN `ExtendedCost` `ExtendedCost` int(11) NOT NULL default '0',
CHANGE COLUMN `CondExtendedCost` `CondExtendedCost` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `RequiredDisenchantSkill` `RequiredDisenchantSkill` int(11) NOT NULL default '-1',
CHANGE COLUMN `DisenchantID` `DisenchantID` int(11) unsigned NOT NULL default '0',
ADD INDEX `items_index` (`class`);
[Err] 1265 - Data truncated for column 'maxcount' at row 12017
[Err] ALTER TABLE `npc_vendor`
CHANGE COLUMN `entry` `entry` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `item` `item` int(11) unsigned NOT NULL default '0',
CHANGE COLUMN `maxcount` `maxcount` tinyint(3) unsigned NOT NULL default '0',
CHANGE COLUMN `incrtime` `incrtime` int(11) unsigned NOT NULL default '0';
[Err] 1054 - Unknown column 'CondExtendedCost' in 'field list'
[Err] -- Patch for rev 5443
UPDATE `item_template` SET `CondExtendedCost`=0 WHERE `ExtendedCost`=567;
[Err] 1054 - Unknown column 'CondExtendedCost' in 'field list'
[Err] UPDATE `item_template` SET `CondExtendedCost`=81 WHERE `entry` IN (33938,33941,33944,33947,33950,33953);
[Err] 1054 - Unknown column 'CondExtendedCost' in 'where clause'
[Err] UPDATE `item_template` SET `CondExtendedCost`=62 WHERE `ExtendedCost`=1664 AND `CondExtendedCost`=61;
[Err] 1054 - Unknown column 'CondExtendedCost' in 'field list'
[Err] -- Not accurate
UPDATE `item_template` SET `CondExtendedCost`=85 WHERE `entry` IN (33664,33666,33667,33672,33673,33675,33677,33678,33680,33683,33685,33686,33691,33692,33694,33695,33697,33698,33701,33702,33704,33706,33708,33709,33711,33713,33714,33718,33719,33721,33722,33724,33725,33728,33730,33731,33738,33740,33741,33745,33746,33748,33749,33751,33752,33758,33760,33761,33768,33769,33771);
[Err] 1054 - Unknown column 'CondExtendedCost' in 'field list'
[Err] UPDATE `item_template` SET `CondExtendedCost`=69 WHERE `entry` IN (33665,33671,33676,33681,33684,33690,33696,33700,33707,33712,33717,33723,33729,33736,33739,33744,33750,33759,33767,34033);
[Msg] Finished - Unsuccessfully
--------------------------------------------------