Duplicated users ......

[Mc Ghoush]

Hi,
I found that I have got duplicated users having the same info (Username , Email , password ....). How can I delete them with keeping only one user ?
Note : I reterived the info from UBB and I found this problem.....


Regards
Mc Ghoush

[Mc Ghoush]

????

[Martin]

If you haven't gone live with your board yet, the easiest way is to delete all users and reimport.

if you have gone live with your board, you will have to delete the users using a mysql query thru telnet or manually.

I'm too tired to think right now, but the query can be found at http://www.mysql.com

just back up your database before doing it.

[Mc Ghoush]

Who can give me the way exactly because I'm not expert.

[Mc Ghoush]

Any body ???? I looked in mysql manual but didn't find any thing. Please .....

[Me2Be]

Basically, delete the database you started and reinstall and reimport your UBB.

Make sure you have the latest version 1.1.5 because I've heard people having problems with this in earlier versions.

[Mc Ghoush]

I'm already using it right now..... I can't delete it. Is there any way ?
Note : I was using 1.1.4 and now 1.1.5 with no change.

[Me2Be]

Are you on a virtual or dedicated server? Are you able to create/delete databases at your own discretion or are you 'assigned' a database to work with?

[Mc Ghoush]

I'm assigned a database to work with.


ANd just for knowledge. What to do if I was able to create/delete databases at my own discretion ?


Regards

[Mc Ghoush]

Who wanna help me ?

[Mike Sullivan]

I probably easiest if you try re-importing. You won't duplicate users unless you don't delete them. :)