Images corrupted after upgrade to 3.8.0

RT Users
1

Hi,

Just recently have updated to RT-3.8.0 unfortuately it appears that all
images whom were stored in the database have been slightly corrupted.
However all other binary type attachments seem to be ok.

I have run both the schema upgrade to upgrade the database objects along
with the instructions found in UPGRADING.mysql. Any thoughts on why this
might be? database was dumped with default-character-set=binary.

Regards,

*Aaron Guise
07 854 7824
027 212 6638
aaron@guise.net.nz

2

Correction, it actually appears to have broken the majority of binary
attachments. There are only a couple that I have found to work.On Mon, Jan 12, 2009 at 12:19 AM, Aaron Guise aaron@guise.net.nz wrote:

Hi,

Just recently have updated to RT-3.8.0 unfortuately it appears that all
images whom were stored in the database have been slightly corrupted.
However all other binary type attachments seem to be ok.

I have run both the schema upgrade to upgrade the database objects along
with the instructions found in UPGRADING.mysql. Any thoughts on why this
might be? database was dumped with default-character-set=binary.

Regards,

*Aaron Guise
07 854 7824
027 212 6638
aaron@guise.net.nz
*

3

Problem is resolved. I re-dumped the sql for attachments. then dumped all
other tables separately too. completed a new “make install” and “make
initialize-database” imported all the other table data and then imported the
attachments.

This has been bothering me a while so is great to be finally resolved, so
can upgrade our production server.On Mon, Jan 12, 2009 at 12:19 AM, Aaron Guise aaron@guise.net.nz wrote:

Hi,

Just recently have updated to RT-3.8.0 unfortuately it appears that all
images whom were stored in the database have been slightly corrupted.
However all other binary type attachments seem to be ok.

I have run both the schema upgrade to upgrade the database objects along
with the instructions found in UPGRADING.mysql. Any thoughts on why this
might be? database was dumped with default-character-set=binary.

Regards,

*Aaron Guise
07 854 7824
027 212 6638
aaron@guise.net.nz
*