Notifications
Clear all

Counter does now work

5 Posts
3 Users
0 Likes
1,043 Views
Posts: 1
Customer
Topic starter
(@holger-kopf)
Member
Joined: 3 years ago

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 ?

4 Replies
Posts: 4172
 Tom
Admin
(@tomson)
Famed Member
Joined: 9 years ago

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.

Reply
Posts: 9
Customer
(@kelly-peterson)
Member
Joined: 2 years ago

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?

Reply
Posts: 4172
 Tom
Admin
(@tomson)
Famed Member
Joined: 9 years ago

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.

Reply
Posts: 9
Customer
(@kelly-peterson)
Member
Joined: 2 years ago

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.  

Reply
Share:
Scroll to top