Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
Prune Database Request
Avatar
Tal
Member
Free Members
sp_UserOfflineSmall Offline
Apr 7, 2015 - 1:17 am

I ran the stats cron right away and nope, no difference

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Apr 7, 2015 - 4:07 am

I fail to see why that doesn't work actually but still... 

So you could try this direct database query which does the same thing as the code version but does less work:

UPDATE wp_sfforums SET
post_count = (SELECT COUNT(post_id) FROM wp_sfposts WHERE forum_id = XXX),
topic_count = (SELECT COUNT(topic_id) FROM wp_sftopics WHERE forum_id = XXX)
WHERE forum_id = XXX;

usual rules. Table prefix... Change XXX for the forum ID you need to check and update (i.e., the one where topics were manually removed from). And make that usual backup!

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 617
Members: 17359
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10125
Posts: 79620