Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.12.3 available

The official documentation can be found on https://wiki.ocsinventory-ng.org. Read it before asking your question.

Categories

warning apache error.log

Hello,

I have a problem in the apache error logs. I have this error:

DBD::mysql::db do failed: Illegal mix of collations 
(latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for 
operation '=' at 
/usr/local/share/perl/5.24.1/Apache/Ocsinventory/Server/Inventory/Cache.pm
 line 46.

 Can you tell me how to fix it?
 thank you

in OCS Inventory NG server for Unix by (570 points)
Share on
share on gp share on fb share on tw share on li

2 Answers

0 votes
On OCS 2.5 installed on Ubuntu 18.04.1, the perl version is 5.26.1. Perhaps the perl cache handling on older versions has a problem?

It's a nuclear option, but you could backup your database and retry ocs server installation with newer version of perl.
by (170 points)
0 votes
Hi

Just adapt collation on the database. Set all collation to utf8.

Regards

Frank
by (90.2k points)
 
Powered by Question2Answer
...