Missing attributes create a ton of logs in PHP 8

[scottcwilson]

This is a pathological situation which should not happen but if someone has been diddling their database, it can.

A product with a missing attribute creates a lot of logs in shopping cart and a white screen on checkout. Is it worth fixing this or should I beef up the audit program to detect this condition?

[scottcwilson]

here's what it looks like in the Attributes Controller in 1.5.8.

[scottcwilson]

Admin Log 1:

[15-Feb-2024 17:05:14 UTC] Request URI: /demo_200_a1/admin/index.php?cmd=attributes_controller&products_filter=595&current_category_id=100, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/admin/attributes_controller.php(1110): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/admin/index.php(11): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "products_options_type" in /Users/scott/sites/demo_200_a1/admin/attributes_controller.php on line 1110.

[15-Feb-2024 17:05:15 UTC] Request URI: /demo_200_a1/admin/index.php?cmd=attributes_controller&products_filter=595&current_category_id=100, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/admin/attributes_controller.php(608): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/admin/attributes_controller.php(1110): translate_type_to_name()
#2 /Users/scott/sites/demo_200_a1/admin/index.php(11): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "" in /Users/scott/sites/demo_200_a1/admin/attributes_controller.php on line 608.

[scottcwilson]

Storefront log 1:

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php(79): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Uninitialized string offset 0 in /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php on line 79.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php(80): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Uninitialized string offset 0 in /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php on line 80.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php(86): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "products_options_name" in /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php on line 86.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php(89): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "options_values_price" in /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php on line 89.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php(90): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "price_prefix" in /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php on line 90.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php(91): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "attributes_image" in /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php on line 91.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(706): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/shipping_estimator.php(91): order->__construct()
#3 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/modalboxes/tpl_shipping_estimator.php(19): require('/Users/scott/si...')
#4 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/templates/tpl_shopping_cart_default.php(211): require('/Users/scott/si...')
#5 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/common/tpl_main_page.php(216): require('/Users/scott/si...')
#6 /Users/scott/sites/demo_200_a1/index.php(94): require('/Users/scott/si...')
--> PHP Warning: Uninitialized string offset 0 in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 706.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(712): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/shipping_estimator.php(91): order->__construct()
#3 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/modalboxes/tpl_shipping_estimator.php(19): require('/Users/scott/si...')
#4 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/templates/tpl_shopping_cart_default.php(211): require('/Users/scott/si...')
#5 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/common/tpl_main_page.php(216): require('/Users/scott/si...')
#6 /Users/scott/sites/demo_200_a1/index.php(94): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "products_options_name" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 712.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(716): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/shipping_estimator.php(91): order->__construct()
#3 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/modalboxes/tpl_shipping_estimator.php(19): require('/Users/scott/si...')
#4 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/templates/tpl_shopping_cart_default.php(211): require('/Users/scott/si...')
#5 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/common/tpl_main_page.php(216): require('/Users/scott/si...')
#6 /Users/scott/sites/demo_200_a1/index.php(94): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "price_prefix" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 716.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(717): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/shipping_estimator.php(91): order->__construct()
#3 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/modalboxes/tpl_shipping_estimator.php(19): require('/Users/scott/si...')
#4 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/templates/tpl_shopping_cart_default.php(211): require('/Users/scott/si...')
#5 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/common/tpl_main_page.php(216): require('/Users/scott/si...')
#6 /Users/scott/sites/demo_200_a1/index.php(94): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "options_values_price" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 717.

[scottcwilson]

Logs 2, 3 on checkout shipping page:

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php(79): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Uninitialized string offset 0 in /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php on line 79.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php(80): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Uninitialized string offset 0 in /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php on line 80.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php(86): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "products_options_name" in /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php on line 86.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php(89): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "options_values_price" in /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php on line 89.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php(90): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "price_prefix" in /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php on line 90.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php(91): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "attributes_image" in /Users/scott/sites/demo_200_a1/includes/modules/pages/shopping_cart/header_php.php on line 91.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(706): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/shipping_estimator.php(91): order->__construct()
#3 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/modalboxes/tpl_shipping_estimator.php(19): require('/Users/scott/si...')
#4 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/templates/tpl_shopping_cart_default.php(211): require('/Users/scott/si...')
#5 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/common/tpl_main_page.php(216): require('/Users/scott/si...')
#6 /Users/scott/sites/demo_200_a1/index.php(94): require('/Users/scott/si...')
--> PHP Warning: Uninitialized string offset 0 in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 706.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(712): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/shipping_estimator.php(91): order->__construct()
#3 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/modalboxes/tpl_shipping_estimator.php(19): require('/Users/scott/si...')
#4 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/templates/tpl_shopping_cart_default.php(211): require('/Users/scott/si...')
#5 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/common/tpl_main_page.php(216): require('/Users/scott/si...')
#6 /Users/scott/sites/demo_200_a1/index.php(94): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "products_options_name" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 712.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(716): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/shipping_estimator.php(91): order->__construct()
#3 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/modalboxes/tpl_shipping_estimator.php(19): require('/Users/scott/si...')
#4 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/templates/tpl_shopping_cart_default.php(211): require('/Users/scott/si...')
#5 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/common/tpl_main_page.php(216): require('/Users/scott/si...')
#6 /Users/scott/sites/demo_200_a1/index.php(94): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "price_prefix" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 716.

