Re: [rt-users] Encoding problem after upgrade

2009-04-08 Thread Jesse Vincent



On Wed, Apr 08, 2009 at 10:00:40AM -0700, Tom Lahti wrote:
> > interface seems slow) - "Ah hah. When you followed the upgrade 
> > instructions, you probably ran upgrade-mysql-schema.pl, which doesn't 
> > actually upgrade the mysql schema. It generates SQL queries to do so. 
> > You have to capture those queries to a file, and then run that file to 
> > actually upgrade the schema."
> 
> In my humble opinion, the name of "upgrade-mysql-schema.pl" is a bit
> deceptive.  We keep running into this over and over again.  I think the
> script should be renamed to "create-mysql-schema-upgrade-queries.pl" or some
> such.

3.8.3 will do spot checks and won't start unless the upgrade was run
correctly. I'm hoping that will help.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Encoding problem after upgrade

2009-04-08 Thread Tom Lahti
> interface seems slow) - "Ah hah. When you followed the upgrade 
> instructions, you probably ran upgrade-mysql-schema.pl, which doesn't 
> actually upgrade the mysql schema. It generates SQL queries to do so. 
> You have to capture those queries to a file, and then run that file to 
> actually upgrade the schema."

In my humble opinion, the name of "upgrade-mysql-schema.pl" is a bit
deceptive.  We keep running into this over and over again.  I think the
script should be renamed to "create-mysql-schema-upgrade-queries.pl" or some
such.

-- 
-- 
   Tom Lahti
   BIT Statement LLC

   (425)251-0833 x 117
   http://www.bitstatement.net/
-- 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Encoding problem after upgrade

2009-04-08 Thread Boris Jordanov
Boris Jordanov написа:
> Hi everyone,
> Today I've upgraded our installation of RT from 3.8.0 to 3.8.2, and a 
> problem arose - much of our RT requests are in cyrillic (mostly utf-8 
> and windows-1251 encoded), and everything cyrillic turned to gibberish. 
> All the existing entries with cyrillic (and not only the subject, the 
> body too) are gibberish via the web interface. Every new request is 
>   
Solved. While waiting for reply I started reading the last posts in 
rt-users. Thanks to Tom Lahti in (Re: [rt-users] RT3 tuning - web 
interface seems slow) - "Ah hah. When you followed the upgrade 
instructions, you probably ran upgrade-mysql-schema.pl, which doesn't 
actually upgrade the mysql schema. It generates SQL queries to do so. 
You have to capture those queries to a file, and then run that file to 
actually upgrade the schema."

I've ran the needed sql and voila - cyrillic text is OK :)

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com