Hi, if i remove a topic prefix from a topic the counter is not decreased. But if add a topic prefix the counter will be increased.
Right now i removed all topic prefixes, but the counter is still > 0
What can i do ?
Hi, if i remove a topic prefix from a topic the counter is not decreased. But if add a topic prefix the counter will be increased.
Right now i removed all topic prefixes, but the counter is still > 0
What can i do ?
Hi @holger-kopf,
Please go to Dashboard > Forums > Topic Prefixes admin page, edit the prefix and save it. It should update the count. We'll check this issue and fix in the next update.
Just a heads up that this is still going on. I am having the problem on my fully updated forum. Saving the prefix again did fix it, but this would be a pain if I had to do it all the time. Maybe a function you can run to recalculate the counts would be a good solution?
Hi @kelly-peterson,
You can execute this SQL query to update all prefix counts:
UPDATE `wp_wpforo_prefixes` PX SET PX.count = ( select COUNT(*) FROM `wp_wpforo_topics` T WHERE FIND_IN_SET(PX.prefixid , `prefix`) )
Use phpMyAdmin plugin or the same tool in your cPanel, go to the website database, then the [SQL] tab and execute that SQL query.
Please make sure your table prefix is wp_, if it's not wp_, you should change the red marked wp_ prefixes.
Oh! Thank you! I will make use of that soon. Hopefully you can add it to the tools for admin’s so it can be integrated into the system.