[rt-users] binary attachment corruption?

Ruslan Zakirov ruslan.zakirov at gmail.com
Wed Jul 26 16:49:44 EDT 2006


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.


On 7/27/06, Covington, Chris <Chris.Covington at plusone.com> wrote:
> On Thu, Jul 20, 2006 at 01:06:01PM -0400, Jesse Vincent wrote:
> >
> >
> >
> > On Thu, Jul 20, 2006 at 12:54:36PM -0400, Covington, Chris wrote:
> > > On Wed, Jun 07, 2006 at 10:42:23AM -0400, Covington, Chris wrote:
> > > > Has anyone gotten this sorted out?  I've upgraded to mysql 5.0.22 and I
> > > > still have this problem, so it must be in the configuration somewhere.
> > > > I've tried starting mysql with --character-set-server=binary and
> > > > --default-character-set=binary and the attachments are still corrupted
> > > > (with new tickets).
> > >
> > > I guess what I wrote in June says it all.  Still having the problem with
> > > 3.6.0 where any and all new binary attachments are corrupted (nothing to
> > > do with dumps).
> >
> >
> > I haven't been able to replicate this at all.
>
> How can I help reproducing this for you?
>
> ---
> Chris Covington
> IT
> Plus One Health Management
> 75 Maiden Lane Suite 801
> NY, NY 10038
> 646-312-6269
> http://www.plusoneactive.com
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> 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
>
>
> We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
>


-- 
Best regards, Ruslan.



More information about the rt-users mailing list