SQL Error When Registering

[RayChill]

This error appears when registration is set to user or admin after the new member clicks submit to join the forum.

Error inserting user group, group count

 

DEBUG MODE

 

SQL Error : 1064 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 ' 2235, 0)' at line 2

 

INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (, 2235, 0)

 

Line : 1080

File : usercp_register.php

 

This is the line listed:

 

    message_die(GENERAL_ERROR, 'Error inserting user group, group count', '', __LINE__, __FILE__, $sql);

[Silverado_NL]

INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (, 2235, 0)

i think the line needs to be

INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES ("", 2235, 0)

because in the Values clause the 1st value is not set it cant disappear.

the query needs to see it has nog value

[corbin]

If the field is auto incrementing, you do not need to insert anything for it at all if I remember...  At least which ever version of MSSQL I last used that wasn't needed lol.