GLPI 11 add order #489
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.01
Plugin version
2.12.1
Bug description
When added an order, gives me this error:
COST:
An unexpected error occurred
With Debug activated:
MySQL query error: Unknown column 'price_ati-price_discounted' in 'SELECT' (1054) in SQL query "SELECT SUM(price_ati) AS priceTTC, SUM(price_discounted) AS priceHT, SUM(price_ati`` - ``price_discounted) AS priceTVA FROM glpi_plugin_order_orders_items WHERE plugin_order_orders_id = '2'".
In ./src/DBmysql.php(371)
#0 ./src/DBmysqlIterator.php(123): DBmysql->doQuery()
#1 ./src/DBmysql.php(1040): DBmysqlIterator->execute()
#2 ./marketplace/order/inc/order_item.class.php(1364): DBmysql->request()
#3 ./marketplace/order/inc/order.class.php(1463): PluginOrderOrder_Item->getAllPrices()
#4 ./src/CommonGLPI.php(683): PluginOrderOrder->showForm()
#5 ./ajax/common.tabs.php(108): CommonGLPI::displayStandardTab()
#6 ./src/Glpi/Controller/LegacyFileLoadController.php(64): require('...')
#7 ./vendor/symfony/http-kernel/HttpKernel.php(181): Glpi\Controller\LegacyFileLoadController->__invoke()
#8 ./vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#9 ./vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#10 ./public/index.php(70): Symfony\Component\HttpKernel\Kernel->handle()
#11 {main}
Relevant log output
Page URL
No response
Steps To reproduce
Create order, and filled the required fields
Your GLPI setup information
No response
Anything else?
No response