phpBB.de

Code: Alles auswählen

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

Code: Alles auswählen

DELETE FROM phpbb_auth_access; 
DELETE FROM phpbb_groups; 
DELETE FROM phpbb_user_group; 

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

INSERT INTO phpbb_groups (group_id, group_type, group_description, group_moderator, group_single_user) SELECT user_id + 1, 1, 'Personal User', 0, 1 FROM phpbb_users WHERE user_id > -1; 

INSERT INTO phpbb_user_group (user_id, group_id, user_pending) VALUES (-1, 1, 0); 

INSERT INTO phpbb_user_group (user_id, group_id, user_pending) SELECT user_id, user_id + 1, 0 FROM phpbb_users WHERE user_id > -1;