After migrating osTicket to a new server, old attachments stored in the database appear corrupted and cannot be opened
The database export was not performed in binary-safe mode. Binary blob data (attachments stored in the DB) requires binary-safe export. Re-export using mysqldump or mariadb-dump from the command line -- these are always binary-safe by default. If using MySQL Workbench, ensure 'Include binary columns' is checked before exporting. Re-import the corrected dump on the new server.
Originally sourced from forum.osticket.com . osFAQ.org summarises community knowledge for quick reference.
Helpful
Report an error