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.

Missing Approx 300 Orders From May To Aug?

L
7 posts
Wed Oct 04, 17 11:32 AM CST
We lost approx. 300 orders from the past few months. We can not pull accurate sales reports, manually searching for the missing order numbers shows "That Order Does Not Exist" We can see new orders now, but the block of 300 orders from May to Aug are missing.
16,196 posts (admin)
Thu Oct 05, 17 6:22 AM CST
The only way that could really happen is if a database backup was restored from an old backup. Photo Cart won't just delete orders. Has there been any backups restored?
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
L
7 posts
Thu Oct 05, 17 6:54 AM CST
No, but we did have to run a repair on a few tables that crashed in MySQL. Apparently the repair is not lossless.
16,196 posts (admin)
Thu Oct 05, 17 8:47 AM CST
I don't think a repair would cause data loss, but I don't know for sure.

If you have received orders that ended up being duplicate order numbers from the past, that is a telltale sign the database had been restored from an older backup,
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
L
7 posts
Thu Oct 05, 17 8:54 AM CST
The missing orders are from May to Aug however the events we added between May and Aug are still there. Everything except the orders from May to Aug is there. The order numbers missing are 24958-25232. In Sept we pick up at 25233, there are no duplicate order numbers. The events we added from May-Aug as stated are there but they show zero sales which is inaccurate as the missing 300 orders account for the sales from those events. Had the database been restored I would have thought more then the orders would be missing.
16,196 posts (admin)
Thu Oct 05, 17 12:36 PM CST
I don't have any idea then what happened to them. You can go into the PHPMyAdmin in your hosting control panel and look in the pc_orders table in your Photo Cart database and search the order id field for one of those order numbers and see if they are there.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
6 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 2,411 times
Category: Orders
 
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