Vendor SQL Scripting

[Karyuudo]

Kay, ive been working on this all day, and It's getting to the point that I'm gonna scream... I keep getting the Error with Scyther's Blizzlike Repack V4.0 (( Awesome Coding btw, I have yet to find one bug )) of Error Code: 1136 - Column count doesn't match value count at row 1... and I just dont get it, even though Ive counted the columns numerous timed, and there is 50 Based on the Vendors.sql so... Anyone think you can find the problem with this vendor table?:
Before I post it, here is the Column table for the hell of it...

     TABLE `creature_proto` (
  `entry` int(30) unsigned NOT NULL default '0',
  `minlevel` int(30) unsigned NOT NULL,
  `maxlevel` int(30) unsigned NOT NULL,
  `faction` int(30) unsigned NOT NULL default '0',
  `minhealth` int(30) unsigned NOT NULL,
  `maxhealth` int(30) unsigned NOT NULL,
  `mana` int(30) unsigned NOT NULL default '0',
  `scale` float NOT NULL default '0',
  `npcflags` int(30) unsigned NOT NULL default '0',
  `attacktime` int(30) unsigned NOT NULL default '0',
  `attacktype` int(4) NOT NULL default '0',
  `mindamage` float NOT NULL default '0',
  `maxdamage` float NOT NULL default '0',
  `rangedattacktime` int(30) unsigned NOT NULL default '0',
  `rangedmindamage` float unsigned NOT NULL default '0',
  `rangedmaxdamage` float unsigned NOT NULL default '0',
  `mountdisplayid` int(30) unsigned NOT NULL default '0',
  `equipmodel1` int(30) unsigned NOT NULL default '0',
  `equipinfo1` int(30) unsigned NOT NULL default '0',
  `equipslot1` int(30) unsigned NOT NULL default '0',
  `equipmodel2` int(30) unsigned NOT NULL default '0',
  `equipinfo2` int(30) unsigned NOT NULL default '0',
  `equipslot2` int(30) unsigned NOT NULL default '0',
  `equipmodel3` int(30) unsigned NOT NULL default '0',
  `equipinfo3` int(30) unsigned NOT NULL default '0',
  `equipslot3` int(30) unsigned NOT NULL default '0',
  `respawntime` int(30) unsigned NOT NULL default '0',
  `armor` int(30) unsigned NOT NULL default '0',
  `resistance1` int(30) unsigned NOT NULL default '0',
  `resistance2` int(30) unsigned NOT NULL default '0',
  `resistance3` int(30) unsigned NOT NULL default '0',
  `resistance4` int(30) unsigned NOT NULL default '0',
  `resistance5` int(30) unsigned NOT NULL default '0',
  `resistance6` int(30) unsigned NOT NULL default '0',
  `combat_reach` float NOT NULL default '0',
  `bounding_radius` float NOT NULL default '0',
  `auras` longtext NOT NULL,
  `boss` int(11) unsigned NOT NULL default '0',
  `money` int(30) NOT NULL default '0',
  `invisibility_type` int(30) unsigned NOT NULL,
  `death_state` int(30) unsigned NOT NULL,
  `walk_speed` float NOT NULL default '2.5',
  `run_speed` float NOT NULL default '8',
  `fly_speed` float NOT NULL default '14',
  `extra_a9_flags` int(30) NOT NULL default '0',
  `spell1` int(30) NOT NULL default '0',
  `spell2` int(30) NOT NULL default '0',
  `spell3` int(30) NOT NULL default '0',
  `spell4` int(30) NOT NULL default '0',
  `spell_flags` int(30) NOT NULL default '0',

Vendor in Question:

INSERT INTO `creature_proto` VALUES (646260, 255, 255, 35, 9999999, 9999999, 999999, 1, 128, 100, 0, 999999, 999999, 100, 999999, 999999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 400000, 0, 0, 0, 0, 0, 0, 1, 1, '0', 1, 0, 0, 0, 80, 120, 250, 0, 0, 0, 0, 0, 0);

INSERT INTO `creature_names` VALUES (646260, "Example Vendor", "Example Vendor",'', 0, 7, 0, 0, 0, 0, 100, 0, 0, 0, 1, 1, 0, 0);

[Power of Illuminati]

INSERT INTO creature_names (entry, name, subname, info_str, Flags1, type, family, rank, male_displayid, female_displayid, male_displayid2, female_displayid2, civilian, leader) VALUES ('646260','Example Vendor','Example Vendor','','4224','7','0','0','128','0','0','0','0','0')

INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipmodel2, equipmodel3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, auras, boss, money, invisibility_type, death_state, walk_speed, run_speed, fly_speed) VALUES ('646260','255','255','35','99999','99999','999999','4224','1500','10000','1000','0','0','0','0','0','0','0','36000','0','0','0','0','0','0','0','1','0','0','0','0','0','2.5','8','14')

Just made something, it's made in ADE 1.2.2 and it should work, your problem was that the tool you used, has a old structure, or your numbers were wrong.

[Karyuudo]

I Wrote that Script, Cant trust Programs/Wow-V cause it never seems to get it right, thanks, ill try Executing this File now.
Nope Didnt Work, Same Error As Last time.
Error occured at:2008-08-03 22:59:24

Line no.:1
Error Code: 1136 - Column count doesn't match value count at row 1 Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipmodel2, equipmodel3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, auras, boss, money, invisibility_type, death_state, walk_speed, run_speed, fly_speed) VALUES ('646260','255','255','35','99999','99999','999999','4224','1500','10000','1000','0','0','0','0','0','0','0','36000','0','0','0','0','0','0','0','1','0','0','0','0','0','2.5','8','14')

I'm getting so Frustrated, Can't you Help Scyther? lol Just for a reason im trying to enter a Vendor into this, im making a Raiding realm.

[Power of Illuminati]

Do the entire NPC from the database, I hope you know how =P Then add the correct flag only.

[Ickybad]

I'd be more then happy to remake this npc for you .

[Karyuudo]

If you would I would love you so much, Im already loving your Repack...do you accept donations I'd so donate to you if I could lmao your awesome.


Edit: Well after doing alot of Number Crunching I finally looked in my creature_proto and creature_names and I was shocked... the Vendors were already in the Database, the error Iv'e been getting was from the vendors tables, and it was because I was missing one value... I feel Extremely stupid now... anyway, for the Effort you guys put into helping me, I give Ye a +Rep Thanks!