vFranky
Guest
Member
Hello,
I like to count the likes from each user in 2021. In recent years, I used the SQL string below, which works fine. But this year, I get an error message "#1146 - Table 'wa9301_db18.xf_liked_content' doesn't exist".
Was there any change from XF 2.1 to XF 2.2? Any idea or tips?
Thank you in advance!
Kind regards,
Frank
Code:
Read more
I like to count the likes from each user in 2021. In recent years, I used the SQL string below, which works fine. But this year, I get an error message "#1146 - Table 'wa9301_db18.xf_liked_content' doesn't exist".
Was there any change from XF 2.1 to XF 2.2? Any idea or tips?
Thank you in advance!
Kind regards,
Frank
Code:
Code:
SELECT COUNT(*) AS likes, xf_user.user_id, xf_user.username
FROM xf_liked_content
INNER JOIN xf_user ON (xf_user.user_id =...Read more
