[rt-users] binary attachments corrupt

[André Esser]

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?

I also read about changing the type in the Database:
> ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL;
(http://www.gossamer-threads.com/lists/rt/users/58098#58098)

How can I fix this problem?




Thanks,
  André
-- 
André Esser