• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.1 Query to delete profile comments

#1
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
#2
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.