Duplicate usernames in ac_users

[WylieE]

Hello all,

We've found a number of duplicate usernames in ac_users. Only one of them has an order placed with one of the userids. I'd like to delete the dupes, but do not want to create any orphan data elsewhere. I've found entries in ac_addresses and they're all blank save for the one row that matches up with an order.

If I delete the dupe entries in ac_users and ac_addresses, are there any other tables I need to clean up?

Thanks,
Eric.

[mazhar]

You should better drop the user using Administration > People > Users. This way API will try to keep things consistent for delete operation.

[WylieE]

Doh! Good call.

Done. Thanks!