SQL Error on supplier

[tsmr]

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