JSON/PP/pp.pm line 468

[lpilkington]

Dear all,
When switching language, or replying to a ticket after switching language for a user I get the following error.
Is anyone able to help or point me in the right direction.

Many thanks in advance for any guidance, it will be very much appreciated.
Regards
Lee

Server error!

The server encountered an internal error and was unable to complete your request.

Error message:
Malformed UTF-8 character (fatal) at /opt/otrs/Kernel/cpan-lib/JSON/PP.pm line 468. ,

If you think this is a server error, please contact the webmaster.

Error 500

tick-it.msxi-euro.com
Mon Aug 12 14:11:13 2013
Apache/2.2.10 (Linux/SUSE)

[ndhvu275]

Hi,

I'm facing this issue as well when searching customer in AgentTicketPhone screen, customer data is from external database MS SQL. Did you solve it? Please share to me some idea.
I'm using OTRS 3.3.x, the package JSON::XS is version 2.3
The error maybe JSON cannot understand some strange characters in customer data. I reproduced as below

Error AJAX when searching customer. Using Firebug

12-13-2013 10-11-44 AM.png

Httpd error log

12-13-2013 10-09-18 AM.png

Could you help me this error. Thanks

Vu Nguyen

[jojo]

ensure that your database is utf8

[ndhvu275]

ensure that your database is utf8

What happen if my DB is not utf-8? Maybe I have to disable charset utf-8 in customer backend file in picture. That means it is acceptable for all kinds of charset in incoming data, is it correct?

12-13-2013 11-12-07 AM.png

Thanks

Vu Nguyen

[reneeb]

If the database is not utf-8, you have to declare what charset it uses!

[ndhvu275]

If the database is not utf-8, you have to declare what charset it uses!

Actually I cannot access to customer data. So I just disabled charset like above, my system is running OK with data is utf-8 and not utf-8. But it maybe impact to others I never know. I would like to ask "Is it acceptable for all kinds of charset in incoming data?"

Many thanks

Vu Nguyen