cigamit
commented
7 years ago This was resolved by resolving a Cacti issue in lib/html.php. Thanks for reporting.
Closed JorisFRST closed 7 years ago
cigamit
commented
7 years ago This was resolved by resolving a Cacti issue in lib/html.php. Thanks for reporting.
Cacti 1.1.2 - plugin_hmib 6ee17ce
Not sure if related : "'Please Select Data Query First from Console->Settings->Host Mib First". greyed out graph button.
2017-04-14 13:14:29 - CMDPHP SQL Backtrace: (/plugins/hmib/hmib.php: 90 hmib_view_graphs)(/plugins/hmib/hmib.php: 2745 html_graph_preview_filter)(/lib/html_graph.php: 157 html_host_filter)(/lib/html.php: 1580 get_allowed_devices)(/lib/auth.php: 1436 db_fetch_cell)(/lib/database.php: 201 db_fetch_cell_prepared)(/lib/database.php: 246 cacti_debug_backtrace) 2017-04-14 13:14:29 - CMDPHP SQL Backtrace: (/plugins/hmib/hmib.php: 90 hmib_view_graphs)(/plugins/hmib/hmib.php: 2745 html_graph_preview_filter)(/lib/html_graph.php: 157 html_host_filter)(/lib/html.php: 1580 get_allowed_devices)(/lib/auth.php: 1419 db_fetch_assoc)(/lib/database.php: 320 db_fetch_assoc_prepared)(/lib/database.php: 359 cacti_debug_backtrace) 2017-04-14 13:14:29 - 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 'WHERE h.id IN (12,11,8,1) HAVING (user0 IS NULL OR (user1 IS NULL OR user2 I' at line 1 2017-04-14 13:14:29 - DBCALL ERROR: SQL Assoc Failed!, Error:1064, SQL:"SELECT h1. FROM host AS h1 INNER JOIN ( SELECT DISTINCT id FROM ( SELECT h., uap0.user_id AS user0, uap1.user_id AS user1, uap2.user_id AS user2 FROM host AS h LEFT JOIN graph_local AS gl ON h.id=gl.host_id LEFT JOIN graph_templates_graph AS gtg ON gl.id=gtg.local_graph_id LEFT JOIN graph_templates AS gt ON gt.id=gl.graph_template_id LEFT JOIN host_template AS ht ON h.host_template_id=ht.id LEFT JOIN user_auth_perms AS uap0 ON (gl.id=uap0.item_id AND uap0.type=1 AND uap0.user_id=1) LEFT JOIN user_auth_perms AS uap1 ON (gl.host_id=uap1.item_id AND uap1.type=3 AND uap1.user_id=1) LEFT JOIN user_auth_perms AS uap2 ON (gl.graph_template_id=uap2.item_id AND uap2.type=4 AND uap2.user_id=1) WHERE WHERE h.id IN (12,11,8,1) HAVING (user0 IS NULL OR (user1 IS NULL OR user2 IS NULL)) ) AS rs1 ) AS rs2 ON rs2.id=h1.id ORDER BY description " 2017-04-14 13:14:16 - CMDPHP SQL Backtrace: (/plugins/hmib/hmib.php: 90 hmib_view_graphs)(/plugins/hmib/hmib.php: 2745 html_graph_preview_filter)(/lib/html_graph.php: 157 html_host_filter)(/lib/html.php: 1580 get_allowed_devices)(/lib/auth.php: 1436 db_fetch_cell)(/lib/database.php: 201 db_fetch_cell_prepared)(/lib/database.php: 246 cacti_debug_backtrace) 2017-04-14 13:14:16 - CMDPHP SQL Backtrace: (/plugins/hmib/hmib.php: 90 hmib_view_graphs)(/plugins/hmib/hmib.php: 2745 html_graph_preview_filter)(/lib/html_graph.php: 157 html_host_filter)(/lib/html.php: 1580 get_allowed_devices)(/lib/auth.php: 1419 db_fetch_assoc)(/lib/database.php: 320 db_fetch_assoc_prepared)(/lib/database.php: 359 cacti_debug_backtrace) 2017-04-14 13:14:16 - 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 'WHERE h.id IN (12,11,8,1) HAVING (user0 IS NULL OR (user1 IS NULL OR user2 I' at line 1 2017-04-14 13:14:16 - DBCALL ERROR: SQL Assoc Failed!, Error:1064, SQL:"SELECT h1. FROM host AS h1 INNER JOIN ( SELECT DISTINCT id FROM ( SELECT h., uap0.user_id AS user0, uap1.user_id AS user1, uap2.user_id AS user2 FROM host AS h LEFT JOIN graph_local AS gl ON h.id=gl.host_id LEFT JOIN graph_templates_graph AS gtg ON gl.id=gtg.local_graph_id LEFT JOIN graph_templates AS gt ON gt.id=gl.graph_template_id LEFT JOIN host_template AS ht ON h.host_template_id=ht.id LEFT JOIN user_auth_perms AS uap0 ON (gl.id=uap0.item_id AND uap0.type=1 AND uap0.user_id=1) LEFT JOIN user_auth_perms AS uap1 ON (gl.host_id=uap1.item_id AND uap1.type=3 AND uap1.user_id=1) LEFT JOIN user_auth_perms AS uap2 ON (gl.graph_template_id=uap2.item_id AND uap2.type=4 AND uap2.user_id=1) WHERE WHERE h.id IN (12,11,8,1) HAVING (user0 IS NULL OR (user1 IS NULL OR user2 IS NULL)) ) AS rs1 ) AS rs2 ON rs2.id=h1.id ORDER BY description "