SQL ERROR W DEBUG

[-=DARKMAN=-]

I'm having this error message when trying to register new user:

Code: Alles auswählen

General Error 
  
Could not insert data into groups table

DEBUG MODE

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

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

Line : 524
File : C:\wwwroot\phpBB2\includes\usercp_register.php

I cannot solve this, but here is some more details:
in phpMyAdmin I have

Code: Alles auswählen

table mastergroups running on localhost
   Row Statistic : Statements Value 
Format dynamic  
Rows 150  
Row length ø 24  
Row size  ø 58 Bytes  
Next Autoindex 8,388,607 

And last 2 rows inside has

Code: Alles auswählen

    190 1   Personal User 0 1 
8388607 1   Personal User 0 1

Now it seams prety ovious that next number should be 191, but it's not!
And it doesent go up by 1 on next registration? why?

please also note that auto_increment is set on table..

Code: Alles auswählen

group_id  mediumint(8)   No    auto_increment  Change  Drop  Primary  Index  Unique  Fulltext 

And also that it has nothing to do with php files.. I tested it on CLEAN unpacked latest version of phpBB but with my current database!

greetz from neigh. Croatia
HELP

[PhilippK]

Did you check the table with the MySQL REPAIR TABLE-command?

Philipp

[-=DARKMAN=-]

Yes, no errors found

[PhilippK]

Try that: export the hole table (data and structure), drop the old table and reimport the backup.

Philipp

[-=DARKMAN=-]

No go!

Still

Code: Alles auswählen

Next Autoindex 8,388,607  

[PhilippK]

Do it again. But this time edit the downloaded file and change 8388607 to 191.
After that check table phpbb_user_group (Name may differ depending on prefix selected) and change all records where group_id is 8388607 to group_id = 191.
Then try again.

Philipp

[-=DARKMAN=-]

It works only until next registration which is sucessful, but with 8388607...
Registration after that is duplicate..

I found something on phpBB official forum, and they said it is converter bug or something to do with UBB -> phpBB

I'll post here 4 everyone to know how to fix it if I could do it with their methods...

Thanx 4 help !!

[Jesper]

Hi,

I have that very same problem. The weird thing is that the first time I ran into it the dropping and redefinition of the table worked. Some time later I had to set up the forum anew and the method didn't work any more.

I also tried the SQL-command

ALTER TABLE phpbb_users AUTO_INCREMENT = x

but that didn't change a thing. Table check was ok too. I'd be VERY interested in the solution of this problem as I cannot find one...

Thanks in advance, JJS