I've been trying to recreate this, feedback would be immensely helpful in ironing out any variations on bugs.

To find posts with duplicate likes you'd want to run the query:
SQL Query
SELECT
	`POST_ID`, COUNT(`POST_ID`),
	`USER_ID`, COUNT(`USER_ID`)
FROM 
	`ubbt_LIKES`
GROUP BY
	`POST_ID`,
	`USER_ID`
HAVING 
	COUNT(`POST_ID`) > 1
	AND COUNT(`USER_ID`) > 1;

Then to remove those likes you'd want to:
SQL Query
DELETE FROM
	`ubbt_LIKES`
WHERE
	`POST_ID`='postidnumber'
	AND `USER_ID`='useridnumber'

Where the postidnumber and useridnumber would be from the previous query.

ubbt_ in both queries would be whatever your database prefix is set to, default being ubbt_


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!