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

Looks like strict mode was enabled in the database.

Download this zip file:
https://www.picturespro.com/sy-misc/download/photo-cart-functions-core.zip

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.

Edited by