Jesse;
my dev system rt-3.6 ,perl, v5.8.8 , apache 2.0.58, dbix 1.43, mysql
5.0.19 on gentoo system , I had this/similar problem with DBD-mysql
3.0003, fixed with moving to DBD-mysql 3.0002 .. no sign of this problem
since..
Roy
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?)
Best,
JEsse
ALTER TABLE ACL CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE Attachments CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE Attributes CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE CachedGroupMembers CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE CustomFieldValues CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE CustomFields CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE GroupMembers CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE Groups CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE Links CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE ObjectCustomFieldValues CONVERT TO CHARACTER SET latin1
COLLATE
latin1_swedish_ci;
ALTER TABLE ObjectCustomFields CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE Principals CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE Queues CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE ScripActions CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE ScripConditions CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE Scrips CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE Templates CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE Tickets CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE Transactions CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE Users CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
ALTER TABLE sessions CONVERT TO CHARACTER SET latin1 COLLATE
latin1_swedish_ci;
delete from sessions;
The suggestions I got also included updating my DBD-mysql driver
(which may
have been necessary, but wasn't sufficient to solve my problem).
-Kaylea
-----------------
Kaylea Hascall (773) 834-4117 or
[EMAIL PROTECTED]
Technology & Scholarly Computing
http://nsit.uchicago.edu/academic
Assistant Director: Academic Technologies NSIT, University of
Chicago
_______________________________________________
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
_______________________________________________
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
_______________________________________________
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
