You have not applied correctly SQL queries generated by etc/upgrade/schema.mysql-4.0-4.1.pl and described in UPGRADING.mysql
On Fri, Aug 22, 2008 at 7:11 PM, Aaron Hathaway <[EMAIL PROTECTED]> wrote: > Ruslan, > > Here's the output: > > | Table | Create Table > > | Attachments | CREATE TABLE `Attachments` ( > `id` int(11) NOT NULL auto_increment, > `TransactionId` int(11) NOT NULL, > `Parent` int(11) NOT NULL default '0', > `MessageId` varchar(160) default NULL, > `Subject` varchar(255) default NULL, > `Filename` varchar(255) default NULL, > `ContentType` varchar(80) default NULL, > `ContentEncoding` varchar(80) default NULL, > `Content` longtext, > `Headers` longtext, > `Creator` int(11) NOT NULL default '0', > `Created` datetime default NULL, > PRIMARY KEY (`id`), > KEY `Attachments2` (`TransactionId`), > KEY `Attachments3` (`Parent`,`TransactionId`) > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | > > I do see differences between the above and output from a fresh install of > 3.8.1. What's the best way to rectify this? > > Regards, > Aaron > > > Ruslan Zakirov wrote: > > Shouldn't at this point, but there is a chance that later we'll have > an upgrade for some 3.8.x version that wouldn't work correct if your > DB is not changed using the script. > > Could you please send us output of "SHOW CREATE TABLE Attachments;" SQL > command? > > On Fri, Aug 22, 2008 at 3:38 AM, Aaron Hathaway > <[EMAIL PROTECTED]> wrote: >> Helmuth, >> >> >> >> I ran the script after updating from 3.8.0 to 3.8.1. Would that make a >> difference? >> >> >> >> Thanks, >> >> Aaron >> >> >> >> From: Helmuth Ramirez [mailto:[EMAIL PROTECTED] >> Sent: Thursday, August 21, 2008 3:32 PM >> To: Aaron Hathaway; [EMAIL PROTECTED] >> Cc: [email protected] >> Subject: Re: [rt-users] 3.8.1 corrupting attachments >> >> >> >> Did you upgrade the db to 3.8.0, run the script, then update to 3.8.1? >> >> >> ----- Original Message ----- >> From: [EMAIL PROTECTED] >> <[EMAIL PROTECTED]> >> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> >> Cc: [email protected] <[email protected]> >> Sent: Thu Aug 21 17:27:16 2008 >> Subject: Re: [rt-users] 3.8.1 corrupting attachments >> >> James, >> >> Thanks for that tip--I missed that initially. However, even after running >> that script against my DB, I'm still seeing the same attachment >> corruption. >> >> Regards, >> Aaron Hathaway >> >> -----Original Message----- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> Sent: Thursday, August 21, 2008 3:19 PM >> To: Helmuth Ramirez >> Cc: Aaron Hathaway; [email protected]; >> [EMAIL PROTECTED] >> Subject: Re: [rt-users] 3.8.1 corrupting attachments >> >> Perhaps the script itself is poorly named, but the instructions state that >> the 4.0 mysql upgrade script must be run if you are upgrading as it >> changes >> the DB schema. >> >> It's not a script only for those running 4.x.x versions of mysql, it's for >> everyone that's upgrading. >> >> >> James Moseley >> >> >> >> >> >> "Helmuth Ramirez" >> <[EMAIL PROTECTED] >> ompupay.com> To >> Sent by: "Aaron Hathaway" >> rt-users-bounces@ <[EMAIL PROTECTED]> >> lists.bestpractic cc >> al.com [email protected] >> Subject >> Re: [rt-users] 3.8.1 corrupting >> 08/21/2008 05:09 attachments >> PM >> >> >> >> >> >> >> >> >> >> Oh, then I don't have a good answer for you. Sorry L Maybe the list can >> provide some insight. >> >> From: Aaron Hathaway [mailto:[EMAIL PROTECTED] >> Sent: Thursday, August 21, 2008 6:01 PM >> To: Helmuth Ramirez >> Subject: RE: [rt-users] 3.8.1 corrupting attachments >> >> I'm running MySQL 5.0.18, with the default latin1 character set—as I was >> with 3.6.x. >> >> --Aaron >> >> From: Helmuth Ramirez [mailto:[EMAIL PROTECTED] >> Sent: Thursday, August 21, 2008 2:51 PM >> To: Aaron Hathaway; [email protected] >> Subject: RE: [rt-users] 3.8.1 corrupting attachments >> >> Aaron, >> This happened to me when I didn't do the 4.0 to 4.1 MySQL update. >> >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Aaron >> Hathaway >> Sent: Thursday, August 21, 2008 5:35 PM >> To: [email protected] >> Subject: [rt-users] 3.8.1 corrupting attachments >> >> Is anyone else seeing problems with corrupted attachments in 3.8.x? >> From what I can tell, 8-bit characters are getting stripped or >> altered in mime attachments, corrupting the data. >> >> Attached are two PDFs, the original PDF (original.pdf) and the >> post-RT PDF (post-rt.pdf). The latter appears to be blank after RT >> receives it. I'm also seeing corruption of MS Office documents, so >> this may extend to all binary attachments. >> >> I'm happy to submit a bug report if others are experiencing this as >> well. >> >> Cheers, >> >> Aaron Hathaway_______________________________________________ >> 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 >> _______________________________________________ >> 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 >> >> _______________________________________________ >> 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 >> > > > > -- > Best regards, Ruslan. > > > _______________________________________________ > 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 > -- Best regards, Ruslan. _______________________________________________ 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
