Registration issue

[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.