Forum GLPI-Project

naudin

Member

Registered: 2015-08-25

Posts: 8

Error: Column 'itemtype' in where clause is ambiguous

Hello,

We have a lot of warnings :

[2020-09-18 11:13:19] glpisqllog.ERROR: DBmysql::query() in /srv/glpi/inc/dbmysql.class.php line 306
  SQL: SELECT COUNT(*) AS cpt FROM `glpi_items_tickets` INNER JOIN `glpi_tickets` ON (`glpi_items_tickets`.`tickets_id` = `glpi_tickets`.`id`) WHERE `itemtype` = 'Ticket' AND `items_id` = '47862' AND `is_deleted` = '0'
  Error: Column 'itemtype' in where clause is ambiguous

The `glpi_items_tickets` and `glpi_tickets` tables both have an `itemtype` field, can I delete one (on GLPI 9.5.1) and, if so, which one ?

Thanks,