SQL help needed.

[Slippers]

Ok, so this kind of post might of been done before. If so, please post a link of this.

So I downloaded Illidan's Mall, but I'm having problems with the SQL. Everything worked fine untill I reached the vendors, here is the code:

 
INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50001, "Armor", "Dungeon II", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50002, "Armor", "Dungeon III", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50003, "Armor", "Raid Tier I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50004, "Armor", "Raid Tier II", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50005, "Armor", "Raid Tier III", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50006, "Armor", "Raid Tier IV", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50007, "Armor", "Raid Tier V", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50008, "Armor", "Raid Tier VI", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50009, "Armor", "Wrist", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50010, "Armor", "Waist", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50011, "Armor", "Feet", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50012, "Armor", "Shield", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50015, "Weapon", "Level 50+", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50016, "Weapon", "Level 60+", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50017, "Weapon", "Level 65+", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50018, "Weapon", "Level 75+", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50019, "Weapon", "Level 100+", 0, 4, 0, 3, 0, 0, 20023, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50020, "Armor", "Necklace", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50021, "Armor", "Rings", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50022, "Armor", "Trinket", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50023, "Armor", "Cloak", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50024, "Armor", "Shirt", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50025, "Armor", "Tabard", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50026, "Armor", "Miscellaneous", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50028, "Armor", "Off-Hands", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50029, "Armor", "Libram/Idol/Totem", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50030, "Arena", "Season I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50031, "Arena", "Season I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50032, "Arena", "Season I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50033, "Arena", "Season II", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50034, "Arena", "Season II", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50035, "Arena", "Season II", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50040, "Misc", "Gemstone I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50041, "Misc", "Gemstone II", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50042, "Misc", "Mount I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50043, "Misc", "Mount II", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50044, "Misc", "Projectile", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50045, "Misc", "Container", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50047, "Misc", "Enchantment", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50048, "Misc", "Key", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50049, "Misc", "Currency", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50050, "Recipe", "Book A-Z", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50051, "Recipe", "Leather A-F", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50052, "Recipe", "Leather G-R", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50053, "Recipe", "Leather S-Z", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50054, "Recipe", "Tailor A-G", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50055, "Recipe", "Tailor H-Z", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50056, "Recipe", "Engineer A-Z", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50057, "Recipe", "Blacksmith A-F", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50058, "Recipe", "Blacksmith G-R", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50059, "Recipe", "Blacksmith S-Z", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50060, "Recipe", "Cooking A-Z", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50061, "Recipe", "Alchemy A-Z", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50062, "Recipe", "Enchant A-G", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50063, "Recipe", "Enchant H-Z", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50064, "Recipe", "Jeweler A-K", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50065, "Recipe", "Jeweler L-Z", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50066, "Reagent", "Leather I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50067, "Reagent", "Leather II", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50068, "Reagent", "Tailor I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50069, "Reagent", "Tailor II", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50070, "Reagent", "Engineer I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50071, "Reagent", "Engineer II", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50072, "Reagent", "Blacksmith I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50073, "Reagent", "Blacksmith II", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50074, "Reagent", "Cooking", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50075, "Reagent", "Alchemy", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50076, "Reagent", "Enchant", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50077, "Reagent", "Jeweler", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
INSERT INTO creature_names VALUES (50078, "Reagent", "Miscellaneous", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);

So I extract batch in Navicat and it gives me this error:

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
[Msg] Finished - Unsuccessfully

It's the equivalent to this in SQLyog:

Error Code : 1136
Column count doesn't match value count at row 1

If you can help, that would be great.

Thanks,

Slippers.

[quickx]

your table has a different structure than the vendors...easiest thing to do would be add them to the database by hand

[Slippers]

I'm kind of new at this, how would I do so?

[777devil777]

You could manually convert it to your rev by deleting / adding 0s although it'll be a bit buggy (See the colums in your DB) or update your revision.

[*TraPStaR*]

look in you data base and count the rows you have or columns i don't know what you would call them but i call them rows its the different things for each number like one will be id then name then sub name like that look at the rows and count

(50078, "Reagent", "Miscellaneous", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);

either 1 its to long or 2 its to short just match up the rows pretty much

[*TraPStaR*]

look in you data base and count the rows you have or columns i don't know what you would call them but i call them rows its the different things for each number like one will be id then name then sub name like that look at the rows and count

(50078, "Reagent", "Miscellaneous", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);

either one its to long or 2 its to short just match up the rows pretty much

if you still cant figure it out tell me your db and ill update them if i can

[latruwski]

the querie just has more columns then you DB.. that means you probably have an old DB? or too new....
give us your DB info and we will see

grtz

[Slippers]

I just made my DB, so it's really new.

[Illidan1]

Slippers, tell us what Repack you useing, what Revision, and your SQL Format
The SQL Format is like

Id, Entry, name, subname, flags Etc Etc

Open your Database, and then go into "creature_names"
And tell us what the tables are, do the same with "Creature_proto"
And i will remake i for you