How do I clear the edit/delete log quickly?

Andy K

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?

peregrine

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.

peregrine

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

peregrine

try this newly created plugin

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

UnderDog

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?

Andy K

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

HalfCat

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

peregrine

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

Simeon_Griggs

@peregrine said:
try this newly created plugin

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

Does this still exist somewhere?