Error with vendors.

[jokerjokes]

Ok so im getting this error when i finished creating my vendors.

Query:
INSERT INTO creature_names
 (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, female_displayid, unknown_int1, unknown_int2, unknown_float1, unknown_float2, Civilian, Leader)
 VALUES
 (7000001, Crusher, "", 0, 0, 7, 0, 0, 0, null, 10922, 0, 0, 0, 1, 1, 1, null)

Error occured at:2007-11-25 19:46:46
Line no.:4
Error Code: 1136 - Column count doesn't match value count at row 1

And here are my creatures.

INSERT INTO creature_names
(entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, female_displayid, unknown_int1, unknown_int2, unknown_float1, unknown_float2, Civilian, Leader)
VALUES
(7000001, Crusher, "", 0, 0, 7, 0, 0, 0, null, 10922, 0, 0, 0, 1, 1, 1, null);

Im using ncdb heh any help please lol. starting to tick me off a bit lol

[Rouslan]

VENDORS FOR EVERYONE!!!!! and Zul ` Aman Items - 29 Minutes Ago
ALL FILES CAN BE DOWNLOADED ON MY SERVER WEBSITE UNDER DOWNLOADS SECTION
http://cosanostra.guildplex.com/

HI everyone,

I was working on these vendors for 3 days and i finally made a pack for you guys that wants to have nice Sexy Blood Elf Models selling All in game :wave:

As well in this thread i added Zul` Alaman items. these are not 100% complete... about 94% of Zul` aman drops .... but it still crazy items and you will love it trust me,,

OK about Zul`Aman file. its a Rar format so unzip it to any directory, open your Sqlyog or Navicat (i prefer navicat).. open you databse click on WORLD , then right click it with your mouse and press ~Execute Bach File~ , find your directory and execute 1 by 1 all the files you have.

That`s right there added your Zul`Aman Items. :banned:


Now Vendors........

Same as previous guide.... Unzip Vendor.zip to any directory.
open your Sqlyog or Navicat (i prefer navicat).. open you databse click on WORLD , then right click it with your mouse and press ~Execute Bach File~ , find your directory and execute 1 by 1 all the files you have. You should have 5 SQL Files.... There is a possibility you will recive Unsuccessful error while executing Vendors.sql (but not to worry vendors added ... )

.npc Spawn 50000 and up

-------------------------------------------------------------------
Zul`Aman Items



Vendors



Here you go you all set...

As well check out my other thread about how to Spawn Portals and not lose them. (that guide needs no Sql files no mod scripts.. simple command technicality )

Explanation About Portals:

When you spawn portals you use .gob spawn (id) command
however. In order to save it to your Database input 1 after the code. ::

So ....

.GOB SPAWN 176499 - SUMMONS ORGRIMMAR PORTAL.. HOWEVER WHEN YOU RESTART IT WILL DISAPEAR ...

BUT IF YOU DO

.GOB SPAWN 176499 1 - THAT WILL ALWAYS KEEP IT IN GAME...


PORTAL IDS

stormwind - 176296
darnassus - 176498
exodar - 183321
ironforge - 176497
orgrimmar - 176499
thunderbluff - 176500
undercity - 176501
silvermoon - 182352
Shattrath - 183384


PS: I AM RUSSIAN AND I AM SORRY FOR ANY TYPOS.

HOWEVER THIS GUIDE WILL GET YOU SET UP... SO I HOPE YOU FORGIVE ME

ENJOY!

[jokerjokes]

Ok so mis wrote everything, Lol not vendor but creature. and for gods sake i know how to make a vendor. i jsut want to know whats the problem when i execute this dam batch.

[latruwski]

(7000001, Crusher, "", 0, 0, 7, 0, 0, 0, null, 10922, 0, 0, 0, 1, 1, 1, null)
means your querie does not have as much columns as your table in your DB.... "Column count doesn't match value count at row 1"
18 values... means 18 columns... check that... if not matching then add a value or delete if needed

grtz

[Illidan1]

What Latruwski Said lol , beat me to it