[FIXED] Help! Error message after registration

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
baerenwurm
Registered User
Posts: 131
Joined: Wed Nov 06, 2002 2:38 pm
Location: Germany

[FIXED] Help! Error message after registration

Post by baerenwurm » Fri Nov 08, 2002 7:29 pm

If I try to register a new user on my board following message appears after sending the data:

Could not insert data into groups table
Last edited by baerenwurm on Fri Nov 08, 2002 8:44 pm, edited 2 times in total.

User avatar
primedomain
Former Team Member
Posts: 25944
Joined: Sat Dec 15, 2001 10:23 am

Post by primedomain » Fri Nov 08, 2002 7:33 pm

Please enable debug mode and post the complete error message:
http://www.phpbb.com/phpBB/viewtopic.ph ... able+debug

baerenwurm
Registered User
Posts: 131
Joined: Wed Nov 06, 2002 2:38 pm
Location: Germany

Post by baerenwurm » Fri Nov 08, 2002 7:38 pm

Could not insert data into groups table

DEBUG MODE

SQL Error : 1062 Duplicate entry '0' for key 1

INSERT INTO phpbb_groups (group_name, group_description, group_single_user, group_moderator) VALUES ('', 'Personal User', 1, 0)

Line : 524
File : /var/www/web134/html/forum/includes/usercp_register.php

baerenwurm
Registered User
Posts: 131
Joined: Wed Nov 06, 2002 2:38 pm
Location: Germany

Post by baerenwurm » Fri Nov 08, 2002 7:55 pm

I'm sure, that it has worked after installing the board.
I just changed the general configuration, template, smilies, chat mod, something in user's/group's rights, general group & rank stuff and the right to view/write etc. forums.
I haven't changed anything in phpMyAdmin, except for deleting two users from the user-table.

By the way: the users are being registered, but instead of confirming the registration and sending an email, that error message appears.

baerenwurm
Registered User
Posts: 131
Joined: Wed Nov 06, 2002 2:38 pm
Location: Germany

Post by baerenwurm » Fri Nov 08, 2002 8:22 pm

I have two groups installed:
Administrator & Moderator (I've deleted Global moderator)

baerenwurm
Registered User
Posts: 131
Joined: Wed Nov 06, 2002 2:38 pm
Location: Germany

Post by baerenwurm » Fri Nov 08, 2002 8:43 pm

The fix is here:

http://www.phpbb.com/phpBB/viewtopic.php?t=50561

(That's not the fix for those, who have this problem due to upgrading from 2.0.2)

Locked

Return to “2.0.x Support Forum”