i got an error message "PHP Fatal error: 1055:Expression #1......"

[sungmo]

ZC 1.5.1
PHP 5.6

i moved hosting company.

However, i can not see bottom of product pages.

so i checked log file.

there is an error message like below.

how can i solve this problem without ZC upgrade.

thanks.

[19-Jul-2019 03:23:15 UTC] PHP Fatal error: 1055:Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'thefollo_db.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by :: select p.products_id, p.products_image
from orders_products opa, orders_products opb, orders o, products p
where opa.products_id = '111'
and opa.orders_id = opb.orders_id
and opb.products_id != '111'
and opb.products_id = p.products_id
and opb.orders_id = o.orders_id
and p.products_status = 1
group by p.products_id
order by o.date_purchased desc
limit 3 in /home/thefollow/public_html/includes/classes/db/mysql/query_factory.php on line 120

[balihr]

You'll need to contact your host and ask them to disable ONLY_FULL_GROUP_BY in your MySQL config files.
You're probably using MySQL 5.7.5 or higher which has this enabled by default, and your previous server was probably running an older version on MySQL.

Unless you have root access and are comfortable using console, this is something for your host to change for you.

[sungmo]

You'll need to contact your host and ask them to disable ONLY_FULL_GROUP_BY in your MySQL config files.
You're probably using MySQL 5.7.5 or higher which has this enabled by default, and your previous server was probably running an older version on MySQL.

Unless you have root access and are comfortable using console, this is something for your host to change for you.

Thank you so much

you solved my big problem...:)

Thanks again balihr

Have a good one.

[greenman161]

I have a similar issue, but in my case the message is displaying on the sidebar of the shopping cart, not in the log file, even after the host has "disabled ONLY_FULL_GROUP_BY in your MySQL config files."

Any other ideas?

Zen Cart v1.3.9g/v1.3.9g
MySQL 5.7.26
PHP 7.27
PHP 4.8.5


David

[lat9]

I have a similar issue, but in my case the message is displaying on the sidebar of the shopping cart, not in the log file, even after the host has "disabled ONLY_FULL_GROUP_BY in your MySQL config files."

Any other ideas?

Zen Cart v1.3.9g/v1.3.9g
MySQL 5.7.26
PHP 7.27
PHP 4.8.5


David

You're not going to want to hear this, but perhaps upgrading to a version of Zen Cart that will actually run under those newer versions of MySQL and PHP? v139g is coming up on its 9th birthday.

[greenman161]

Thanks.

Will run the upgrade.

[dbltoe]

Best to follow the instructions at https://www.zen-cart.com/entry.php?3...d-of-upgrading