[EMAIL PROTECTED] wrote: > All, > >> Hello, Chris. >> Could you backup your DB, and run next to SQL queries? >> ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL; >> >> Then check if you could binary attachments without problems and report >> back. >> This query is safe but anyway I would suggest you to backup data. > > Running this fixed my attachment corruption problem, thanks! > > I think the Gentoo Installation Guide mentions changing some aspects of the > RT database in the comments section near the end of the document. This may > be why both Jeremy and I had this problem (we're both running on GenToo). I > followed the threads listed in that Guide to finally get it working, but I > honestly don't remember everything that was tweaked along the way. > > Perhaps someone more knowledgeable could change the GentooInstallGuide to > reflect the above fix for future users?
Changing the Content type in the Attachments table from LONGTEXT to LONGBLOB via ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL; worked for me also. I observe the following in /opt/rt3/etc/schema.mysql: CREATE TABLE Attachments ( . . Content LONGTEXT NULL , . . ) TYPE=InnoDB; Is this an error in the RT3 MySQL schema? Running Gentoo and RT 3.6.1 Regards, David _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com