[15-Feb-2024 17:08:07 UTC] Request URI: /demo_200_a1/index.php?main_page=shopping_cart, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(717): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/shipping_estimator.php(91): order->__construct()
#3 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/modalboxes/tpl_shipping_estimator.php(19): require('/Users/scott/si...')
#4 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/templates/tpl_shopping_cart_default.php(211): require('/Users/scott/si...')
#5 /Users/scott/sites/demo_200_a1/includes/templates/bootstrap/common/tpl_main_page.php(216): require('/Users/scott/si...')
#6 /Users/scott/sites/demo_200_a1/index.php(94): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "options_values_price" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 717.

[15-Feb-2024 17:10:53 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_shipping, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(712): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_shipping/header_php.php(74): order->__construct()
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "products_options_name" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 712.

[15-Feb-2024 17:10:53 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_shipping, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(716): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_shipping/header_php.php(74): order->__construct()
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "price_prefix" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 716.

[15-Feb-2024 17:10:53 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_shipping, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(717): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_shipping/header_php.php(74): order->__construct()
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "options_values_price" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 717.

[scottcwilson]

Logs 3 and 4 at checkout, white screen occurs.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/db/mysql/query_factory.php(714): trigger_error()
#2 /Users/scott/sites/demo_200_a1/includes/classes/db/mysql/query_factory.php(659): queryFactory->show_error()
#3 /Users/scott/sites/demo_200_a1/includes/classes/db/mysql/query_factory.php(299): queryFactory->set_error()
#4 /Users/scott/sites/demo_200_a1/includes/functions/database.php(130): queryFactory->Execute()
#5 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1230): zen_db_perform()
#6 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#7 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#8 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Fatal error: MySQL error 1366: Incorrect decimal value: '' for column 'options_values_price' at row 1 :: INSERT INTO orders_products_attributes (orders_id, orders_products_id, products_options, products_options_values, options_values_price, price_prefix, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_discounted, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, products_options_id, products_options_values_id, products_prid) VALUES ('38307', '124141', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '595:56b44d00a21f140eb825e0f835fd9138') ==> (as called by) /Users/scott/sites/demo_200_a1/includes/functions/database.php on line 130 <== in /Users/scott/sites/demo_200_a1/includes/classes/db/mysql/query_factory.php on line 714.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(712): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(48): order->__construct()
#3 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#4 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "products_options_name" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 712.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(716): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(48): order->__construct()
#3 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#4 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "price_prefix" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 716.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(717): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/classes/order.php(154): order->cart()
#2 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(48): order->__construct()
#3 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#4 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "options_values_price" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 717.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1203): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "products_options_name" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1203.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1207): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "options_values_price" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1207.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1208): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "price_prefix" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1208.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1209): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "product_attribute_is_free" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1209.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1210): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "products_attributes_weight" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1210.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1211): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "products_attributes_weight_prefix" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1211.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1212): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "attributes_discounted" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1212.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1213): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "attributes_price_base_included" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1213.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1214): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "attributes_price_onetime" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1214.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1215): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "attributes_price_factor" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1215.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1216): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "attributes_price_factor_offset" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1216.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1217): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "attributes_price_factor_onetime" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1217.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1218): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "attributes_price_factor_onetime_offset" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1218.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1221): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "attributes_price_words" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1221.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1222): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "attributes_price_words_free" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1222.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1223): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "attributes_price_letters" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1223.

[15-Feb-2024 17:13:12 UTC] Request URI: /demo_200_a1/index.php?main_page=checkout_process, IP address: ::1, Language id 1
#0 /Users/scott/sites/demo_200_a1/includes/classes/order.php(1224): zen_debug_error_handler()
#1 /Users/scott/sites/demo_200_a1/includes/modules/checkout_process.php(114): order->create_add_products()
#2 /Users/scott/sites/demo_200_a1/includes/modules/pages/checkout_process/header_php.php(13): require('/Users/scott/si...')
#3 /Users/scott/sites/demo_200_a1/index.php(35): require('/Users/scott/si...')
--> PHP Warning: Undefined array key "attributes_price_letters_free" in /Users/scott/sites/demo_200_a1/includes/classes/order.php on line 1224.

[scottcwilson]

Root cause: some rows in the products_attributes have options_id = 0.

I will just delete those rows; they refer to attributes which apparently no longer exist.

[scottcwilson]

Migrating to discussion; don't think this is worth fixing at the moment.