On Wed, Jul 12, 2006 at 12:21:42PM -0400, Jesse Vincent wrote: > > On Jul 12, 2006, at 12:17 PM, Kaylea Hascall wrote: > > > > >Thank you everyone who has e-mailed me off-list about this. The > >problem in my > >case seemed to lie between mysql, mason, and RT. Changing the > >character set > >seems to resolve it [credit here goes to Freman -- thanks!!]. I'm > >CC'ing the > >other people I've seen report this recently, too. > > > > >Here's the SQL Freman sent me, which solved my problem: > > I _believe_ that only this statement should be necessary if the issue > is what I now believe it to be. > > >ALTER TABLE sessions CHANGE a_session a_session LONGBLOB; > > > > I'd worry a _lot_ about these changes. Setting your characterset to > latin1 with swedish collation isn't going to fix things properly, but > may mask a number of other issues. > We've got a branch of 3.6 with a "proper" fix for these issues (which > I presume only manifest on MySQL 5. Would anyone like to confirm or > deny that?)
No, it happens with MySQL 4.1.19 also. I was hoping that upgrading to 5 would help but it didn't. I wonder if is at all related or similar to the binary attachment corruption I've been having for the last few months as well? I've tried forcing binary character sets, etc. and that didn't seem to help. --- 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: [EMAIL PROTECTED] 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
