Unable to Open Old Attachments After Migration

apers

I recently migrated my osticket instance from one computer to another. However I am unable to open attachments that were migrated from that old server. It seems like the files are corrupted. I store the attachments in the DB. I can still access the old instance of osticket. Can you provide any guidance on how to be able to access the old attachments? Maybe convert attachments on the old system to the filesystem then move them to the new one?

(old osticket)
osTicket (v1.17.4)
Windows 10
IIS

(new osticket)
osTicket (v1.17.6)
Windows 11
Apache

KevinTheJedi

apers

If they are stored in the db and you fully exported and imported the original db then there shouldn’t be any issues unless they are truly corrupted; in which case you’ll have to re-export and re-import. I have a feeling that some of your attachments are stored on the file system and they were not migrated from the old server. Go to Admin Panel > Mange > Plugins and see if you have the Filesystem plugin installed/enabled.

Cheers.

apers

No plug-in. But we figured it out. Had to make sure binary was checked on the export for mysql.

KevinTheJedi

apers

Ahh, gotcha. I always recommend doing a full dump via native mysqldump/mariadb-dump command as it almost always dumps everything as-is. Glad you got this resolved!

Cheers.