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 do I clear the edit/delete log quickly?

Andy KAndy K ✭
edited October 2012 in Vanilla 2.0 - 2.8

I've got 80+ pages of Edit Delete Log now that I'll never need, and I want to keep the DB as small as possible. What's the fastest way to clear this log? Can I empty one of the DB entries? Is there another way?

If nothing else, how do I get more than 10 posts to show up at once on this log (like say "100") so that I can better mass-delete through the forum's dashboard?

Comments

  • Options
    peregrineperegrine MVP
    edited October 2012

    I agree with you there needs to be a mass delete for log.

    go in to phpmyadmin and use the empty command on the log table.

    or truncate command in mysql.

    or find a suitable date and adjust the limit or leave limit out.

    DELETE FROMGDN_LogWHERERecordDate< '2012-05-14' LIMIT 1

    What I have done is prevent writing to log.

    http://vanillaforums.org/discussion/comment/157128/#Comment_157128

    The same goes for the acitivities table and conversations....

    a bit off topic here...
    activity table - alot types of activities - "sent you a message' that are a year old are pretty meaningless and should also have a purge.

    conversations - If the users involved in the conversations delete the conversation the body of the conversation remains forever in the database.

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • Options
    peregrineperegrine MVP

    delete entries older than 30 days. You could also add something like this to the

    http://vanillaforums.org/discussion/comment/157128/#Comment_157128
    in applications/dashboard/models/class.logmodel.php (around line 257 in v2.18.04)

    DELETE FROM GDN_Log WHERE DATEDIFF( CURDATE( ) , RecordDate ) > '30' LIMIT 1

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • Options
    peregrineperegrine MVP

    try this newly created plugin

    http://vanillaforums.org/addon/cleanlog-plugin

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • Options
    UnderDogUnderDog MVP

    Come to think of it, we actually need some kind of task list functionality in Vanilla and we need to be able to run certain tasks (like cleanlog and backup) from that task list functionality. Pretty please?

    There was an error rendering this rich post.

  • Options
    Andy KAndy K ✭

    Absolutely awesome, peregrine. I tested, it worked perfectly. THANK YOU!

  • Options
    HalfCatHalfCat ✭✭

    @UnderDog said:
    Come to think of it, we actually need some kind of task list functionality in Vanilla and we need to be able to run certain tasks (like cleanlog and backup) from that task list functionality. Pretty please?

    businessdad created an awesome plugin that lets other plugins register cronjobs.

  • Options
    peregrineperegrine MVP

    @Andy K said:
    Absolutely awesome, peregrine. I tested, it worked perfectly. THANK YOU!

    and thank you @Andy K for the positive feedback for the plugin itself and your monetary donation. That was a nice touch.

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • Options
    Simeon_GriggsSimeon_Griggs ✭

    @peregrine said:
    try this newly created plugin

    http://vanillaforums.org/addon/cleanlog-plugin

    Does this still exist somewhere?

Sign In or Register to comment.