No more calculations

[smbld]

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

10.0.23

Plugin version

2.11.3

Bug description

Hello,
After upgrading to GLPI 10.0.23, i got errors in order calculations :
Whan can i do ?

I tried to go back to php 8.1 and 8.2 but it doesn't helped.

Relevant log output

SQL Error "1054": Unknown column 'price_ati` - `price_discounted' in 'SELECT' in 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` = '3716'"
PHP Warning (2): Trying to access array offset on null in /var/www/glpi/plugins/order/inc/order.class.php at line 1490
PHP Warning (2): Trying to access array offset on null in /var/www/glpi/plugins/order/inc/order.class.php at line 1493
PHP Warning (2): Trying to access array offset on null in /var/www/glpi/plugins/order/inc/order.class.php at line 1496
PHP Warning (2): Trying to access array offset on null in /var/www/glpi/plugins/order/inc/order.class.php at line 1507

Page URL

https://glpi.xxxx.fr/glpi/plugins/order/front/order.form.php?id=xx

Steps To reproduce

Uprgade GLPI to 10.0.23 from 10.0.19 with order plugin enabled

Your GLPI setup information

php 8.4.16
apache 2.4.66

Anything else?

No response

[stonebuzz]

Hi @smbld

Can you try this :

• Fix sql request #550

[smbld]

Hi, thank you but there is different error :

SQL Error "1054": Unknown column 'price_ati - price_discounted' in 'SELECT' in 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 = '3718'"

[stonebuzz]

Can you retry with latest commit ?

[smbld]

Hi, you'd be able to check ? Thank you

SQL Error "1054": Unknown column 'price_ati - price_discounted' in 'SELECT' in 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 = '3807'"

[smbld]

Hello,
I upgraded to 2.11.4 but there is errors, can you check ?

SQL Error "1054": Unknown column 'price_ati - price_discounted' in 'SELECT' in 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 = '3718'"
PHP Warning (2): Trying to access array offset on null in /var/www/glpi/plugins/order/inc/order.class.php at line 1490
PHP Warning (2): Trying to access array offset on null in /var/www/glpi/plugins/order/inc/order.class.php at line 1493
PHP Warning (2): Trying to access array offset on null in /var/www/glpi/plugins/order/inc/order.class.php at line 1496
PHP Warning (2): Trying to access array offset on null in /var/www/glpi/plugins/order/inc/order.class.php at line 1507