DBD::mysql::db do failed: Illegal mix of collations about ocsinventory-server HOT 2 CLOSED

Hello, as your other issue i cannot reproduce this bug :

If you're sure that is a bug and not a configuration / installation problems you should re-post one issue with more details.
See this issue answer for more details on what you need to post for a quick and accurate reply => #7 .

Sorry for inconvenience you met.
Regards, Gilles Dubois.

from ocsinventory-server.

Hi,
I got the exact same error

I didn't have too much time to troubleshoot which table was causing the problem so I looked for all tables containing the "cache" keyword since it is related to the cache.pm file.

• groups_cache
• hardware_osname_cache
• registry_name_cache
• registry_regvalue_cache
• softwares_name_cache

I looked for the collation field setting with
mysql> show full columns from hardware_osname_cache;
| Field | Type | Collation | ...
| ID | ...
| OSNAME | varchar(255) | latin1_swedish_ci | ...

and converted them to utf8
ALTER TABLE hardware_osname_cache MODIFY OSNAME VARCHAR(255) COLLATE utf8_general_ci;
ALTER TABLE registry_name_cache MODIFY NAME VARCHAR(255) COLLATE utf8_general_ci;
ALTER TABLE registry_regvalue_cache MODIFY REGVALUE VARCHAR(255) COLLATE utf8_general_ci;
ALTER TABLE softwares_name_cache MODIFY NAME VARCHAR(255) COLLATE utf8_general_ci;

Errors in logs have gone away.
Those fields must have been created with your default Mysql collation property I suppose.

David

from ocsinventory-server.