Best sellers, and featured products not displaying on main page

[vanhorn_s]

ZC 2.0
PHP 8.1
Using Bootstrap template
redsautorehab.com/2.0/

I just installed 2.0 in a separate directory, merged my previous database with the new one, and am in the process of making sure everything works before switching my main page over, and both the featured products, and the best sellers boxes do not display at all. I am not sure if filezilla missed a file, I messed something up, or this is a bug. Here is what's in the log file:

[12-Apr-2024 08:59:07 America/Boise] Request URI: /2.0/index.php?main_page=index, IP address: ***********, Language id 1
#0 /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php(468): zen_debug_error_handler()
#1 /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php(186): zen_get_products_base_price()
#2 /home1/redsauto/public_html/2.0/includes/modules/bootstrap/centerboxes/featured_products.php(69): zen_get_products_display_price()
#3 /home1/redsauto/public_html/2.0/includes/templates/bootstrap/centerboxes/tpl_modules_featured_products.php(13): require('/home1/redsauto...')
#4 /home1/redsauto/public_html/2.0/includes/templates/bootstrap/templates/tpl_index_default.php(56): require('/home1/redsauto...')
#5 /home1/redsauto/public_html/2.0/includes/modules/pages/index/main_template_vars.php(232): require('/home1/redsauto...')
#6 /home1/redsauto/public_html/2.0/includes/templates/bootstrap/common/tpl_main_page.php(216): require('/home1/redsauto...')
#7 /home1/redsauto/public_html/2.0/index.php(94): require('/home1/redsauto...')
--> PHP Warning: Undefined array key "products_price_w" in /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php on line 468.

[12-Apr-2024 08:59:07 America/Boise] PHP Fatal error: Uncaught TypeError: zen_get_retail_or_wholesale_price(): Argument #2 ($wholesale_pricing_tier) must be of type string, null given, called in /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php on line 468 and defined in /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php:1637
Stack trace:
#0 /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php(468): zen_get_retail_or_wholesale_price('324.9500', NULL)
#1 /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php(186): zen_get_products_base_price('4')
#2 /home1/redsauto/public_html/2.0/includes/modules/bootstrap/centerboxes/featured_products.php(69): zen_get_products_display_price('4')
#3 /home1/redsauto/public_html/2.0/includes/templates/bootstrap/centerboxes/tpl_modules_featured_products.php(13): require('/home1/redsauto...')
#4 /home1/redsauto/public_html/2.0/includes/templates/bootstrap/templates/tpl_index_default.php(56): require('/home1/redsauto...')
#5 /home1/redsauto/public_html/2.0/includes/modules/pages/index/main_template_vars.php(232): require('/home1/redsauto...')
#6 /home1/redsauto/public_html/2.0/includes/templates/bootstrap/common/tpl_main_page.php(216): require('/home1/redsauto...')
#7 /home1/redsauto/public_html/2.0/index.php(94): require('/home1/redsauto...')
#8 {main}
thrown in /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php on line 1637

[12-Apr-2024 08:59:07 America/Boise] Request URI: /2.0/index.php?main_page=index, IP address: 71.223.48.160
--> PHP Fatal error: Uncaught TypeError: zen_get_retail_or_wholesale_price(): Argument #2 ($wholesale_pricing_tier) must be of type string, null given, called in /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php on line 468 and defined in /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php:1637
Stack trace:
#0 /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php(468): zen_get_retail_or_wholesale_price('324.9500', NULL)
#1 /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php(186): zen_get_products_base_price('4')
#2 /home1/redsauto/public_html/2.0/includes/modules/bootstrap/centerboxes/featured_products.php(69): zen_get_products_display_price('4')
#3 /home1/redsauto/public_html/2.0/includes/templates/bootstrap/centerboxes/tpl_modules_featured_products.php(13): require('/home1/redsauto...')
#4 /home1/redsauto/public_html/2.0/includes/templates/bootstrap/templates/tpl_index_default.php(56): require('/home1/redsauto...')
#5 /home1/redsauto/public_html/2.0/includes/modules/pages/index/main_template_vars.php(232): require('/home1/redsauto...')
#6 /home1/redsauto/public_html/2.0/includes/templates/bootstrap/common/tpl_main_page.php(216): require('/home1/redsauto...')
#7 /home1/redsauto/public_html/2.0/index.php(94): require('/home1/redsauto...')
#8 {main}
thrown in /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php on line 1637.

[12-Apr-2024 08:59:07 America/Boise] Request URI: /2.0/index.php?main_page=index, IP address: 71.223.48.160
--> PHP Fatal error: Uncaught TypeError: zen_get_retail_or_wholesale_price(): Argument #2 ($wholesale_pricing_tier) must be of type string, null given, called in /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php on line 468 and defined in /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php:1637
Stack trace:
#0 /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php(468): zen_get_retail_or_wholesale_price('324.9500', NULL)
#1 /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php(186): zen_get_products_base_price('4')
#2 /home1/redsauto/public_html/2.0/includes/modules/bootstrap/centerboxes/featured_products.php(69): zen_get_products_display_price('4')
#3 /home1/redsauto/public_html/2.0/includes/templates/bootstrap/centerboxes/tpl_modules_featured_products.php(13): require('/home1/redsauto...')
#4 /home1/redsauto/public_html/2.0/includes/templates/bootstrap/templates/tpl_index_default.php(56): require('/home1/redsauto...')
#5 /home1/redsauto/public_html/2.0/includes/modules/pages/index/main_template_vars.php(232): require('/home1/redsauto...')
#6 /home1/redsauto/public_html/2.0/includes/templates/bootstrap/common/tpl_main_page.php(216): require('/home1/redsauto...')
#7 /home1/redsauto/public_html/2.0/index.php(94): require('/home1/redsauto...')
#8 {main}
thrown in /home1/redsauto/public_html/2.0/includes/functions/functions_prices.php on line 1637.

[carlwhat]

filezilla never misses anything. it only does what you tell it.

v2.0.0 is well vetted, and a gross bug like this would have been caught. less gross bugs are no doubt out there.

from the looks of it, the database has not been properly updated.

i would look to update the database again.

best.

[vanhorn_s]

That was it. Ran the 2.0 sql, and it fixed that issue.

[mc12345678]

Missed something in the posting information requested by the posting tips. This may or may not be the full solution. From what version was the store being upgraded? If from 1.5.8, then yes only the 2.0.0 upgrade script was needed, but when going from major version to major version the zc_install process is highly advised.