You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2020-09-18 11:29:12

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,

Offline

Board footer

Powered by FluxBB