glpi_monitoring icon indicating copy to clipboard operation
glpi_monitoring copied to clipboard

sql error on acnkloedge + downtimes in search list page

Open ddurieux opened this issue 11 years ago • 1 comments

*** MySQL query error:


SQL: SELECT * FROM glpi_plugin_monitoring_acknowledges WHERE 1 AND glpi_plugin_monitoring_acknowledges.id NOT IN ('0') ORDER BY name

Error: Unknown column 'name' in 'order clause' Backtrace : /usr/local/www/glpi084_test/ajax/dropdownValue.php :457 DBmysql->query() /usr/local/www/glpi084_test/inc/ajax.class.php :612 include() /usr/local/www/glpi084_test/inc/dropdown.class.php :203 Ajax::dropdown() /usr/local/www/glpi084_test/inc/commondbtm.class.php :4431 Dropdown::show() /usr/local/www/glpi084_test/ajax/searchoptionvalue.php :119 CommonDBTM->getValueToSelect() /usr/local/www/glpi084_test/ajax/searchoption.php :94 include() /usr/local/www/glpi084_test/inc/search.class.php :1689 include() /usr/local/www/glpi084_test/inc/search.class.php :62 Search::showGenericSearch() /usr/local/www/glpi084_test/plugins/monitoring/front/acknowledge.php :55 Search::show() /usr/local/www/glpi084_test/plugins/monitoring/front/acknowledge.php

ddurieux avatar Mar 03 '14 01:03 ddurieux

I have fixed for acknowledge, but for downtime there is no search on ID and have name field, it's normal?

ddurieux avatar Mar 03 '14 01:03 ddurieux