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

XF 1.3 Can't Delete Reports?

Discussion in 'XenForo Questions and Support' started by CaptainMorgan, Mar 21, 2014.

  1. CaptainMorgan

    CaptainMorgan Active Member

    Hey folks - I did a search here and oddly enough it was not very helpful; used "can't delete reports". Is it possible to delete reports from the Admin interface? Or do I need to do so via the database?

    Can you briefly elaborate why this feature is not core? (I did not see any add-ons either relating to this)

  2. Brogan

    Brogan XenForo Moderator Staff Member

    Reports are meant to provide a historical record, hence why there is no option to delete them.
    Liam W likes this.
  3. CaptainMorgan

    CaptainMorgan Active Member

    Certainly fair enough... but I'm currently in dev phase, so there's ample testing being performed and I would simply like to remove "test reports" and things of that nature before going live, ya?

    Thanks for the swiftness in reply.
  4. Brogan

    Brogan XenForo Moderator Staff Member

    There are two tables related to reports:
    • xf_report
    • xf_report_comment

    Are you going to go live with a database you have been using for testing?
    Why not start the site with a clean install?
    maszd likes this.
  5. CaptainMorgan

    CaptainMorgan Active Member

    Thanks Brogan - you rock dude, keep up the great work.

    To answer your questions, we are doing a little of both, if that makes sense. Thanks again - Cheers
  6. Duck

    Duck Member

    Our moderators like to report posts just to make fun of the member who made the post. Then later on that member may be considered as a moderator. Obviously it would be awkward if the new moderator digs into the old closed reports & sees where we've made fun of him in the past. That's why we'd like to be able to periodically delete the closed reports when a new moderator is added, without having to run potentially dangerous queries on the server to get rid of them.
    Methodical likes this.
  7. Chris D

    Chris D XenForo Developer Staff Member

    How about, don't make fun of your members?

    The queries aren't potentially dangerous, either.
  8. CaptainMorgan

    CaptainMorgan Active Member

    Aye - the queries are not dangerous per say as it's just a matter of going to the specific tables Brogan notes and removing the rows in question.

    But you have a bigger problem (maybe a moral problem) at hand here if you have people considered to be in authority at your website that are going behind people's backs and making fun of other members. That is one thing I do not tolerate for a second at our site. At our site, if you can't say something to someone in person, then don't be saying it behind their backs either. Evidently, if you feel ashamed that you must remove certain reports then it's obvious these "moderators" don't have the 1) cojones to run a site properly and 2) wouldn't dare say something to these people in person. Like I said, you have a bigger problem than mere reports.

    I've gone slightly off topic, but you can find more support for this kind of problem at AdminExtra and other similar sites.
    Chris D likes this.
  9. Freelancer

    Freelancer Well-Known Member

    For a complete reset: When I just delete the table ROWS in phpMyAdmin of both the report and report_comments then reports are completely reset? I am going to reset the entire board by deleting everything, but reports can only be deleted in the database. Just want to go sure I am not destroying anything by deleting the rows.
  10. Brogan

    Brogan XenForo Moderator Staff Member

    You can likely just truncate both tables.

    Untested though so I'm not sure if any other steps are required.
    Freelancer likes this.
  11. Freelancer

    Freelancer Well-Known Member

    Ill try it shortly after the backup routine. Thank you!
  12. dethfire

    dethfire Well-Known Member

    I'm also looking for a way to remove years old reports that just rot in the DB. Same can be said for watched threads table.

Share This Page