Blog Documentation Book a Demo
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Database Cleanup

jen225jen225
edited August 2006 in Vanilla 1.0 Help
Maybe I'm missing something; however, is there an easy database cleanup function to removed messages & comments older than a certain date. I guess I can always use the following SQL query to remove by date but it would be nice if it could be included as an admin function. delete from 'table_name' where dated < date_add(now(),interval -30 day) Also, I noticed some of the add-ons such as the poll add-on creates new tables that link to existing discussions. If you delete a discussion that has a user created poll attached to it we need to make sure it also removes the poll or else you could end up with a lot of broken records in the poll tables. Any suggestions on a solution for this? The database cleanup is a concern of mine since I receive around 1000 posts/day on our board. I love the Vanilla board and wish to pass my compliments to the Lussumo team.

Comments

  • BergamotBergamot
    It would be pretty easy to write an extension to run that query whenever somebody adds a new topic. Fancy control panels and such are harder.
This discussion has been closed.