Problems with executing

[Nadromar]

This is possibly the simpelest thing ever, i hope so anyway,
Whenever I try to execute an sql file in the DB, i get this error Column count doesn't match value count at row 1

I have the latest rev of arcemu and the sql is designed for arcemu so thats not it

[Nadromar]

Never mind, I figured the problem,
the thing i want to execute is probably based on an older version of arcemu, basically i have to add , '0', '0', '0', '0', '0', '0' to every object and done

[Sonic Waffle]

It means that the script is trying to insert less column values into the row than there columns. E.g.:

INSERT INTO accounts (acct, username, password, level) VALUES('12341', 'admin')

This is wrong, you need to supply ALL the columns you are going to use, so the correct query would be:

INSERT INTO accounts (acct, username, password, level) VALUES('12341', 'admin', 'password', 'az')

Edit: Saw you just posted the answer. >.<
But I have the reason!

[Nadromar]

xD Thanks anyways, youll get a repcookie for trying to help

EDIT: Given out too much rep today << Ill give it tomorrow :d

[Reflection]

Whenever I get that error I go to the table I'm inserting into, open it and count the columns. I remember that number and switch to the file to execute. There I also count them.

If you get this error the column counts don't match. If there are too many columns in the file I want to execute I check to see if there's any update for my database, if there's too few I copy the last ");", go into the replace function of notepad (ctrl+h), paste the copied items to "Find What" and basically add as many 0's I need. So if the executed files need 3 more 0's I type in Replace What: '0', '0', '0');

What replace does is it looks for what you said it should find and replaces it with the second line throughout the entire document.

It may not be the easiest, quickest or most flawless way, but it's my way and I can live with it

Hope I could help, Nightfoxx.