To post a new support question, click the Post New Topic button below.
Current Version: 4.9.2 | Sytist Manual | Common  Issues | Feature Requests

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.

Error

P
65 posts
Fri Sep 08, 17 7:27 AM CST
Hi.
Sins I updated the side to the latest version some of my clients are having difficulty longing in. the password they used before dosen´t work. when I am looking fore there photos I get this error.

MYSQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND pic_no_dis!='1' AND pic_client='0' ORDER BY pic_id DESC' at line 1

Query: SELECT COUNT(*) AS total FROM ms_photos WHERE pic_no_dis='0' AND pic_org LIKE '%Myri167%' OR pic_id='file:Myri167') AND pic_no_dis!='1' AND pic_client='0' ORDER BY pic_id DESC
16,236 posts (admin)
Fri Sep 08, 17 12:21 PM CST
I can't think of any reason for their passwords not to work other than them typing them in wrong.

For the error when search photos, that is fixed in the next update coming out next week.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
P
65 posts
Fri Sep 08, 17 5:23 PM CST
have ben trying to upload new photos. When the uploading is finest the photos are not their.
dos that have anything to do with the MYSQL ERROR.
16,236 posts (admin)
Mon Sep 11, 17 5:41 AM CST
That error will not have any effect on uploading photos. Maybe they are larger than normal and too large for the server to process. See this for troubleshooting uploading photos
https://www.picturespro.com/sytist-manual/articles/issues-uploading-photos/
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
4 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 531 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