Syntax error or access violation: 1253 COLLATION 'latin1_general_ci icinga in Icingaweb2/Graphite

This forum was archived to /woltlab and is now in read-only mode.
  • The Iciangaweb2 shows me the following error, but I set everywhere utf-8 for the databases. Why it's trying to use latin1?


    1. SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8', query was: SELECT COUNT(*) AS cnt FROM icinga_objects AS ho INNER JOIN icinga_hosts AS h ON h.host_object_id = ho.object_id AND ho.is_active = 1 AND ho.objecttype_id = 1 INNER JOIN icinga_hoststatus AS hs ON hs.host_object_id = ho.object_id LEFT JOIN icinga_customvariablestatus AS hcv_check_command ON h.host_object_id = hcv_check_command.object_id AND hcv_check_command.varname = 'check_command' COLLATE latin1_general_ci