RT Attachment issue from 3.6.3 to 3.8.1

Hi All,

I’ve upgraded my RT system from 3.6.3 to 3.8.1 successfully (Both versions
are running with MYSQL 5). However I can’t get the 3.8.1 to work with
attachments. All Word,Excel,Jpg and other documents display as garbage.

Then as a test I’ve installed a fresh RT 3.8.1 onto a another system. But
the result is the same with fresh install with fresh database. What am I
doing wrong?

Any help much appriciated.

Cheers,
CP

Here is my SHOW CREATE TABLE Attachments; output.

| Attachments | CREATE TABLE Attachments (
id int(11) NOT NULL AUTO_INCREMENT,
TransactionId int(11) NOT NULL DEFAULT ‘0’,
Parent int(11) NOT NULL DEFAULT ‘0’,
MessageId varchar(160) DEFAULT NULL,
Subject varchar(255) DEFAULT NULL,
Filename varchar(255) DEFAULT NULL,
ContentType varchar(80) DEFAULT NULL,
ContentEncoding varchar(80) DEFAULT NULL,
Content longtext,
Headers longtext,
Creator int(11) NOT NULL DEFAULT ‘0’,
Created datetime DEFAULT NULL,
PRIMARY KEY (id),
KEY Attachments1 (Parent),
KEY Attachments2 (TransactionId),
KEY Attachments3 (Parent,TransactionId)
) ENGINE=InnoDB AUTO_INCREMENT=31223 DEFAULT CHARSET=latin1 |

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.

Can we clarify this? The UPGRADING.mysql seems to allude to the fact
that latin1 should be used instead of utf8. The schema says utf8, but
the docs appear to say something else. I too am having issues with
attachments.

UPGRADING.mysql reads:

  • don’t use utf8 as default mysql’s character set, it’s default in some
    Distributives

If you still want to make upgrade of mysql and RT at once, then you can
do the
following:

  1. Configure mysql 4.1 and newer to use latin1 as default character set
    everywhere.From: rt-users-bounces@lists.bestpractical.com
    [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Emmanuel
    Lacour
    Sent: Wednesday, October 15, 2008 3:18 AM
    To: rt-users@lists.bestpractical.com
    Subject: Re: [rt-users] RT Attachment issue from 3.6.3 to 3.8.1

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.

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 heapsOn Wed, Oct 15, 2008 at 6:17 PM, Emmanuel Lacour elacour@easter-eggs.comwrote:

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@bestpractical.com

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