[rt-users] RT Attachment issue from 3.6.3 to 3.8.1

[Chamara Peris]

Hi Guys,

Yes the output is from a upgrade from 3.6.3. I've managed to get it going by
running the script "schema.mysql-4.0-4.1.pl". Maybe the script named
incorrectly?. Was bit confusing

All good. Thanks heaps

On Wed, Oct 15, 2008 at 6:17 PM, Emmanuel Lacour <elacour at easter-eggs.com>wrote:

> On Wed, Oct 15, 2008 at 01:34:28PM +1100, Chamara Peris wrote:
> > Hi All,
> > ) ENGINE=InnoDB AUTO_INCREMENT=31223 DEFAULT CHARSET=latin1 |
>
> Is this the statement after upgrade or on your fresh 3.8.1 install?
>
> RT >= 3.8.1 uses UTF-8, you seems to have the wrong charset.
>
> If it's the stetement after upgrade, then you missed reading
> UPGRADING.mysql.
>
> If it's a fresh 3.8.1 install, how did you create your tables? If using
> rt-setup-database, this should be UTF-8, if using somethink like "cat
> schema.mysql | mysql rt", then this would be because you're default is
> latin1.
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081016/361cbb0e/attachment.htm>