Hello,

We're still facing some problems but have solved some others. Here's the current status:

Text with spanish characters were truncated from tickets, event attachments were gone. After running REPARE TABLE to the database tables, part of the problem was solved but our queues named with spanish characters still show wrong :(

Any hint towards resolving this issue is much appreciated, here's the environment:

openSUSE 11.2 "Emerald" - Kernel "
MySQL 5.1.36-log
Perl 5.10.0 (linux)
Apache/2.2.13
mod_perl/2.0.4
collation on database: utf8_general_ci
DefaultCharSet on SysConfig is iso-8859-1

Thanks,

Leonardo Certuche
www.itconsultores.com.co


2010/7/1 Leonardo Certuche <leonardo.certuche@itconsultores.com.co>
Hi there,

Last night we migrated our production server from 2.4.5 to 2.4.7. Since both are 2.4.* we didn't run any DBUpdate-to-2.4-post* script, just installed 2.4.7 on a fresh server (opensuse 11.2), moved the database from the old one (opensuse 10.3), moved all customizations and started the new server. Everything seemed fine at first but today we're facing two issues:
  1. Special characters from spanish like ñ, á, é, í, ó, ú are not correctly shown on the front end. For instance there is a queue called Campañas which looks perfect on phpmyadmin but it's shown on the front end as Campañas. Charset on the database remains the same of the old server (utf8_general_ci) while DefaultCharset on sysconfig was iso-8859-1. I've changed it to variations such as iso-8859-15 (which appears as the a_content_type of most articles) but still no luck :(
  2. We're getting the following error randomly when trying to create new tickets:
    Error: Can't get ArticleID from INSERT!
    I was googling about this error but there are only old entries like this: http://bugs.otrs.org/show_bug.cgi?id=319
Thanks in advance for any help.

Leonardo Certuche
www.itconsultores.com.co