Please Help! SQL Error


#1

This error appears when registration is set to user or admin after the new member clicks submit to join the forum.
Code:
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:

Code:
message_die(GENERAL_ERROR, ‘Error inserting user group, group count’, ‘’, LINE, FILE, $sql);


#2

Well this is more of a question for the forum at http://www.phpbb.com/phpBB/ However, just looking at the error there is a problem with the SQL statement.

[php]INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (, 2235, 0) [/php]

There is no value for the group_id. This field is not allowed to be null. On my installation of phpBB, however there is a default value of 0 set in the table configuration.

Perhaps you need to either pass a 0 or set the default to 0 in the database. Based on the error message though, I think it’s because there is no value for the first item.