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

Discussion in 'XenForo Questions and Support' started by Ranma1981, Jan 31, 2013.

  1. Ranma1981

    Ranma1981 Member


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

    Thank you,
  2. borbole

    borbole Well-Known Member

    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
    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.

Share This Page