SQL Error on supplier #546
Description
Code of Conduct
- I agree to follow this project's Code of Conduct
Is there an existing issue for this?
- I have searched the existing issues
GLPI Version
11.0.5
Plugin version
2.12.5
Bug description
[2026-02-04 10:11:26] glpi.CRITICAL: *** Uncaught PHP Exception RuntimeException: "MySQL query error: Unknown column 'COUNT(glpi_plugin_order_orders_items.plugin_order_references_id)' in 'field list' (1054) in SQL query "SELECT COUNT(glpi_plugin_order_orders_items.plugin_order_references_id) AS ref, glpi_plugin_order_orders_items.plugin_order_deliverystates_id AS sid, glpi_plugin_order_orders.entities_id FROM glpi_plugin_order_orders_items LEFT JOIN glpi_plugin_order_orders ON (glpi_plugin_order_orders.id = glpi_plugin_order_orders_items.plugin_order_orders_id) WHERE glpi_plugin_order_orders.suppliers_id = '228' AND glpi_plugin_order_orders_items.states_id = '1' AND (glpi_plugin_order_orders.entities_id IN ('1') GROUP BY glpi_plugin_order_orders.entities_id, glpi_plugin_order_orders_items.plugin_order_deliverystates_id"." at DBmysql.php line 405
Backtrace :
./src/DBmysql.php:405
./src/DBmysqlIterator.php:126 DBmysql->doQuery()
./src/DBmysql.php:1074 DBmysqlIterator->execute()
...ketplace/order/inc/order_supplier.class.php:325 DBmysql->request()
...ketplace/order/inc/order_supplier.class.php:512 PluginOrderOrder_Supplier::showDeliveries()
./src/CommonGLPI.php:740 PluginOrderOrder_Supplier::displayTabContentForItem()
./ajax/common.tabs.php:108 CommonGLPI::displayStandardTab()
...Glpi/Controller/LegacyFileLoadController.php:64 require()
./vendor/symfony/http-kernel/HttpKernel.php:181 Glpi\Controller\LegacyFileLoadController->__invoke()
./vendor/symfony/http-kernel/HttpKernel.php:76 Symfony\Component\HttpKernel\HttpKernel->handleRaw()
To do :
Replace into order_supplier.class.php
public static function showDeliveries($suppliers_id)
'SELECT' => [
'COUNT(glpi_plugin_order_orders_items.plugin_order_references_id) AS ref',
'glpi_plugin_order_orders_items.plugin_order_deliverystates_id AS sid',
'glpi_plugin_order_orders.entities_id',
],
by
'SELECT' => [
'COUNT' => 'glpi_plugin_order_orders_items.plugin_order_references_id AS ref',
'glpi_plugin_order_orders_items.plugin_order_deliverystates_id AS sid',
'glpi_plugin_order_orders.entities_id',
],
Relevant log output
Page URL
No response
Steps To reproduce
No response
Your GLPI setup information
No response
Anything else?
No response