Apache+mod_perl with two RTs in different virtual hosts? On Wed, Aug 20, 2008 at 2:03 PM, <[EMAIL PROTECTED]> wrote: >> ALTER TABLE Templates MODIFY Content BLOB CHARACTER SET utf8 NULL >>> DEFAULT NULL; >>> >>> I don't see anything wrong with that line. >> >> Panu - >> Don't know about your other problem, but I ran into this SQL burp in >> four or five different tables while going from 3.6.0 to 3.8.1rc5. MySQL >> doesn't like the CHARACTER SET directive for a field of type BLOB. These >> lines should probably be changed to specify TEXT instead of BLOB (or you >> could remove the 'CHARACTER SET utf8' directive if you know the fields >> in question are used to store binary data instead of text.) >> >> Looking at my database, Templates.Content is definitely TEXT. >> >> Oh, and one other thing to watch out for -- the sql.queries file >> that I got out of running "etc/upgrade/schema.mysql-4.0-4.1.pl" >> contained some destructive transforms that I had to change. Several >> multi-character fields were temporarily transformed into type CHAR, >> which truncated them to a single character. Check your sql.queries file >> (e.g. 'grep " CHAR " sql.queries) and make sure you're not hitting the >> same thing; in my case, one of the fields that was thus truncated was in >> fact this same Templates.Content field. RT's templates don't work so >> good when they consist of only one character. :-) > > Ole, > > thanks a lot, I should have paid more attention to that. I for some > reason mixed up TEXT and CHAR. As the fields the queries wanted to > convert to blob were already blob I just deleted those rows and I now > have probably? a properly upgraded DB. (yes I restored an old dump first :) > > I still have various problems, the cleanslate problem still appear in > the logs with various pages. For example: > > Can't locate object method "CleanSlate" via package > "RT::Action::SendEmail" at > /opt/rt38/bin/../lib/RT/Interface/Web/Handler.pm line 213.\n, referer: > http://xxx.yyy.com/Search/Simple.html > > > I also get internal server error with simple search. And for example > "homepage" has: > > RT::Ticket::ACLEquivalenceObjects Unimplemented in RT::Principal. > (/opt/rt38/bin/../lib/RT/Principal_Overlay.pm line 327) and I can't see > any of my tickets. > > Same kind of error appears on almost all pages. > _______________________________________________ > 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
