Home » Issue Tracker » Ubercart

Syntax error after hitting add to cart

Submitted by urbancity on Sat, 10/11/2008 - 13:00.
Project: 
Ubercart
Category: 
bug report
Priority: 
critical
Status: 
closed

user warning: 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 query: SELECT aid, name FROM uc_attributes WHERE aid IN () in /home/urban1/public_html/urbancitystores.com/includes/database.mysql.inc on line 172.

I have search the forums for this one, also tryed to all updates to latest releases.

This One is hard to figure out. can anyone post a fix if possible.
#1Submitted by TR on Sat, 10/11/2008 - 13:20.

Re: Syntax error after hitting add to cart

Drupal version? Ubercart version? MySQL/PostgreSQL ? PHP version? Since no one has reported anything like this before, it's most likely something having to do with your configuration.

#2Submitted by urbancity on Sat, 10/11/2008 - 13:37.

Re: Syntax error after hitting add to cart

Drupal version? Ubercart version? MySQL/PostgreSQL ? PHP version?

Drupal - 5.10
UBERCART - 1.5 JUST UPDATED
MySQL -database 5.0.51a
PHP- 5.2.6

IT may be a misconfiguration.

Site Address , www.urbancitystores.com, Catalog is in Mp3 downloads

#3Submitted by TR on Sat, 10/11/2008 - 13:57.

Re: Re: Syntax error after hitting add to cart

That all looks pretty typical - I don't know where your error is coming from then. If you just updated, did you run update.php? Perhaps there is a bug in one of the update functions...

#4Submitted by urbancity on Sat, 10/11/2008 - 16:40.

Re: Re: Re: Syntax error after hitting add to cart

I ran update php, but still the problem persists

It gave me the error as well, before I updated from 1.4 to 1.5

Someone Help >>>>>>>>>>>>>>>>>>>>

#5Submitted by TR on Sat, 10/11/2008 - 16:48.

Re: Re: Re: Re: Syntax error after hitting add to cart

You're going to have to figure out which module is generating that SQL statement - I don't see a statement like that in the core Ubercart code. Perhaps it's one of the contributed modules. Try disabling modules until the error goes away.

#6Submitted by urbancity on Sun, 10/12/2008 - 06:51.

Found the problem

I disabled the email validation contribution, that was the problem, I wasn't really using it anyway.

Thanks , Ubercart is the best