InfotelGLPI / printercounters

Plugin Printercounters for GLPI
http://blogglpi.infotel.com
GNU General Public License v2.0
14 stars 9 forks source link

SQL "LOWER" error #77

Open eduardomozart opened 3 years ago

eduardomozart commented 3 years ago

The following SQL error is shown at 'sql-errors.log':

[2020-11-19 17:56:25] glpisqllog.ERROR: DBmysql::query() in /var/www/clients/client0/web1/web/inc/dbmysql.class.php line 306
  *** MySQL query error:
  SQL: SELECT `id` FROM `glpi_plugin_printercounters_items_recordmodels` WHERE `LOWER(itemtype)` = 'LOWER('Printer')' AND `items_id` = '2'
  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 'Printer')'$
  Backtrace :
  inc/dbmysqliterator.class.php:95
  inc/dbmysql.class.php:857                          DBmysqlIterator->execute()
  inc/commondbtm.class.php:343                       DBmysql->request()
  plugins/printercounters/ajax/infocom.php:42        CommonDBTM->getFromDBByCrit()
  {"user":"168@ispconfig.example.com"}

It should not happen.

No erros is shown at Apache logs.