Hi! I have some problem with sql in glpi_plugin_racks I can't see any items that i'm add to rack, only available units decreases. After research i found that problem in sql
Following request are broken SELECT `glpi_computermodels`.`name` AS model,`glpi_computermodels`.`id` AS modelid, `glpi_plugin_racks_itemspecifications`.* FROM `glpi_plugin_racks_itemspecifications` LEFT JOIN `glpi_computermodels` ON (`glpi_plugin_racks_itemspecifications`.`model_id` = `glpi_computermodels`.`id`) LEFT JOIN `glpi_computermodels` ON (`glpi_plugin_racks_itemspecifications`.`model_id` = `glpi_computermodels`.`computermodels_id` AND `glpi_plugin_racks_itemspecifications`.`itemtype` = 'ComputerModel') WHERE `glpi_computermodels`.`id` = '24' MySQL said: #1066 - Not unique table/alias: 'glpi_computermodels' I don't understand, what exactly need to be changed and how. glpi GLPI 0.78.3 Bays Management 1.1.0 I would appreciate for any help.
_______________________________________________ Glpi-dev mailing list Glpi-dev@gna.org https://mail.gna.org/listinfo/glpi-dev
