Attention

If your Photo Cart is suddenly getting a 500 error or only displaying a blank page then you or your hosting company has updated the PHP (programming language) to PHP 7 which Photo Cart is not compatible with (and will not be compatible with) mainly because of the removal of the my_sql functions which are replaced with my_sqli functions. 

You would need to have the PHP version downgraded to 5.6 in order for Photo Cart to work. If downgrading the PHP doesn't work then you may have to update Photo Cart to the last version of 7. Download Photo Cart 7 upgrade files. Upgrade instructions.

Photo Cart was retired in 2015. Check out Sytist.

Please log in or Create an account to post or reply to topics.
You will still receive notifications of replies to topics you are part of even if you do not subscribe to new topic emails.

Photocart Broken

R
5 posts
Fri Jun 19, 15 10:43 AM CST
A few months ago, Gear Host, moved my sites to a new server. Ever since I get mysql errors with Photocart on almost everything we try to do. I plan to install Stylist in the next few days, but I need to get Photocart functioning also.

I have a mysql expert available to me, but he knows nothing about Photocart. Is there anyone I can hire to go in and tell me what the heck is wrong?

Thanks,

Bob
16,145 posts (admin)
Fri Jun 19, 15 12:07 PM CST
What are some of the error messages?
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
R
5 posts
Fri Jun 19, 15 1:49 PM CST
When trying to change the expiration date on a gallery:

MYSQL ERROR: Incorrect integer value: '' for column 'perrow' at row 1

Query: UPDATE galleries SET gal_title='2011 Sturgis Mustang Rally', gal_status='1' , gal_date='2011-09-03', gal_expire='2020-09-03' , gal_pg='52' , gal_client='2', perpage='20' , perrow='' , gal_order='305', gal_key='55f7f323' , gal_allow_invite='1' , gal_style='0' , gal_discount='0' , gal_remove_watermark='1' , gal_no_ship='0' , gal_descr='2011 Sturgis Mustang Rally', gal_pg2='', gal_free_image='1', gal_free_image_size='2', gal_free_image_watermark='0', gal_eb_through='2011-10-03', gal_search='1',gal_shipping_group='0' , gal_eb_dis_type='0' , gal_eb_amount='0.00', gal_eb_min='0.00' , gal_min_order='0.00' ,gal_eb_use_default='' , gal_disable_fb='' , gal_pre_reg='' , gal_no_min_order='' WHERE gal_id='10092'

That would be an example. Another problem is that after you hit the Place Order button, it doesn't go to payment options. It just returns to the gallery home. The Paypal Business Option is activated in setting / payment options.

Thanks,

Bob
16,145 posts (admin)
Sat Jun 20, 15 7:07 AM CST
That error indicates MySQL strict mode is enabled. You should have your mysql expert disable strict mode for the Photo Cart database.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
R
5 posts
Fri Jun 26, 15 8:33 PM CST
Apparently, I was on a shared server and my hosting company tells me it would be unusual for mysql strict mode to be disabled on a shared server. So, today they finally moved my site to a dedicated served with mysql strict mode disabled. Sadly, it seems to make no difference. Trying to change the expiration date of a gallery results in this error message:

MYSQL ERROR: Incorrect integer value: '' for column 'perrow' at row 1

Query: UPDATE galleries SET gal_title='Pearl Hoel', gal_status='1' , gal_date='2013-09-25', gal_expire='2016-09-25' , gal_pg='0' , gal_client='1', perpage='20' , perrow='' , gal_order='515', gal_key='Pearl Hoel' , gal_allow_invite='1' , gal_style='0' , gal_discount='0' , gal_remove_watermark='' , gal_no_ship='0' , gal_descr='', gal_pg2='', gal_free_image='0', gal_free_image_size='0', gal_free_image_watermark='0', gal_eb_through='2013-10-25', gal_search='1',gal_shipping_group='0' , gal_eb_dis_type='0' , gal_eb_amount='0.00', gal_eb_min='0.00' , gal_min_order='0.00' ,gal_eb_use_default='1' , gal_disable_fb='' , gal_pre_reg='' , gal_no_min_order='' WHERE gal_id='10209'
16,145 posts (admin)
Sat Jun 27, 15 6:30 AM CST
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
R
5 posts
Wed Jul 01, 15 4:43 PM CST
Thanks for your help Tim,

Problem solved finally. We discovered the host was changing the connection string for Wordpress, thinking that PhotoCart was a plugin. Anyway, we're back in business now. I'll be adding Stylist, but will probably wait until later in the summer as I don't have time for something new right now.

Thanks,

Bob
7 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 1,391 times
Category: Error
 
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 - 2021 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