Can ost_file_chunk be purged?

VerusAutenticus

Hi,
I hope you are well.
I have moved to filesystem storage for attachments but I can see that this table is huge.
Is there any effective way to purge it? What entries in other tables needs deleting?
I am on v1.16.5
Please advise.
Thank you

KevinTheJedi

VerusAutenticus

Those are all the previous files before you switched to the file system. Even though you installed the plugin it will not automatically migrate all the files for you. For this you must run a CLI command to manually migrate the existing files in batches. You can search older threads as this has been explained many times with steps and everything.

Keep in mind this only applies to files uploaded before you changed your system settings to start using the file system. All new files will start storing on the file system but the previous, existing files need to be migrated.

Also your osTicket version is old and no longer supported. It’s highly encouraged that you upgrade to the latest ASAP.

Cheers.

VerusAutenticus

Hi again, thanks for that.

Re the upgrade I did try 1.17.x and 1.18.x but on LiteSpeed V8.1 they both come up blank even when I change the PHP version to 8.1 or 8.2.

KevinTheJedi

VerusAutenticus

Then you would need to check your various logs for any related errors. Could be permissions issues, ownership issues, SELinux, a fatal PHP error, database connection issues, etc.

Cheers.