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
Palmi Asbjarnarson
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
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
Tim - PicturesPro.com
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.
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
My Email Address: info@picturespro.com
P
Palmi Asbjarnarson
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.
dos that have anything to do with the MYSQL ERROR.
Tim - PicturesPro.com
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/
https://www.picturespro.com/sytist-manual/articles/issues-uploading-photos/
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
My Email Address: info@picturespro.com
Please log in or Create an account to post or reply to topics.
Loading more pages