Errors Update 575_mangos_FIX_(10803).sql

[Cartman87]

At patching in my database there were 165 Erros with the Ignore Lines like
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT IGNORE INTO `creature_template` VALUES ('45320', '0', '0', '0', '0', '0', '28127', '0', '0', '0', 'Blood Guard Kang', '', '', '0', '60', '60', '48832', '48832', '0', '0', '3750', '35', '35', '0', '1', '1.14286', '1', '1', '128', '192', '0', '48', '2', '2000', '2000', '1', '0', '0', '0', '0', '0', '0', '0', '102', '154', '38', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '16', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '');

I had no such erros about 1 Year ago using YTDB

Has anybody this Problem , too?

[schmoozerd]

I would be carefull anyways with this update, there is much 4.x stuff polluting a 3.35 database (which might result in console errros and perhaps sometimes in expected behaviour)

[YuruY]

I would be carefull anyways with this update, there is much 4.x stuff polluting a 3.35 database (which might result in console errros and perhaps sometimes in expected behaviour)

And here it?
Data on them is for a long time in DBC-3.3.5a. :cool:

At anybody another isn't present problems with pouring, the structure of the data didn't change.

[YuruY]

At it in base the quantity of columns differs simply from official Mangos.

[YuruY]

Cartman87
Replace:
INSERT IGNORE INTO `creature_template` VALUES ('45320', '0', '0', '0', '0', '0', '28127', '0', '0', '0', 'Blood Guard Kang', '', '', '0', '60', '60', '48832', '48832', '0', '0', '3750', '35', '35', '0', '1', '1.14286', '1', '1', '128', '192', '0', '48', '2', '2000', '2000', '1', '0', '0', '0', '0', '0', '0', '0', '102', '154', '38', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '16', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '');
On:
INSERT IGNORE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES ('45320', '0', '0', '0', '0', '0', '28127', '0', '0', '0', 'Blood Guard Kang', '', '', '0', '60', '60', '48832', '48832', '0', '0', '3750', '35', '35', '0', '1', '1.14286', '1', '1', '128', '192', '0', '48', '2', '2000', '2000', '1', '0', '0', '0', '0', '0', '0', '0', '102', '154', '38', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '16', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', ''); ;)

[Cartman87]

Everey Line change by hand ? then 1 can take a day holyday for a failed update?

[NeatElves]

`creature_template` VALUES ('45046', '0', '0', '0', '0', '0', '28127', '0', '0', '0', 'Garrosh Hellscream', 'Overlord of the Warsong Offensive', '', '0', '1' , '1' , '697250', '697250', '0', '0', '17' , '35', '35', '0', '1', '1.14286', '1', '3', '1' , '1' , '0', '1' , '2', '2000', '2000', '1', '0', '0', '0', '0', '0', '0', '0', '1' , '1' , '1' , '7', '76', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '50', '20', '0', '0', '0', '0', '0', '0', '0', '144', '1', '0', '0', '0', '0', '');
`creature_template` VALUES ('45320', '0', '0', '0', '0', '0', '28127', '0', '0', '0', 'Blood Guard Kang' , '' , '', '0', '60', '60', '48832' , '48832' , '0', '0', '3750', '35', '35', '0', '1', '1.14286', '1', '1', '128', '192', '0', '48', '2', '2000', '2000', '1', '0', '0', '0', '0', '0', '0', '0', '102', '154', '38', '7', '0' , '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '16', '1' , '0', '0', '0', '0', '0', '0', '0', '0' , '1', '0', '0', '0', '0', '');

There are no differences...

[YuruY]

Итиода нафик.

Шмозерд тоже придурок, кинуться на такое. :(