Limited Support
Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.
Hi,
In our forum, there are 2040 posts but 93.000 reaction. It is not expected because our average of post like is 3 or 4. The reactions before wpforo 2.0 update are multiplied. Here is a screen capture:
I guess I know the origin of problem. I had installed wpforo v2.0 when it was first published. But, I turned to Wpforo v1.0 again. Then after a month I updated to v2.0 again and saw that old reactions are multiplied. I guess it is due to table differences between two wpforo versions.
Now could I fix this problem? If it is not possible, can I delete old reactions apart from last one month?
Yes, this problem is due to the downgrading of the wpForo to 1.x. When the deb has already been updated to 2.x version, you should not downgrade to 1.x.
The solution is to delete all reactions:
1. Execute this SQL in the WordPress database, make sure the wp_tempae prefix matches to your table's prefix, if it doesn't, just change it:
TRUNCATE `wp_wpforo_reactions`
In any case, I'd recommend to backup the wp_wpforo_reactions table.
2. Then use some FTP client and remove the /reaction/ folder located in the /wp-content/uploads/wpforo/cache/item/ directory.