May be there were some errors or the script generated incorrect queries, then we sure want to see queries the script generates.
On Fri, Aug 22, 2008 at 7:18 PM, Ruslan Zakirov <[EMAIL PROTECTED]> wrote: > 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. > -- 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
