SQL commands

deleting some dirt

Old entries inside your db

Often the deleted entry in BE won´t killed in DB. You can regenerate the old entries via phpMyAdmin.

In future please rename the purging structure level to an nonsensical name (and save) before deleting this level.

To throwing out all deleted entries from db, please run this snippet using phpMyAdmin in SQL:

For deleted articles:

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

For deleted structure names:

DELETE FROM phpwcms_articlecat WHERE acat_trash=9;

For deleted files/pictures

For deleted files/pictures (only after you have cleared the trash can in filemanager and doing Admin → remove deleted files!!!

DELETE FROM phpwcms_file WHERE f_trash=8;
english/technics/database/sql-commands.txt · Last modified: 2009/05/12 00:21 by Knut Heermann (flip-flop)
www.planmatrix.de www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0