Re: [otrs] Update OTRS 2.3.4 -> 2.4.3 - DB convert latin1 -> utf8

Did you run the sql-update scripts as described in section 6 in the install FAQ - http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ItemID=301 ? I had the same problem with an upgrade from 2.3.4 to 2.4.2. After I ran the scripts, the tickets had all the information intact. --Lars From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Marco Vannini Sent: 20. august 2009 15:22 To: User questions and discussions about OTRS. Subject: Re: [otrs] Update OTRS 2.3.4 -> 2.4.3 - DB convert latin1 -> utf8 I had the same problem (content of the ticket empty), for me wasn't a charset problem. I've restored a previuosly backed up otrs db and restarted with step 1 of migration. After that data was correct either if 4/5 tables resulted to be latin. After a period of time overwathing the system just to be sure that it was all ok, I've used phpmyadmin to assign utf_general_ci to the tables that weren't so without problems (obviusoly there should be mysql manual command to do that but I'm a lazy boy ;) ) MV On Thu, Aug 20, 2009 at 3:04 PM, wrote: Hi there, I have a little problem. I´m running OTRS 2.3.4 without ITSM and want to upgrade it to the new 2.4.3 with ITSM. Just in case that there are some problems, I´ve set up a test enviroment. The Upgrade worked fine for me, following the instruktion in the Upgrade file. But the tickets are not shown Properly in the ticket system. I just get to see the ticket number but the content is gone. When I look in the Admin Support Assessment I get the error message that the charset is latin1 instead of utf8. Now I would like to know if there is a possibility to convert the DB to utf8 without loosing all the tickets in the system. Mit freundlichen Grüßen / Kind regards Markus Moj Technik TimoCom Soft- und Hardware GmbH In der Steele 2 D-40599 Düsseldorf Tel: +49 211 88 26 80 14 Fax: +49 211 88 26 70 14 eMail: MMoj@TimoCom.com www.TimoCom.com Geschäftsführer: Jens Thiermann, Gunther Matzaitis Amtsgericht Düsseldorf, HRB 34489 --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ CONFIDENTIALITY: This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium. CONFIDENTIALITY: This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium.