Errors

[y2kss66]

Query:
INSERT INTO creature_proto
(entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state, walk_speed, run_speed, fly_speed, extra_a9_flags)
VALUES
(40001, 70, 70, 35, 12000, 12000, 0, 1, 3, 2800, 100, 200, 2800, 100, 200, 0, 31543, 0, 0, 0, 0, 0, 10178, 0, 0, 360000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "0", 0, 0, 0, 0, "2", "5", 8, 14, 0)

Error occured at:2008-03-19 19:30:10
Line no.:11958
Error Code: 1136 - Column count doesn't match value count at row 1


How could I fix this I am using Spartansp DB Repack V4.
ascent version 3940.
trying too update an old file to work with the new DB tpes thanks for all help.

[TheSpidey]

You need to find which columns changed since that rev and mod the query.

[y2kss66]

thanks trying that right now and importing fresh DB to test with!

[y2kss66]

Same error is coming back here is the file that is buggy could somebody update it for me or tell me how to. Thanks ahead of time!

INSERT INTO creature_proto
(entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, attacktype, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state, walk_speed, run_speed, fly_speed, extra_a9_flags)
VALUES
(40001, 70, 70, 35, 12000, 12000, 0, 1, 3, 2800, 0, 100, 200, 2800, 100, 200, 0, 31543, 0, 0, 0, 0, 0, 10178, 0, 0, 360000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "0", 0, 0, 0, 0, "2", "5", 8, 14, 0);

INSERT INTO creature_proto
(entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, attacktype, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state, walk_speed, run_speed, fly_speed, extra_a9_flags)
VALUES
(40002, 70, 70, 35, 12000, 12000, 0, 1, 3, 2000, 0, 633, 885, 0, 0, 0, 0, 20110, 0, 0, 2594, 0, 0, 0, 0, 0, 360000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "0", 0, 0, 0, 0, "2", "5", 8, 14, 0);

INSERT INTO creature_spawns
(entry, map, position_x, position_y, position_z, orientation, movetype, displayid, faction, flags, bytes, bytes2, emote_state, npc_respawn_link, channel_spell, channel_target_sqlid, channel_target_sqlid_creature)
VALUES
(40001, 1, "-8787,51", "-1486,22", "8,87739", "4,51369", 0, 16689, 35, 0, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO creature_spawns
(entry, map, position_x, position_y, position_z, orientation, movetype, displayid, faction, flags, bytes, bytes2, emote_state, npc_respawn_link, channel_spell, channel_target_sqlid, channel_target_sqlid_creature)
VALUES
(40002, 1, "-9060,87", "-1058,99", "131,408", "5,32321", 0, 16182, 35, 0, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO creature_quest_finisher
(id, quest)
VALUES
(40002, 40001);

INSERT INTO creature_quest_starter
(id, quest)
VALUES
(40001, 40001);

[y2kss66]

*BUMP*
LOL I really need help!

[~ViVo~]

If you uploaded a new DB in then your sql file is bad.
Try this.. tell me if it works, if it does you need to use this form of SQL.
Coded this quick so, its not an item you'll want to use.

INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES (89009,4,1,-1,"Vivowow Donators Helmet","Vivowow Donators Helmet","Vivowow Donators Helmet","Vivowow Donators Helmet",42115,4,0,0000,0000,1,-1,-1,70,70,0,0,0,0,0,0,0,1,1,0, 3,47, 7,46, 6,34, 4,48, 35,44, 0,0, 0,0, 0,0, 0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1900,0,0,0,0,10,0,0,0,0,7599,1,0,0,0,0,14056,1,0,0,0,0,35893,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Thanks for Donating!",0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,1,0,1,0,1,0,2869,0,0,0,0);

[y2kss66]

Hey my DB got screwed up again so I am re-installing It and I will test your file.

[~ViVo~]

Lol, don't even.. I wasn't paying any attention.. I gave you an item file.. your problem is creature_proto.

[y2kss66]

do you know how to fix it?
my file that is?

[2dgreengiant]

what did u use to create that sql file?

[y2kss66]

I found it on another site and loved the quest Idea but it was bugged and so I fixed one of the errors but cannot figure this one out!

[y2kss66]

*bump*

please need help!