Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mysql 5.7 warning under default setting #1

Open
alx542 opened this issue Apr 22, 2019 · 0 comments
Open

mysql 5.7 warning under default setting #1

alx542 opened this issue Apr 22, 2019 · 0 comments

Comments

@alx542
Copy link

alx542 commented Apr 22, 2019

for d6lts ubercart 6.x-2.16

Not sure if this warning stops the code from working but I get this under mysql 5.7 on cpanel in php 5.6 ... The warming can be avoided by removing strict mode in my.cnf

(add line
sql_mode=""
)

and restart mysql.

But this might not be an option for everyone or desirable?

=======
http://mysite.com/cart/checkout

user warning: Expression #1 of ORDER BY clause is not in SELECT list, references column 'MYDBNAME.uc_orders.created' which is not in SELECT list; this is incompatible with DISTINCT query: SELECT DISTINCT billing_first_name AS first_name, billing_last_name AS last_name, billing_phone AS phone, billing_company AS company, billing_street1 AS street1, billing_street2 AS street2, billing_city AS city, billing_zone AS zone, billing_postal_code AS postal_code, billing_country AS country FROM uc_orders WHERE uid = 1 AND order_status IN ('pending', 'processing', 'payment_received', 'completed') ORDER BY created DESC in /home/MYWEBROOT/sites/all/modules/ubercart/uc_store/uc_store.module on line 1498.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant