Re: [rt-users] Encoding problem after upgrade
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
> 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
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