SELECT COUNT(LIKE_ID) AS COUNT FROM sbf_LIKES GROUP BY TYPE, POST_ID, POSTER_ID, TOPIC_ID, USER_ID HAVING COUNT(TYPE) > 1 AND COUNT(POST_ID) > 1 AND COUNT(POSTER_ID) > 1 AND COUNT(TOPIC_ID) > 1 AND COUNT(USER_ID) > 1
Server Information UBB.threads Version 7.7.5 Release 20201027 Server OS Linux Server Load 0.16 Web Server Apache/2.4.6 PHP Version 7.4.33 MYSQL Version 5.7.43 Database Size 1.85 GB
Do you have a _LIKES table? LIKE_ID is the row column; it should have been added as a part of the v7.7.4 install (step 6 of the alter table). It should have 7 columns, LIKE_ID TYPE POST_ID POSTER_ID TOPIC_ID USER_ID TIMESTAMP
I only have five: POST_ID, POSTER_ID, TOPIC_ID, USER_ID, TIMESTAMP. Looks like I'm missing LIKE_ID and TYPE. I'm running 7.7.5. Did I miss a step during an upgrade? If so, is there a way to fix it?
Server Information UBB.threads Version 7.7.5 Release 20201027 Server OS Linux Server Load 0.16 Web Server Apache/2.4.6 PHP Version 7.4.33 MYSQL Version 5.7.43 Database Size 1.85 GB
Server Information UBB.threads Version 7.7.5 Release 20201027 Server OS Linux Server Load 0.16 Web Server Apache/2.4.6 PHP Version 7.4.33 MYSQL Version 5.7.43 Database Size 1.85 GB
You'll want to use PHPMyAdmin to insert the missing columns, theres also an option for moving columns if you want it to show in PHPMyAdmin the same as my screenshot.
Server Information UBB.threads Version 7.7.5 Release 20201027 Server OS Linux Server Load 0.16 Web Server Apache/2.4.6 PHP Version 7.4.33 MYSQL Version 5.7.43 Database Size 1.85 GB