Help [Error]

[Alex]

Help I am gettin this error 1136 - Column count doesn't match value count at row 1 when im trying to load a SQL into creature_template





______________________________________________________________________________________ SQL CODE


INSERT INTO `creature_template` VALUES (999900, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'T13 Normal Pve Gear', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999901, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'Pve Weapons 406 - 416', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999902, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'T13 Heroic Pve Gear', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999903, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'T12.5 Pve OffSet', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999904, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'S11 PvP Weapons', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999905, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'S11 PvP Gear', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999906, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'T12 Heroic Pve Gear', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999907, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'Pve Weapons 372 - 378', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999908, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'T12 Pve OffSet', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999909, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'Legendary Weapons', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999910, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'S9 PvP Gear', 'Vendor', NULL, 0, 83, 83, 2, 0, 35, 35, 129, 1, 1.14286, 1, 0, 950, 1297, 0, 1530, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1200, 1300, 190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999911, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'S9 PvP Weapons', 'Vendor', NULL, 0, 83, 83, 2, 0, 35, 35, 129, 1, 1.14286, 1, 0, 950, 1297, 0, 1530, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1200, 1300, 190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999912, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'Gems', 'Vendor', NULL, 0, 83, 83, 2, 0, 35, 35, 129, 1, 1.14286, 1, 0, 950, 1297, 0, 1530, 1, 0, 0, 1, 0, 2048, 0, 0, 0, 0, 0, 1200, 1300, 190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999913, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'Enchants', 'Vendor', NULL, 0, 83, 83, 2, 0, 35, 35, 129, 1, 1.14286, 1, 0, 950, 1297, 0, 1530, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1200, 1300, 190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999914, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'T11 Pve OffSet', 'Vendor', NULL, 0, 83, 83, 2, 0, 35, 35, 129, 1, 1.14286, 1, 0, 950, 1297, 0, 1530, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1200, 1300, 190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999915, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'T11 Pve Gear', 'Vendor', NULL, 0, 83, 83, 2, 0, 35, 35, 129, 1, 1.14286, 1, 0, 950, 1297, 0, 1530, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1200, 1300, 190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999916, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'Misc', 'Vendor', NULL, 0, 83, 83, 2, 0, 35, 35, 129, 1, 1.14286, 1, 0, 950, 1297, 0, 1530, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1200, 1300, 190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999917, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'Pve Weapons 359 - 365', 'Vendor', NULL, 0, 83, 83, 2, 0, 35, 35, 129, 1, 1.14286, 1, 0, 950, 1297, 0, 1530, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1200, 1300, 190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999918, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'S10 PvP Gear', 'Vendor', NULL, 0, 83, 83, 2, 0, 35, 35, 129, 1, 1.14286, 1, 0, 950, 1297, 0, 1530, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1200, 1300, 190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999919, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'S10 PvP Weapons', 'Vendor', NULL, 0, 83, 83, 2, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999922, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'T12 Normal Pve Gear', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999923, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'Pve Weapons 397 - 403', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999924, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'Pve Weapons 384 - 391', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999926, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'T13 Pve OffSet', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999927, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'Mounts', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999928, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'Rare Mounts Rares', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
INSERT INTO `creature_template` VALUES (999929, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'Prestige Mounts', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);

 

[ExO]

I apologize for the slow response.
This may be because, it was designed to EmuCoach creature_template and you use TrinityCore, so you would have to rewrite the SQL so it has as many columns as the TC one.

 

[Alex]

And how do i do that?

 

[ExO]

You would do that by comparing TC creature template columns with these ones and making sure that this data (for example):

999929, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'Prestige Mounts', 'Vendor', NULL, 0, 83, 83, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1

Matches the one in your creature_template from TC.
As in,
Lets say there's 84 columns in emucoach (I'm not sure, you gotta count these), then there should be 84 in your TC creature_Template as well, well either that, or you should rewrite it to the amount of columns you have, because basically the error you get:

Column count doesn't match value count at row 1 when im trying to load a SQL into creature_template
Means that the column count doesn't match.
I hope I'm not too confusing, I'm ill and tired so yeah.

 

[Marko]

it takes some time to do this for all vendors, thus it is more faster to simply find another working sql for vendors. Or even create ur own vendors, even that is faster, at least for me

 

[michaeltoole92]

Check on here for vendors I made some compatible a while back