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.

Mysql

A
180 posts
Wed Jul 22, 15 8:25 PM CST
Hi everyone. I use some sql code to retrieve information from the database to do up mailing labels for my completed orders. It used to work fine but now its only returning the last order completed. Any gurus out there? Nothing has changed in the code since I last ran it but now it just returns one entry:

select DISTINCTROW pc_clients.client_name, pc_clients.client_last_name, pc_orders.order_id,pc_orders.order_ship, pc_clients.client_address1, pc_clients.client_address2, pc_clients.client_city, pc_clients.client_state, pc_clients.client_zip, pc_clients.client_country, pc_clients.client_company,pc_orders.order_ship
from pc_clients, pc_orders

where pc_clients.client_id = pc_orders.order_client and pc_orders.order_status = 6
group by pc_clients.client_id order by pc_orders.order_id


MySQL client version: mysqlnd 5.0.10
T
31 posts
Thu Sep 03, 15 1:18 PM CST
Did the status change for your orders? Looks like the search is looking for those with a status of 6

Did you close them? or change the status to 1?
A
180 posts
Thu Sep 03, 15 5:22 PM CST
I was having a dumb moment. I had entered a lot of invoices manually under my own name. The code select DISTINCTROW only allows for one iteration of a user name so it picked up one only and left the others off. I knew I had lots of orders so I was confused why it wasnt getting them all. Under normal circumstances when people place their own orders it works fine. Thanks for responding though.
3 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 1,416 times
 
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