Home » Forums » Ubercart » Bug Reports
3 replies [Last post]
Sat, 01/26/2008 - 22:09
seedseller
seedseller's picture
Offline
Joined: 11/27/2007
Juice: 141
Was this information Helpful?

I just installed Ubercart beta 3 on a new site. When I tried to delete a product (my dumb mistake) I received the following message:

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 'LEFT JOIN uc_product_adjustments AS pa ON sl.model = pa.model W' at line 2 query: DELETE FROM uc_stocklevels AS sl LEFT JOIN uc_product_adjustments AS pa ON sl.model = pa.model WHERE pa.nid = 12 in (path deleted)/Drupal/includes/database.mysql.inc on line 172.

What do I fix? The site seems to work normally from there.

Thanks.

Top
Mon, 01/28/2008 - 11:15
#1 View page
Shawn Conn
Shawn Conn's picture
Offline
Administrator
Joined: 08/07/2007
Juice: 916
Re: Beta 3 MYSQL errors

Hmm, given that the table uc_stocklevels is in the query it sounds like its an issue with the Inventory API contrib module. You should bring this up an issue on its issue tracker so its maintainer can be notified of the bug.

-Shawn Conn: If the Name Don't Rhyme It Ain't Mine

Top
Mon, 01/28/2008 - 14:55
#2 View page
TR
TR's picture
Offline
Bug FinderFAQ ModeratorGetting busy with the Ubercode.
Joined: 11/05/2007
Juice: 3424
Re: Re: Beta 3 MYSQL errors

I'm currently in the process of overhauling the Inventory API contribution. I believe that is a bug I found a fixed a few weeks ago. I haven't released a new version yet. Until then, the error should only show up when you delete nodes, and no harm is being done by the bug so you you can just ignore the error. (I've put your error message on the list of things to check before I post the new version, just to make sure it really is fixed).

<tr>.
Top
Mon, 01/28/2008 - 16:05
#3 View page
seedseller
seedseller's picture
Offline
Joined: 11/27/2007
Juice: 141
Thanks, tr Looking forward

Thanks, tr

Looking forward to the upgrade.

Top