XF 1.1 Query to delete profile comments

Ranma1981

Member
Hello,

is there some Db Query (or another fast way), to delete all profile comments from the forum? And, clear them completely.

Thank you,
Regards
 

borbole

Well-known member
Hello,

is there some Db Query (or another fast way), to delete all profile comments from the forum? And, clear them completely.

Thank you,
Regards

For everyone? Truncate these tables, xf_profile_post_comment and xf_profile_post. Then you might want to clear the statutes. To do that truncate the xf_user_status table and then run this query:

Code:
UPDATE xf_user_profile
SET
status = '',
status_date = 0,
status_profile_post_id = 0;

Replace xf_ with whatever prefix you are using for your db tables if you are not using the standard xf_ prefix.
 
Top