Forwarded to rt3.fsck.com where it's now #12278. Will be fixed in 3.8.2 On Wed, Aug 20, 2008 at 3:24 AM, Ole Craig <[EMAIL PROTECTED]> wrote: > On Tue, 2008-08-19 at 17:29 +0200, [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. :-) > > (And of course, you should reload the pristine 3.6.1 database > snapshot and start all over again after editing the sql.queries file. > But you knew that. :-) > > Cheers, > Ole > > - > /Ole Craig > Security Engineer > Team lead, customer support > > [EMAIL PROTECTED] > 303-381-3802 main support line > 303-381-3824 my voicemail > 303-381-3880 fax > > www.stillsecure.com > > > On Tue, 2008-08-19 at 17:29 +0200, [EMAIL PROTECTED] wrote: >> ALTER TABLE Templates MODIFY Content BLOB CHARACTER SET utf8 NULL >> DEFAULT NULL; >> >> I don't see anything wrong with that line. > _______________________________________________ > 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
