To post a new support question, click the Post New Topic button below.
Current Version: 5.2.5 | 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.

Search Box - Order Lookup Issue

K
7 posts
Wed Nov 20, 24 3:16 PM CST

I just started getting this notice when looking up order's in the Search Box by customer's name:

MYSQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE ms_orders.order_id>'0' ORDER BY ms_orders.order_id DESC' at line 1

Query: SELECT *, ms_orders.order_id AS order_id FROM WHERE ms_orders.order_id>'0' ORDER BY ms_orders.order_id DESC

It happened between one order and the next. Now I cannot lookup/find orders by my customers name. I did not change anything and I am not super computer savvy so this is all greek to me.

Please Help :)

16,874 posts (admin)
Thu Nov 21, 24 4:47 AM CST

That doesn't make any sense for that to just start happening. 

You can email me the following for me to look into it: 
  • 1) The link / URL to your Sytist admin (where you log into your Sytist admin).
  • 2) Create me an admin account by clicking Admins in the main menu, or send me your admin username and password.
  • 3) Link, username and password to your HOSTING control panel.


Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
K
7 posts
Thu Nov 21, 24 11:07 AM CST

Hi Tim,

Thank you for getting back to me. When I opened my Admin page today I am no longer getting that warning when looking up an order by customer name.

I will still email you the information you requested, in case it should happen again.

Thank You!!

3 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 80 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