I don't know what is the problem in my installation (wp mu + buddypress) but I often see (not always), user activity in triplicate. The message
user xyz registered 5 minutes ago
would appear thrice
sometimes new groups created would list thrice.
And many users also list thrice on the screen in the wordpress when I delete a user and assign its posts to some other user.
I have seen that this occurs because of multiple identical meta entries at some point. Cleaning the group meta table is easy because of limited groups. I can manually delete identical rows. But I would like to clean my database of the duplicate rows, esp usermeta table. I need some sql for that because that table shows more than 80000 records.
Can the pros here help me write an sql query to check the usermeta table for duplicate rows and then delete the extra rows while keeping one copy with the lowest id?