AI Assistant
Notifications
Clear all

Counter does now work

8 Posts
5 Users
0 Reactions
3,868 Views
Posts: 1
Customer
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@holger-kopf)
Member
Joined: 5 years ago
[#7892]

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 ?


7 Replies
Posts: 4245
 Tom
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@tomson)
Famed Member
Joined: 11 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: 13
Customer
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@kelly-peterson)
Member
Joined: 4 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: 4245
 Tom
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@tomson)
Famed Member
Joined: 11 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: 13
Customer
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@kelly-peterson)
Member
Joined: 4 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
Page 1 / 2
Share:
Scroll to top