Home » Forums » Ubercart » Bug Reports

Beta 3 MYSQL errors

Submitted by seedseller on Sat, 01/26/2008 - 22:09
seedseller
Posts: 60
 Joined: 11/27/2007

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.
permalink #1 Mon, 01/28/2008 - 11:15
Shawn Conn

Posts: 332
 Joined: 08/07/2007
Administrator

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

permalink #2 Mon, 01/28/2008 - 14:55
TR
Posts: 931
 Joined: 11/05/2007
Bug FinderFAQ ModeratorGetting busy with the Ubercode.

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

permalink #3 Mon, 01/28/2008 - 16:05
seedseller
Posts: 60
 Joined: 11/27/2007

Thanks, tr

Looking forward to the upgrade.