Home » Projects » Ubercart Contributed Modules » Ubercart Contributions » Issues

Syntax error after hitting add to cart

Submitted by urbancity on Sat, 10/11/2008 - 13:00
Project:Ubercart Contributions
Component:Code
Category:
Priority:critical
Assigned:urbancity
Status:active
Description
Project: 
Ubercart

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.
Sat, 10/11/2008 - 13:20
#1 View page
TR
TR's picture
Offline
Bug FinderFAQ ModeratorGetting busy with the Ubercode.
Joined: 11/05/2007
Juice: 3369
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.

<tr>.
Top
Sat, 10/11/2008 - 13:37
#2 View page
urbancity
urbancity's picture
Offline
Joined: 10/11/2008
Juice: 12
Re: Syntax error after hitting add to cart
Assigned to:TR» urbancity

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

Top
Sat, 10/11/2008 - 13:57
#3 View page
TR
TR's picture
Offline
Bug FinderFAQ ModeratorGetting busy with the Ubercode.
Joined: 11/05/2007
Juice: 3369
Re: Re: Syntax error after hitting add to cart
Assigned to:urbancity» TR

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...

<tr>.
Top
Sat, 10/11/2008 - 16:40
#4 View page
urbancity
urbancity's picture
Offline
Joined: 10/11/2008
Juice: 12
Re: Re: Re: Syntax error after hitting add to cart
Assigned to:TR» urbancity

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 >>>>>>>>>>>>>>>>>>>>

Top
Sat, 10/11/2008 - 16:48
#5 View page
TR
TR's picture
Offline
Bug FinderFAQ ModeratorGetting busy with the Ubercode.
Joined: 11/05/2007
Juice: 3369
Re: Re: Re: Re: Syntax error after hitting add to cart
Assigned to:urbancity» TR

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.

<tr>.
Top
Sun, 10/12/2008 - 06:51
#6 View page
urbancity
urbancity's picture
Offline
Joined: 10/11/2008
Juice: 12
Found the problem
Assigned to:TR» urbancity

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

Thanks , Ubercart is the best

Top