NAVIGATION
This is an old revision of the document!
Imagine some people who did upload a bunch of files each. What a PITA to sort this mess - well, not really, because it is plain impossible to do so.
But there is help - read the following and get instant relief:
UPDATE TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, 'find this', 'replace with that');
This will translate into (where “2” is the f_uid of the second admin e.g. and you yourself are the number “1”)
UPDATE phpwcms_file SET f_uid=REPLACE(f_uid, '2', '1');
But this is still a placeholder! Imagine, which wonderful (and terrible) things you can do with that command!
And the result of the above? The folder of the second admin is plain empty and you are the winner
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:
DELETE FROM phpwcms_article WHERE article_deleted=9; DELETE FROM phpwcms_articlecontent WHERE acontent_trash=9;
DELETE FROM phpwcms_articlecat WHERE acat_trash=9;
<note important> For deleted files/pictures (only after you have cleared the trash can in filemanager and doing Admin → remove deleted files!!! </note>
DELETE FROM phpwcms_file WHERE f_trash=8;