[Archive] Help [Error]
[Archive] Help [Error]
Original source
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);
rektbyfaith
11-04-2025, 05:17 PM #1Archived author: Alex • Posted: 2025-11-04T18:17:05.591343
Original source
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);
Original source
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.
rektbyfaith
11-04-2025, 05:17 PM #2Archived author: Alex • Posted: 2025-11-04T18:17:05.591343
Original source
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.
Original source
And how do i do that?
rektbyfaith
11-04-2025, 05:17 PM #3Archived author: Alex • Posted: 2025-11-04T18:17:05.591343
Original source
And how do i do that?
Original source
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.
rektbyfaith
11-04-2025, 05:17 PM #4Archived author: Alex • Posted: 2025-11-04T18:17:05.591343
Original source
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.
Original source
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
![[Image: 1f600.png]](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png)
rektbyfaith
11-04-2025, 05:17 PM #5Archived author: Alex • Posted: 2025-11-04T18:17:05.591343
Original source
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
Original source
Check on here for vendors I made some compatible a while back
rektbyfaith
11-04-2025, 05:17 PM #6Archived author: Alex • Posted: 2025-11-04T18:17:05.591343
Original source
Check on here for vendors I made some compatible a while back
1 Guest(s)
1 Guest(s)