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 8.0.0 Release 20240826 Server OS Linux Server Load 0.11 Web Server Apache/2.4.37 PHP Version 8.3.11 MYSQL Version 8.0.39 Database Size 1.82 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 8.0.0 Release 20240826 Server OS Linux Server Load 0.11 Web Server Apache/2.4.37 PHP Version 8.3.11 MYSQL Version 8.0.39 Database Size 1.82 GB
Server Information UBB.threads Version 8.0.0 Release 20240826 Server OS Linux Server Load 0.11 Web Server Apache/2.4.37 PHP Version 8.3.11 MYSQL Version 8.0.39 Database Size 1.82 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 8.0.0 Release 20240826 Server OS Linux Server Load 0.11 Web Server Apache/2.4.37 PHP Version 8.3.11 MYSQL Version 8.0.39 Database Size 1.82 GB
You could backup your likes table Install a test board and export the empty like table Then delete the active likes table Then import the new likes table Then import your backup
That would make sure of any mistakes when you fat finger add the missing columns.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
I was mistaken about the TYPE column. You can see that from the screenshot that I posted. It already existed. The only thing that was missing was the LIKE_ID column.
All I had to do was add the LIKE_ID column and it was automatically populated with the indexes. Very simple fix.
Server Information UBB.threads Version 8.0.0 Release 20240826 Server OS Linux Server Load 0.11 Web Server Apache/2.4.37 PHP Version 8.3.11 MYSQL Version 8.0.39 Database Size 1.82 GB
I would advise against Rubens suggestion as it would remove all of your like data for the sake of adding a column which is a simple procedure... The off-chance of data being corrupted in your table backup isn't worth the extra steps when you can just add the missing auto increase column.
