XF 1.1 Query to delete profile comments

[Ranma1981]

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]

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:

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.