error after server upgrade

[chadlly2003]

Zencart 1.5.8
php 8.1

I just upgrade my server and I am getting a weird error. What would cause this?



[22-Aug-2023 15:17:08 America/New_York] Request URI: /, IP address: 73.125.60.145
#0 [internal function]: zen_debug_error_handler()
#1 /home/xxx/public_html/includes/classes/db/mysql/query_factory.php(667): trigger_error()
#2 /home/xxx/public_html/includes/classes/db/mysql/query_factory.php(634): queryFactory->show_error()
#3 /home/xxx/public_html/includes/classes/db/mysql/query_factory.php(275): queryFactory->set_error()
#4 /home/xxx/public_html/includes/modules/pages/index/header_php.php(133): queryFactory->Execute()
#5 /home/xxx/public_html/index.php(41): require('/home/xxx/...')
--> PHP Fatal error: 1055:Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxx_154.s.status' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by :: SELECT DISTINCT p.products_id, p.products_type, p.master_categories_id,
p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1,
s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price,
p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping,
p.products_qty_box_status FROM products p LEFT JOIN specials s on p.products_id = s.products_id LEFT JOIN products_description pd on p.products_id = pd.products_id LEFT JOIN manufacturers m on p.manufacturers_id = m.manufacturers_id JOIN products_to_categories p2c on p.products_id = p2c.products_id WHERE p.products_status = 1
and pd.language_id = '1'
and p2c.categories_id = '0' GROUP BY p.products_id ==> (as called by) /home/xxx/public_html/includes/modules/pages/index/header_php.php on line 133 <== in /home/xxx/public_html/includes/classes/db/mysql/query_factory.php on line 667.

[torvista]

>this is incompatible with sql_mode=only_full_group_by

The database is now using this mode "only_full_group_by", or trying to. Maybe it's the default setting for this version of the database type (mariadb?).
Remove/override this setting for an instant fix, then implement it on your dev server to fix the code properly.

[chadlly2003]

You hit it right on the head "only_full_group_by"

I made the server change and all is good