I searched through this forum to fix the "Could not insert data into groups table" when a new user tries to register, a problem I've been having for a couple of weeks now.
I've narrowed down the problem a bit more.
The thing that happens each time a new member tries to register is this: in the group table, the new user is assigned the following grou_id number: 8388607 . This doesn't make much sense, because the highest number before that is 187. Once that number (8388607) has been added to the group table, no one else can register and the error message "Could not insert data into groups table" appears each time a new user tries to register and his data is not added to the database.
Worth mentioning: if I try to create a new group in the admin panel, the same problem occurs. After I delete the 8388607 entry, I can create the new group in the admin panel, but the same group_id number appears at the end of the group table, and the problem starts over again.
- WHY is that specific number being added to the group_id everytime a new user tries to register?
- WHY does this block any further new user from registering?
- HOW can I correct this problem?
I have tried the fix from this topic http://www.phpbb.com/phpBB/viewtopic.ph ... highlight=
, but it doesn't the problem I have.
I have 2.03 installed.
I have the "default avatar" mod installed.
I am using Grunge skin.
I have the "extended user search" mod installed.
Here is the DEBUG MODE MESSAGE:
Could not insert data into groups table
SQL Error : 1062 Duplicate entry '8388607' for key 1
INSERT INTO phpbb_groups (group_name, group_description, group_single_user, group_moderator) VALUES ('', 'Personal User', 1, 0)
Line : 524
File : /www/mperreault/latexlover/bianca/forum/includes/usercp_register.php
I would really like to fix this problem once and for all (I've posted here before about it) so all suggestions will be more than welcome.
If there is no direct fix, is there any other way I can do this? Like:
- backup my user data
- back up my messages
- re-install PHPBB from scratch
- restore the date
Would this fix the problem? If so, how would I go on backuping all the data?