Please Help! SQL Error

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


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);

Well this is more of a question for the forum at 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.

Sponsor our Newsletter | Privacy Policy | Terms of Service