MySQL v4.0.18: ERROR 1136
 

I couldn't find any specific posts with this error, so i'll see if you guys can help me out here.

After following the guide instruction, i successfully sourced MW055_alpha_02 and doorupdate... into the eq database.

(this is inside the c:/mysql/bin mysql -u root mysql)
(user/pass the same)
i type INSERT INTO acount(id,name,charname,packencrypt, sharedplat,password, status, lsaccount_id, gmspeed, revoked) VALUES (1,'mysqlpass',",",0,'mysqluser',250,NULL,0,0);

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

DB.ini:
[Database]
host=localhost
user=user
password=pass
database=eq
compression=off

It looks like there's a problem with the account table in your db.

What happens when you "describe account;"?

Does it look like all the data is there?

I am guessing that your problem is that you have double quotes where you should have two single quotes next two each other, i.e. where you have ",", that should be <single quote><single quote><comma><single quote><single quote> (Where <single quote> is the character below the @ sign on an English keyboard).

Also, the id and password should be the account id and password you want to use, not your mysql userid and password.

Wow, I didn't even think of that. :oops:

Yes, those double quotes should be single quites with nothing between them.

thank you, the (") quote instead of using single quote marks was my problem

It all works now :D

I am also getting this same error, but I get it AFTER sourcing newdumpeditems.sql.
Any ideas? I generally need your advice in simple terms as I am a hack, thanks in advance.