SMF Support > SMF 2.0.x Support

Deleting user with delete all posts checked does not work

(1/1)

malayo:
as the topic above, this happened on version 2.0.2
mods installed:

YouTube BBCode    2.6
Tapatalk SMF 2.0 RC4/RC5/Final Plugin    3.0.2
SimplePortal    2.3.5
Hide SMF Version    1.0.6a

any sql script that i can use to delete 10k+ posts from deleted user?
thanks

malayo:
impatiently, i devised below script

--- Code: ---DELETE FROM smf_messages
WHERE poster_name = 'ScepNexpend'
--- End code ---

worked, but it did not reset the posts count and pages

Mstcool:
Go to admin> Maintenance >Routine>run the recount all post stats

malayo:

--- Quote from: Mstcool on July 17, 2012, 08:06:50 AM ---Go to admin> Maintenance >Routine>run the recount all post stats

--- End quote ---
thanks, this solved the post count issue but unfortunately the topics count does not get recounted

Mstcool:
No problem

Navigation

[0] Message Index