Cacti / plugin_thold

Thold Plugin for Cacti
GNU General Public License v2.0
60 stars 60 forks source link

A DB Cell Failed!, Error: Illegal mix of collations #637

Closed ISekan closed 8 months ago

ISekan commented 8 months ago

Cacti 1.2.25 MariaDB 11.2.1 thold 1.5.2

I got some errors image

TheWitness commented 8 months ago

Please run the convert_tables.php script to correct this issue or since your are at utf8, just write a script to convert the collation/charset's of all the tables to utf8 instead of utf8mb4 (the default).

You can run the following to see which tables are in the wrong character set;

SELECT table_name, table_collation, engine FROM information_schema.tables WHERE table_schema='cacti'

The convert_tables.php script does utf8mb4 by default, if you want utf8, write a script to run this command for each table:

use cacti;
ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8;