Remove Deleted Articles from Database: Is it Safe?

Get help with installation and running phpwcms here. Please do not post bug reports or feature requests here.
Post Reply
HexManiac
Posts: 1
Joined: Fri 12. May 2006, 16:15

Remove Deleted Articles from Database: Is it Safe?

Post by HexManiac »

I notice that when you delete an article or article content part, phpwcms doesn't delete it from the database.

Instead, it just flags the article as deleted by setting the 'article_deleted' field or 'acontent_trash' field to 9.

This results in the database growing in size over time.

Does anyone know whether it's safe to remove these entries from the database by executing SQL statements like these?:

DELETE FROM phpwcms_article WHERE article_deleted=9
DELETE FROM phpwcms_articlecontent WHERE acontent_trash=9

or will this break something?
Post Reply