I get this error when trying to execute this SQL. Note, I did change things in it, (add items),(Delete items).
REV: Spent 4-5 hours redoing this (Editing) and still giving me an error.
Code:[Err] 1136 - Column count doesn't match value count at row 60[Err] /*AIO SQL by Shawn of RaGEZONE*/
INSERT INTO `shops` (`shopid`,`npcid`) VALUES /*Start of inserting shop items*/
/*Common Shops*/
(6000,9270035), /*Hats*/
(6001,9270035), /*Earrings*/
(6002,9270035), /*Rings*/
(6003,9270035), /*Capes*/
(6004,9270035), /*Overalls*/
(6005,9270035), /*Gloves*/
(6006,9270035), /*Shields*/
(6007,9270035), /*Shoes*/
(6008,9270035), /*Maple Weapons*/
(6009,9270035), /*Level 0 Weapons*/
/*Warrior Shops*/
(6100,9270035), /*Hats*/
(6101,9270035), /*Tops*/
(6102,9270035), /*Bottoms*/
(6103,9270035), /*Overalls*/
(6104,9270035), /*Gloves*/
(6105,9270035), /*Shields*/
(6106,9270035), /*Shoes*/
(6107,9270035), /*1-Handed Axes*/
(6108,9270035), /*2-Handed Axes*/
(6109,9270035), /*1-Handed Blunt Weapons*/
(6110,9270035), /*2-Handed Blunt Weapons*/
(6111,9270035), /*1-Handed Swords*/
(6112,9270035), /*2-Handed Swords*/
(6113,9270035), /*Spears*/
(6114,9270035), /*PoleArms*/
/*Magician Shops*/
(6200,9270035), /*Hats*/
(6201,9270035), /*Overalls*/
(6202,9270035), /*Gloves*/
(6203,9270035), /*Shields*/
(6204,9270035), /*Shoes*/
(6205,9270035), /*Wands*/
(6206,9270035), /*Staffs*/
/*Archer Shops*/
(6300,9270035), /*Hats*/
(6301,9270035), /*Overalls*/
(6302,9270035), /*Gloves*/
(6303,9270035), /*Shoes*/
(6304,9270035), /*Bows*/
(6305,9270035), /*CrossBows*/
(6306,9270035), /*Arrows*/
/*Thief Shops*/
(6400,9270035), /*Hats*/
(6401,9270035), /*Tops*/
(6402,9270035), /*Bottoms*/
(6403,9270035), /*Overalls*/
(6404,9270035), /*Gloves*/
(6405,9270035), /*Shields*/
(6406,9270035), /*Shoes*/
(6407,9270035), /*Daggers*/
(6408,9270035), /*Claws*/
(6409,9270035), /*Throwing Stars*/
/*Pirate Shops*/
(6500,9270035), /*Hats*/
(6501,9270035), /*Overalls*/
(6502,9270035), /*Gloves*/
(6503,9270035), /*Shoes*/
(6504,9270035), /*Weapons*/
(6505,9270035), /*Bullets and Capsules*/
/*Messages, Accessories*/
(6600,9270035), /*All Accessories*/
(6601,9270035), /*Messages*/
/*ETC Shops*/
(6700,9270035), /*Boss pieces*/
(6701,9270035), /*Pots, Antidotes & Food*/
/*Common Hats*/
(6000,1002418,500000,0),
(6000,1002419,500000,1),
(6000,1002508,500000,2),
(6000,1002515,500000,3),
(6000,1002516,500000,4),
(6000,1002517,500000,5),
(6000,1002518,500000,6),
(6000,1002553,500000,7),
(6000,1002603,500000,8),
(6000,1002601,500000,9),
(6000,1002600,500000,10),
(6000,1002602,500000,11),
(6000,1002662,500000,12),
(6000,1002424,500000,13),
(6000,1002425,500000,14),
(6000,1002509,500000,15),
(6000,1002080,500000,16),
(6000,1002081,500000,17),
(6000,1002082,500000,18),
(6000,1002083,500000,19),
(6000,1002391,500000,20),
(6000,1002392,500000,21),
(6000,1002393,500000,22),
(6000,1002394,500000,23),
(6000,1002395,500000,24),
(6000,1002452,500000,25),
(6000,1002453,500000,26),
(6000,1002492,500000,27),
(6000,1002584,500000,28),
(6000,1002585,500000,29),
(6000,1002586,500000,30),
(6000,1002587,500000,31),
(6000,1002026,500000,32),
(6000,1002089,500000,33),
(6000,1002090,500000,34),
(6000,1002441,500000,35),
(6000,1002455,500000,36),
(6000,1002510,500000,36),
(6000,1002675,500000,37),
(6000,1002677,500000,38),
(6000,1002006,500000,39),
(6000,1002390,500000,40),
(6000,1002430,500000,41),
(6000,1002676,500000,42),
(6000,1002471,500000,43),
(6000,1002483,500000,44),
(6000,1002511,500000,45),
(6000,1002571,500000,46),
(6000,1002572,500000,47),
(6000,1002573,500000,48),
(6000,1002574,500000,49),
(6000,1002357,500000,50),
/*Earrings*/
(6001,1032033,500000,0),
(6001,1032047,500000,1),
(6001,1032003,500000,2),
(6001,1032046,500000,3),
(6001,1032000,500000,4),
(6001,1032009,500000,5),
(6001,1032040,500000,6),
(6001,1032004,500000,7),
(6001,1032005,500000,8),
(6001,1032025,500000,9),
(6001,1032032,500000,10),
(6001,1032006,500000,11),
(6001,1032007,500000,12),
(6001,1032010,500000,13),
(6001,1032028,500000,14),
(6001,1032002,500000,15),
(6001,1032008,500000,16),
[Msg] Finished - Unsuccessfully
-------------------------------------------------
