Thread: duplicate entry

Having one of those days. When wanted to delete a table and accidentally deleted the entire database
Well luckily had backed up the database so did not loose many profiles and it gave me a chance to upgrade to your lastest version 3.3.

But when I try to refresh my phpbb2 forum users or try to change the status of a user to active I get a module error.

1] When I try to change the status of the user to active the problem is my phpbb-user table also gets that user added and the program sees that as a duplicate user and thus I get the module error. The status gets changed but the error keeps coming. So not affecting me so much at the moment with regard changing the status of the user as I am able to do so.

error message =
phpbb

Duplicate entry '8388607' for key 1

2]when i try to refresh all users to my phpbb2 forum the problem is the same again it sees all the users in the aedating database and of course all of them are already present and states duplicate entry and does not update my forum with users.................................so my forum is out of action.
similar error
phpbb

Duplicate entry '8388607' for key 1

Things I have tried:
1] repeatedly gone into the mysql database deleted the duplicate entry in the phpbb_user table and tried again but makes no difference.
2]totally stopped mysql and restrated it again.
3]rebooted the system
4]restrated apache
5]applied the patch for max connections.

yestreday I was getting this error = Error in /shoutbox.php: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)

but restrating mysql seems to have stopped that.

If you could give me a list of things I should check on I would be most grateful.

Thank you

I have solved the problem by going to the phpbb_users table and there changing medint to int so that the upper limit is as below.


SMALLINT (limit of 32,767), MEDIUMINT (limit of 8,388,607) or INT (limit of 2,147,483,647)

I have tired resetting this but have not been successful if anybody has a better way before i reach 200million users let me know

Hi,

Look in the module code... see if there is some math being done to the user ID number.... something like "$ID + 100000" or something...

Also, check the autoincrement settings of your users table in phpBB... see if that has some funky settings.

Smoge

that is it you are a genius.....................
I had add in the module 1000000 as the module eventually limits the number of users forgotten i had done that.
thank you very much even aedating could not figure that one out........................wondering did they even write that script.