Zen Cart Logo
Forums / General Questions / SQL error with products in cart with attributes

SQL error with products in cart with attributes

Locked

Views: 1,056

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
17 Oct 2007, 4:11 PM
#1
dinosoup avatar

dinosoup

New Zenner

Join Date:
May 2007
Posts:
17
Plugin Contributions:
0

SQL error with products in cart with attributes

Hello,

It seems that if I click on any products in the shopping cart that have attributes to goto the products page, I see the following error at the bottom:

"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 ':b2a4b138b56aed300af272c314626530' at line 1
in:
[SELECT * FROM products WHERE products_id = 197:b2a4b138b56aed300af272c314626530]"

Does anyone know why? Thanks.

17 Oct 2007, 4:23 PM
#2
drbyte avatar

drbyte

Sensei

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

Re: SQL error with products in cart with attributes

What version of Zen Cart?
What version of MySQL?
What version of PHP?
What addons/contributions have you installed?
What code-customizations have you made to your site?

18 Oct 2007, 4:40 AM
#3
dinosoup avatar

dinosoup

New Zenner

Join Date:
May 2007
Posts:
17
Plugin Contributions:
0

Re: SQL error with products in cart with attributes

Ah sorry it was indeed some code-customizations I made that caused the problem.