PHP Fatal error: 1064:You have an error in your SQL syntax

[uswebworx]

URL to temp site is http://alsemergencylighting.com/cart...&products_id=1

Admin>Configuration>My Store>Display Cart after Adding Product is set to true.

ZenLightbox was last mod installed and it was working. Went to eat supper and come back and it has died.
Configuration Files seem to be in order.

Debugging says:
PHP Fatal error: 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 'limit 10' at line 1 :: limit 10 in /home/alsemerg/public_html/cart/includes/classes/db/mysql/query_factory.php on line 101

However I have checked the file from the Tutorials section and everything is in order.

I am NOT on a Goddaddy server. I am on a linux server. I am confused!

Does it with default template as well. I have this same cart installed 3 separate times and ALL of them are giving "page not found" error.