Cacti / cacti

Cacti ™
http://www.cacti.net
GNU General Public License v2.0
1.61k stars 399 forks source link

/lib/database.php: SQL Error #1564

Closed interduo closed 6 years ago

interduo commented 6 years ago
2018/04/23  14:22:15 - CMDPHP SQL Backtrace: (/plugins/thold/thold.php: 120  thold_edit)(/plugins/thold/thold.php: 800  db_fetch_assoc)(/lib/database.php: 372  db_fetch_assoc_prepared)(/lib/database.php: 413 cacti_debug_backtrace)
--
2018/04/23 14:22:15 - DBCALL ERROR: SQL Assoc Failed!, Error: You  have an error in your SQL syntax; check the manual that corresponds to  your MariaDB server version for the right syntax to use near ') ORDER BY  dtr.id, td.id' at line 1
2018/04/23 14:22:15 - DBCALL ERROR: SQL Assoc Failed!, Error:1064,  SQL:'SELECT td.id AS thold_id, dtr.id, dtr.data_source_name,  dtr.local_data_id FROM data_template_rrd AS dtr LEFT JOIN thold_data AS  td ON dtr.id=td.data_template_rrd_id WHERE dtr.local_data_id IN (SELECT  DISTINCT dtr.local_data_id FROM data_template_rrd AS dtr LEFT JOIN  graph_templates_item AS gti ON gti.task_item_id=dtr.id LEFT JOIN  graph_local AS gl ON gl.id=gti.local_graph_id WHERE gl.id=) ORDER BY  dtr.id, td.id'

I am using develop on: ii mariadb-server-core-10.1 10.1.26-0+deb9u1 amd64 MariaDB database core server files

cigamit commented 6 years ago

Please open this in the thold plugin github.

interduo commented 6 years ago

OK, I didn't know if It was cacti or thold issue.