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

Mysql Error - Help!

L
25 posts
Mon Sep 09, 24 4:12 PM CST

When I go to orders there are none listed and Sytist displays the following:

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 '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


Attached Photos

This reply was deleted.
16,700 posts (admin)
Tue Sep 10, 24 4:39 AM CST

Is it just clicking orders in the main menu? Or are you going into an order status or gallery? Is it happening today? Strange it is not selecting a table. 

Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
L
25 posts
Tue Sep 10, 24 5:03 AM CST

I can see the orders on the admin page but when i go into them or select orders on the main menu it comes back with that error message.

It turns out that my hosting migrated the hosting server to a new Cloud Linux 8 OS so I imagine this is the cause of all these errors.  They fixed the 406 error, so only this remains now.

16,700 posts (admin)
Tue Sep 10, 24 9:34 AM CST

You will need to email me the following: 

  • 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. Make sure I have access to the orders section.
  • 3) The link in the address bar when you are getting this error.
  • 4) FTP username and password.


Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
5 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 100 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