Quote Originally Posted by abcisme View Post
Am getting the following error when trying to run reports without selecting an order status... Does anyone have any clue how to fix this?

Code:
1064 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 '' at line 1
in:
[select orders_status_name from zen_orders_status where orders_status_id = ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I've determined this to be one particular order status that is causing problems. Not sure why that would be the case, but when I removed the order associated with that status, I don't get an error anymore. It happens to be an order status that I added called "cancelled" #116. No clue what the issue is.