Warning beim hinzufügen eines Artikels aus der account_history_info.php zum Warenkorb

[Timm]

Folgendes warning entsteht in 2.0.7.2 sowohl unter PHP 7.4 als auch unter Php 8.1.8

[2022-08-16 21:09:57]	[warning]	[modified]	[pid:30285]	WARNING found for URL: /account_history_info.php?action=add_order_product&order_id=4523&id=18020	{}	{}
[2022-08-16 21:09:57]	[warning]	[modified]	[pid:30285]	1054 - Unknown column 'po.products_options_values_id' in 'field list'<br/><br/>SELECT COUNT(*) AS cnt,                                                    SUM(IF(ISNULL(po.products_options_values_id), 0, 1)) AS checksum                                               FROM orders_products_attributes opa                                          LEFT JOIN products_options_values as pov                                                   ON opa.orders_products_options_values_id = pov.products_options_values_id                                                       AND pov.language_id = 2                                                       AND pov.products_options_values_id > 0                                              WHERE opa.orders_products_id = 18020 in File: /var/www/clients/client1/web1/web/inc/db_functions_mysqli.inc.php on Line: 161	{}	{}
[2022-08-16 21:09:57]	[warning]	[modified]	[pid:30285]	Backtrace #0 - /var/www/clients/client1/web1/web/includes/cart_actions.php called at Line 476	{}	{}
[2022-08-16 21:09:57]	[warning]	[modified]	[pid:30285]	Backtrace #1 - /var/www/clients/client1/web1/web/includes/application_top.php called at Line 306	{}	{}
[2022-08-16 21:09:57]	[warning]	[modified]	[pid:30285]	Backtrace #2 - /var/www/clients/client1/web1/web/account_history_info.php called at Line 19	{}	{}

[Timm]

Im Dev Demoshop ist die Fehlermeldung noch etwas länger.

[2022-08-16 21:25:19]	[warning]	[modified]	[pid:27477]	WARNING found for URL: /account_history_info.php?action=add_order_product&order_id=4&id=4	{}	{}
[2022-08-16 21:25:19]	[warning]	[modified]	[pid:27477]	1054 - Unknown column 'po.products_options_values_id' in 'field list'<br/><br/>SELECT COUNT(*) AS cnt,                                                    SUM(IF(ISNULL(po.products_options_values_id), 0, 1)) AS checksum                                               FROM orders_products_attributes opa                                          LEFT JOIN products_options_values as pov                                                   ON opa.orders_products_options_values_id = pov.products_options_values_id                                                       AND pov.language_id = 2                                                       AND pov.products_options_values_id > 0                                              WHERE opa.orders_products_id = 4 in File: /var/www/clients/client1/web2/web/inc/db_functions_mysqli.inc.php on Line: 161	{}	{}
[2022-08-16 21:25:19]	[warning]	[modified]	[pid:27477]	Backtrace #0 - /var/www/clients/client1/web2/web/includes/cart_actions.php called at Line 476	{}	{}
[2022-08-16 21:25:19]	[warning]	[modified]	[pid:27477]	Backtrace #1 - /var/www/clients/client1/web2/web/includes/application_top.php called at Line 306	{}	{}
[2022-08-16 21:25:19]	[warning]	[modified]	[pid:27477]	Backtrace #2 - /var/www/clients/client1/web2/web/account_history_info.php called at Line 19	{}	{}
[2022-08-16 21:25:19]	[warning]	[modified]	[pid:27477]	WARNING found for URL: /account_history_info.php?action=add_order_product&order_id=4&id=4	{}	{}
[2022-08-16 21:25:19]	[warning]	[modified]	[pid:27477]	Trying to access array offset on value of type bool in File: /var/www/clients/client1/web2/web/includes/cart_actions.php on Line: 478	{}	{}
[2022-08-16 21:25:19]	[warning]	[modified]	[pid:27477]	Backtrace #0 - /var/www/clients/client1/web2/web/includes/application_top.php called at Line 306	{}	{}
[2022-08-16 21:25:19]	[warning]	[modified]	[pid:27477]	Backtrace #1 - /var/www/clients/client1/web2/web/account_history_info.php called at Line 19	{}	{}

[Timm]

Legt man den Artikel/Bestellung von der account.php in den Warenkorb, sieht die Fehlermeldung so aus.

[2022-08-16 21:33:40]	[warning]	[modified]	[pid:27477]	WARNING found for URL: /account.php?action=add_order&order_id=4	{}	{}
[2022-08-16 21:33:40]	[warning]	[modified]	[pid:27477]	Trying to access array offset on value of type bool in File: /var/www/clients/client1/web2/web/includes/cart_actions.php on Line: 394	{}	{}
[2022-08-16 21:33:40]	[warning]	[modified]	[pid:27477]	Backtrace #0 - /var/www/clients/client1/web2/web/includes/application_top.php called at Line 306	{}	{}
[2022-08-16 21:33:40]	[warning]	[modified]	[pid:27477]	Backtrace #1 - /var/www/clients/client1/web2/web/account.php called at Line 19	{}	{}

[Torsten Riemer]

Duplikat von Ticket #2275.

[Timm]

In Ticket #2275 ging es darum, dass die Produkte nicht hinzugefügt wurden. In meinem Ticket geht es um die warnings. Und diese warnings sind im dev Demoshop gestern noch nachstellar gewesen, obwohl Ticket #2275 gefixed wurde.

[Gerhard Waldemair]

Beide Logs sind aus dem Stable Shop und nicht aus dem DEV !

/var/www/clients/client1/web2/ das ist unser Stable Demoshop

[Timm]

Ich hatte gedacht ich hätte es im dev Demoshop getestet, aber da funktioniert es ja zur Zeit gar nicht mehr.

Von der account.php gehts nur bei der ältesten Bestellung, bei allen 3 neueren Bestellungen des Admins schreibt er: "Einige Artikel aus Ihrer Bestellung sind nicht mehr in der gewünschten Konfiguration erhältlich und wurden nicht in den Warenkorb gelegt.", obwohl das im stable Demoshop geht.