Blog Documentation Try Vanilla Cloud
Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

how to delete everything inside /activity

sollyboisollyboi New
in Vanilla 2.0 - 2.8

i want to delete everything inside /activity since it's causing overloads. i have it self hosted. how can i delete them using sqlquery from phpmysqladmin?

Answers

  • Options
    GaryFunkGaryFunk Senior Application Developer ✭✭
    edited January 2013

    sql="DELETE FROM gdn_activity"

  • Options
    sollyboisollyboi New

    will this delete the comments as well inside the discussions? i fear it might... :|

  • Options
    GaryFunkGaryFunk Senior Application Developer ✭✭

    No. It only deletes things that show as Activity.

  • Options
    sollyboisollyboi New

    my site is now broken after restart on server after deleting activity contents db :(

  • Options
    UnderDogUnderDog MVP

    @sollyboi said:
    my site is now broken after restart on server after deleting activity contents db :(

    Define 'broken'. You made a backup, right?
    Deleting Activity from phpMySQLAdmin is ok to do, so 'broken' might be easy to fix.

    There was an error rendering this rich post.

  • Options
    sollyboisollyboi New

    @UnderDog i've fixed the problem it happened because my gdn_discussion db was corrupted

Sign In or Register to comment.