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.

[DrByte]

You've got PHP files that are generating incorrect SQL statements.
So, you'll need to remove the changes that were made which caused the problem.

Good thing you have frequent regular consistent solid backups of everything.

http://www.zen-cart.com/wiki/index.p...Obscure_Issues


And the error you're reporting would have nothing to do with being a GoDaddy server or not. No need to badmouth them when they're not involved in the situation

[uswebworx]

Dr Byte how could this be, since the exact same thing is happening even on a fresh install I tried last night? I've since become frustrated and deleted all the stores except for /cart/ to start over and it still happens on a fresh install. Smells like a server issue to me. I've submitted a trouble ticket to my awesome support team
(not sarcasm) and will patiently wait for their answers.
See I am a typical man I despise asking for help! If I can't find the answer in this awesome forum then there isn't a a correct answer!
Thanks!

[RodG]

Dr Byte how could this be, since the exact same thing is happening even on a fresh install I tried last night?

If you've installed an add-on with bad code and re-install it with your 'fresh installs' you'll simply be re-installing the same erroneous files again, as such, the problem will persist.

If your 'fresh installs' were truely fresh, with no other addons the issue will almost certainly go away.

Smells like a server issue to me.

As usual, I find myself agreeing with DrB, this doesn't sound anything like a server issue.

I've submitted a trouble ticket to my awesome support team
(not sarcasm) and will patiently wait for their answers.

Whilst waiting I'd suggest that you continue to look for the *real* cause, because unless your support team know more about zencart than DrByte they probably aren't going to be of much help.

Cheers
Rod

[uswebworx]

Where would I begin looking?

[DrByte]

looking for what?