Photo Cart is retired. Check out Sytist.

New Gallery

Please log in or Create an account to post or reply to topics.
john whitehead
1 posts
Sun Apr 07, 19
2:23 PM
Any idea why this would pop up. I have never really had any issues before. The dates seem to be correct.
MYSQL ERROR: Incorrect date value: '0000-00-00' for column 'gal_expire_email' at row 1

Query: INSERT INTO galleries SET gal_title='Bansari', gal_under='', gal_status='1' , gal_date='2019-04-07', gal_expire='2020-07-06' , gal_pg='46' , gal_client='3', perpage='20' , perrow='' , gal_order='565', gal_key='dance' , gal_allow_invite='1' , gal_style='0' , gal_discount='0' , gal_remove_watermark='' , gal_no_ship='0' , gal_descr='All images in this gallery have not been toned. I will tone the images after you have selected your photographs.' , gal_splash_skip='Continue to gallery', gal_pg2='', gal_free_image='0', gal_free_image_size='0', gal_free_image_watermark='0', gal_eb_through='2019-05-07', gal_search='1',gal_shipping_group='0' , gal_eb_dis_type='' , gal_eb_amount='', gal_eb_min='' , gal_min_order='' ,gal_eb_use_default='1' , gal_disable_fb='' , gal_pre_reg='', gal_no_min_order=''

I also get this error. My other galleries have errors also. MYSQL ERROR: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jcwphoto_clientcart.pc_order_packages.pcart_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Query: SELECT * FROM WHERE (pics.pic_gal='10984' OR pics.pic_gal='10987' OR pics.pic_gal='10986' OR pics.pic_gal='10988' OR pics.pic_gal='10989' OR pics.pic_gal='10985' ) AND pc_order_packages.pcart_image=pics.pic_id GROUP BY pcart_order_id
Edited Sun Apr 07, 19 2:48 PM by john whitehead
Tim -
11625 posts
Mon Apr 08, 19
4:27 AM
Looks like strict mode was enabled in the database.

Download this zip file:

Unzip it and upload the included functions.core.php file into your Photo Cart -> pc_inc folder overwriting the existing on either with your FTP program or the file manager in your hosting control panel. This should override the strict mode.
Tim Grissett, DIA - || My Email Address:
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