Hello everyone, Unfortunately, this is an error on an old version of Pandora FMS, v5.1SP3 - Build PC150624, but I can't upgrade it just yet. Maybe someone can help regardless. I have a custom report which uses an SQL query, the result of which our client can download and parse as XML. This function has worked for a few months, but now it suddenly doesn't work (viewing the report as HTML is still possible). The problem seems to be that the output has an 'Ö' character (the modules' names contain this, so it's not unexpected), which messes up the XML conversion somehow. This is my SQL query:
SELECT
tagente.nombre AS agent_name,
tagente_modulo.nombre AS module_name,
tagente_estado.datos
FROM tagente, tagente_modulo, tagente_estado WHERE tagente.id_agente = tagente_modulo.id_agente
AND tagente_estado.id_agente_modulo = tagente_modulo.id_agente_modulo AND tagente_modulo.disabled = 0 AND tagente.disabled = 0 AND tagente_modulo.nombre LIKE '%konfidencia%' AND tagente.id_grupo = 508
ORDER BY tagente.nombre ASC
Clicking on "Export to XML" gives the following error in Firefox:
XML Parsing Error: undefined entity
Location: http://127.0.0.1/pandora_console/ajax.php?page=/var/www/html/pandora_console/operation/reporting/reporting_xml&id=16
Line Number 1, Column 526:
(long XML omitted by me) BÖ konfidencia
----------------------------------^
And in Chrome:
error on line 1 at column 526: Entity 'Ouml' not defined
Any ideas what I could try to make this work again? Thanks in advance!
