Photo Cart is retired. Check out Sytist.

Mysql Error: Expression #1 Of Select...

 
Please log in or Create an account to post or reply to topics.
 
Katie
3 posts
Thu Oct 18, 18
7:29 PM
We migrated our entire site, which included Sytist and Photocart, to a dedicated server with the same host. We've had no problems with Sytist since the migration, but we're getting MySQL error in Photocart.

This is the error in the admin area:
MYSQL ERROR: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pearlspi_galleries.pc_gallery_stats.gs_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Query: SELECT *,DATE_ADD(gs_date, INTERVAL -9 HOUR) AS gs_date FROM WHERE DATE_FORMAT(gs_date, '%Y-%m-%d')='2018-10-19' GROUP BY gs_session

We get a similar error when viewing the site and attempting to choose an option in the shopping cart:
MYSQL ERROR: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pearlspi_galleries.pc_cart.cart_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Query: SELECT *, SUM(cart_qty) AS total FROM WHERE cart_sp_id='140' AND cart_sess='9621304320180211120134' AND cart_pic_id='1382891' GROUP BY cart_sp_id

I gather something is not right with the database, but I don't even know where to start to resolve this. Any help is appreciated!
Tim - PicturesPro.com
10892 posts
admin
Fri Oct 19, 18
7:08 AM
Looks like strict mode is enabled in the database. Send me an email and I can attach you a file to upload that should work around it.
 
 
 
 
 
Tim Grissett, DIA - PicturesPro.com || My Email Address: info@picturespro.com
amy mccool
1 posts
Mon Jan 28, 19
12:08 PM
Hi there. I can't access my admin page since my server upgraded. They have suggested I do this:

turn off the only_full_group_by mode

I'm not a coder, do you have any way to help me? I currently have orders in my inbox that I can't even access as I only see any error.

Thank you in advance.
Loading more pages
Loading more pages

Sign up for email promotions.

Your information is safe with us and won't be shared.

Thank you for signing up!

 
©2003 - 2019 Grissett, LLC. All Rights Reserved.

By continuing to browse or by clicking Accept Cookies, you agree to the storing of cookies on your device necessary to provide you with the services available through our website.

    Accept   Privacy & Cookie Policy
Loading More Photos
Scroll To Top
Close Window
Loading
Close