I want to add this to the Wiki

[Moonracer]

--------------------------------------------------------------------------
when using:

INSERT INTO accounts VALUES (1, 'Admin', '', 0, 'mini', 250, , 0, 0, 0, 0, '192.168.0.22')

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0, 0, 0, 0, 192.168.0.22)' at line 1 1064
--------------------------------------------------------------------------

Worktruck, I got this same error. You may have already fixed this, but I'm going to put in what worked for me in case anyone else has this issue. To fix this error I used:

INSERT INTO account VALUES (1, 'Admin', '', 0, 'mini', 250, '', 0, 0, 0, 0, '192.168.0.22');

I needed account instead of accounts (my db was using this word). I needed to send an empty string in the seventh field (did I leave strict mode on?). I also put in a semicolon at the end of the command.

I hope this helps anyone out there that's stuck.

Moonracer

[GeorgeS]

Those are Two Single quotes put together - for those that wonder what the " is. It looks like (dbl quote) '' or (two songle quote) " - similar but wrong.Mysql can use either for strings, but they must be two of each to encapsulate a string. Numeric variables can use 2 single quotes

Just FYI
GeorgeS

The MySQL King