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.
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?
0
Comments
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 FROM
GDN_LogWHERE
RecordDate< '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.
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 1I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
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.
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.
Absolutely awesome, peregrine. I tested, it worked perfectly. THANK YOU!
businessdad created an awesome plugin that lets other plugins register cronjobs.
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.
Does this still exist somewhere?