[rt-users] binary attachments corrupt
ruz at bestpractical.com
Thu Dec 11 09:49:38 EST 2008
On Thu, Dec 11, 2008 at 1:30 PM, André Esser <kosmo at netcologne.de> wrote:
> Hi there,
> we moved our old RT installation to a new server.
> old installation:
> - Debian 4.0
> - rt-3.4.2
> - MySQL 5.0
> Instead of copying the old binaries to the new server and upgrading them
> we made a fresh installation of the binaries (rt-3.8.1) on the new server (Debian 4.0;
> MySQL 5.0).
> After the upgrade, I had the problems described in UPGRADING.mysql:
> - multiple login requests
> - corrupt binaries
> We fixed the login problems.
> Do I have to apply mysql 4.0->4.1 schema changes to make the binaries work properly,
> although the old rt installation was working with MySQL 5.0?
Yes, you MUST. Yes, it was working.
> I also read about changing the type in the Database:
>> ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL;
This query will be part of applying 4.0-4.1 schema change.
> How can I fix this problem?
> André Esser
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
Best regards, Ruslan.
More information about the rt-users