Blog Documentation Book a Demo

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.