Vendors

[~ViVo~]

Everytime I just and add a vendor it gives me this error.

Query:
INSERT INTO `creature_names` VALUES ('60000', 'Nim\'tona', 'Dungeon I', '0', '0', '4', '0', '3', '0', '0', '94', '94', '1', '1', '1', '0', '0', '0')

Error occured at:2008-02-25 19:13:16
Line no.:83
Error Code: 1136 - Column count doesn't match value count at row 1

Also, I'm using the Sparten repack, Anyone know the Vendor id's? V3

:whythis:

[Xeneth]

You need to add or subtract a value, Count how many tables there are in the Creature names table and make sure the values add up

[~ViVo~]

I need a more Deedeedee tutorial.. I'm smart.. but not that smart.

[Xeneth]

>_>.

There's nothing to be smart about

Goto Creature_Names in your database

Look at the top, see the tabs? like "ID" "DISPLAY ID" et'cetra

Count those up

Now look at the sql code.

These are the values
VALUES ('60000', 'Nim''tona', 'Dungeon I', '0', '0', '4', '0', '3', '0', '0', '94', '94', '1', '1', '1', '0', '0', '0')

Count those

If the numbers match, You're gold. If they don't Add or subtract a value from the query

[~ViVo~]

thanks +rep

[Xeneth]

No problem, always glad to help.