<div dir="ltr">Hi List,<br><br><br>I have done the same upgrade (3.8.0 -> 3.8.1) with the following steps:<br>1. backup the old rt3 database with mysqldump<br>2. unpack rt-3.8.1.tar.gz<br>3. ./configure and make testdeps (everything was ok)<br>
4. in the source directory of rt 3.8.1 run: perl etc/upgrade/<a href="http://schema.mysql-4.0-4.1.pl">schema.mysql-4.0-4.1.pl</a> db user pass > sql.queries<br>5. run: mysql -u root -p rt3 < sql.queries<br>6. make upgrade<br>
7. /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade<br><br>After that every non iso8859-1 character was wrong (like CF descriptions, comments. etc.).<br>What should I do to solve this problem and what information do you need?<br>
I am using MySQL <a href="http://5.0.51.">5.0.51.</a> With command line mysql client everythins seems good (for example SELECT Subject FROM Tickets WHERE id = $ticket_id_of_a_non_iso_subject_ticket) and everything seems utf8 and not latin1.<br>
<br>If I change the SET NAMES 'utf8' line to SET NAMES 'latin1' in /opt/rt3/lib/RT/Handle.pm, everything is fine again,<br>but I think it's not a good solution.<br><br>Any suggestion?<br><br>Thanks,<br clear="all">
--<br>Bekeny<br>
<br><br><div class="gmail_quote">On Wed, Aug 20, 2008 at 6:44 PM, Geir Skjotskift <span dir="ltr"><<a href="mailto:geir@mnemonic.no">geir@mnemonic.no</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">Emmanuel Lacour wrote:<br>
> Which RT version you used to generate sql.queries? 3.8.0 or 3.8.1?<br>
><br>
> (this bug was reported in list before 3.8.1 and should be fixed as I<br>
> remember).<br>
<br>
</div>Ok. Thanks. I made the assumption that these files had been upgraded as well<br>
and used the ones in the rt3 installation directory. When I used the<br>
ones directly from the tarball everything worked fine. My nordic letters<br>
are back again. :-)<br>
<br>
Thank you so much. You have been of great help.<br>
<div><div></div><div class="Wj3C7c"><br>
-geir<br>
<br>
--<br>
**--**--**--**--**--**--**--**--**--**--**--**--**--**--<br>
Geir Skjotskift, mnemonic AS Email : <a href="mailto:geir@mnemonic.no">geir@mnemonic.no</a><br>
Wergelandsveien 25 Cell : +47 95 10 51 09<br>
N-0167 Oslo, NORWAY Fax : +47 23 20 47 01<br>
Key A2360FF3 availiable at <a href="http://subkeys.pgp.net" target="_blank">subkeys.pgp.net</a><br>
</div></div><br>_______________________________________________<br>
<a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
<br>
Community help: <a href="http://wiki.bestpractical.com" target="_blank">http://wiki.bestpractical.com</a><br>
Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>
<br>
<br>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><br></blockquote></div><br></div>