1064 You have an error in your SQL syntax; check the manual that corresponds to your

27 Jun 2011, 10:21 PM

#1

New Zenner

Join Date:: Jun 2011
Posts:: 7
Plugin Contributions:: 0

1064 You have an error in your SQL syntax; check the manual that corresponds to your

Hi,

There is an error that causes the shopping cart [Zen Cart 1.3.8a] to not function at all.
The Add To Cart button is gone, and when clicking on View Shopping Cart, this shows:

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 6
in:
[select p.products_id, pd.products_name, products_date_available as date_expected, p.master_categories_id from products p, products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >20110620235959 order by date_expected desc limit ]

Please help.

Regards,

Masha

27 Jun 2011, 10:24 PM

#2

kobra

Black Belt

Join Date:: Aug 2005
Location:: Arizona
Posts:: 31,500
Plugin Contributions:: 4

Re: 1064 You have an error in your SQL syntax; check the manual that corresponds to your

Have you checked the similar threads at the bottom of this post?

Zen-Venom Get Bitten

27 Jun 2011, 10:59 PM

#3

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: 1064 You have an error in your SQL syntax; check the manual that corresponds to your

As kobra said, your question is likely answered in the other threads on the same topic. The first one listed below contains the solution that likely fits your case: http://www.zen-cart.com/forum/showthread.php?t=178145

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

27 Jun 2011, 11:10 PM

#4

masha

New Zenner

Join Date:: Jun 2011
Posts:: 7
Plugin Contributions:: 0

Re: 1064 You have an error in your SQL syntax; check the manual that corresponds to your

I've looked at the admin > conf. > max. val. ... and have no idea what you're talking about. What I have set to 0 means that it's off and not a numerical value.

Please give other suggestions.

Thanx

27 Jun 2011, 11:14 PM

#5

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: 1064 You have an error in your SQL syntax; check the manual that corresponds to your

What have you set to 0? And what is set to blank?

I suspect you've got the "Upcoming products" set to blank, which would cause the symptoms you describe.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

27 Jun 2011, 11:28 PM

#6

masha

New Zenner

Join Date:: Jun 2011
Posts:: 7
Plugin Contributions:: 0

Re: 1064 You have an error in your SQL syntax; check the manual that corresponds to your

What number should I set the upcoming products to?

27 Jun 2011, 11:32 PM

#7

masha

New Zenner

Join Date:: Jun 2011
Posts:: 7
Plugin Contributions:: 0

Re: 1064 You have an error in your SQL syntax; check the manual that corresponds to your

Thank you, :smile: the error disappeared after I put a number on the Upcoming Products.

However, the button Add To Cart is still gone. Now, it just shows Contact Us. :dontgetit

What should I do?

28 Jun 2011, 12:17 AM

#8

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: 1064 You have an error in your SQL syntax; check the manual that corresponds to your

If you've set your store into showcase mode, then it will not offer any add-to-cart buttons; instead, it offers Contact Us.
And if you've set your individual products as "Call for Price", it will display a Contact Us button instead of add-to-cart.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

28 Jun 2011, 7:42 AM

#9

masha

New Zenner

Join Date:: Jun 2011
Posts:: 7
Plugin Contributions:: 0

Re: 1064 You have an error in your SQL syntax; check the manual that corresponds to your

Thank you! Thank you! Thank you! We're back in business!:clap:
Dr.Byte, you are the best! :D

Sincerely,
Masha