[rt-users] Problem upgrading from 3.6.1 to 3.8.1

[Ruslan Zakirov]

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 <ocraig at stillsecure.com> wrote:
> On Tue, 2008-08-19 at 17:29 +0200, panu at colorplaza.com 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
>
> ocraig at stillsecure.com
> 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, panu at colorplaza.com 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
Best regards, Ruslan.