Cyrillic characters in the ticket thread

mathesonian

I am having an issue with Cyrillic characters in the ticket view.

I checked my database and its utf8_general_ci.

The funny thing is they display correctly if I put them in internal notes or the subject line.

When I enter them in the post reply field they go out correctly in the email; it just displays as junk in the ticket thread.

Here is a picture of how it looks in the ticket view.

blank

mathesonian

Oh and I'm using osticket 1.6ST

mathesonian

I found the cause

It had to do with a mod I installed for using the ckeditor in my text areas earlier

Found (here)

This modified code in viewticket.inc.php was was causing the problem.

<?php

$doc = new DOMDocument();

$doc->loadHTML(($resp_row));

echo $doc->saveHTML();

?>

When I changed it back to the original

<?=Format:($resp_row)?>

It displayed the cyrillic properly in the ticket view.

Since my company has Russian support personal for Russian clients the cyrillic is more important; I would like to have both working though.

Like I said in the original post, it sends the email out properly and the database is storing it right it just gets screwed up in the ticket view.

Anybody have any ideas on how I can get it to display properly in the ticket view? Or should I just take out the ckeditor?

mathesonian

I found the cause

I added a mod to my osticket install to use the ckeditor

When I replaced this code from the mod

<?php

$doc = new DOMDocument();

$doc->loadHTML(($resp_row));

echo $doc->saveHTML();

?>

to the original

<?=Format:($resp_row)?>

it now displays the cyrillic properly in the ticket view.

Does anyone know how I can maintain the rich text and the cyrillic?

mathesonian

Found this bit of code on the php.net domdocument site and it seems to have solved the problem.

http://www.php.net/manual/en/domdocument.loadhtml.php#95251(http://www.php.net/manual/en/domdocument.loadhtml.php#95251)

Changed my original

<?php

$doc = new DOMDocument();

$doc->loadHTML(($resp_row));

echo $doc->saveHTML();

?>

<?

$doc = new DOMDocument();

$doc->loadHTML('<?xml encoding="UTF-8">' . $resp_row);

// dirty fix

foreach ($doc->childNodes as $item)

if ($item->nodeType == XML_PI_NODE)

$doc->removeChild($item); // remove hack

$doc->encoding = 'UTF-8'; // insert proper

echo $doc->saveHTML();

?>