Hello, i have moved my attachements from db to fs via plugin "Attachments on the filesystem", but files and folders are not in human readable format like (attachments_folder/month_of_uploading/date/*). How can i find and delete attachments older than 180 days?

I do not think that you can via the filesystem. Since all the files were 'created' in the file system the day that you migrated them.

The good news is that you should be able to do it with a custom mysql query in the database.
Take a look at table ost_file. See the created column.

Something like this should work.

DELETE FROM ost_file 
LEFT JOIN
ost_file_chunk ON ost_file.id = ost_file_chunk.file_id
WHERE ost_file.created < NOW() - INTERVAL 180 DAY;

note: please always back up your database before you run any sql queries against it.

    Well, i've tested it on copy of server, and there slight issues with it:
    1. Custom backgrounds and logos also got included by querie ntozier posted, so i included filter by ost_file.key (or mabye its better by ost_file.id itslef?).
    2. There still icon of attachment on the ticket without attachment, which confuses people.

    this working fine for me (mysql Ver 14.14 Distrib 5.7.15):

    DELETE `ost_file`, `ost_file_chunk` FROM ost_file 
LEFT JOIN ost_file_chunk ON ost_file.id = ost_file_chunk.file_id 
WHERE ost_file.created < NOW() - INTERVAL 180 DAY AND ost_file.key
NOT IN('key_of_logo_1','key_of_scp_bg_1','key_of_logo_2','key_of_scp_bg_2',...etc);

    PS: im not responsible if you damage your production db by this query.

    ntozier always back up your database before you run any sql queries against it

        Write a Reply...