Registration issue

[Lynne]

Try it without the apostrophes.

[CaptainAwesome]

Originally Posted by Lynne

Try it without the apostrophes.

No difference.

--------------- Added [DATE]1408926117[/DATE] at [TIME]1408926117[/TIME] ---------------

I think i have identified the problem. I just need some advice on how to clean up the database to avoid screwing things up.

I went into the userid table and it shows a total of 80953 results. It may ahve something to do with when i done a partial import and then an additional import. The error log shows:

MySQL Error : Duplicate entry '50966' for key 'PRIMARY'

I can't select all the rows in one go, and don't want to have to select 30,000 results one by one.

So what would be the best way to fix this? I'm thinking export it, delete it, and then import it. Being inexperienced, i thought i would check with you more experienced people and ask for some guidance on how to best do this. The number of users is very low so re-creating the database shouldn't be a big deal.

[Lynne]

Check the auto_increment for the user table and make sure it is set to a number greater than any userid in the table. Then make sure the userfield table doesn't have a row with a userid greater than the auto_increment either.

[CaptainAwesome]

How would i do that? Google didn't throw up anything useful.

[Lynne]

I use phpMyAdmin to access my database and check things like the auto_increment.

[CaptainAwesome]

After some stumbling around and googling, i found where i edited the auto_increment and it all works fine now.

Thanks for your help.