Look at your query:
INSERT INTO user (userid,usergroupid,........) VALUES (NULL,'2',....)
With this query you command MYSQL to insert to user table:
for userid field VALUE null,
for usergroupid field VALUE 2
etc.
etc.
Now count the fields between the first ()s. (They are your fields) and then count the values between second ()s, (They are your values to insert into these fields), they simply dont match. You either miss a field name or value.
If you are applying a hack, this query is wrong so it means that you didnt apply it correctly. If you formed the query by yourself it either means you added a field to an existing query but you didnt add its value OR you added a value without mentioning its field.
You have to check them one by one and see which value or field is missing or extra. Your table structure has nothing to do with this error.
|