Beta 3 MYSQL errors

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.

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

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

Posts: 60
Joined: 11/27/2007

Thanks, tr

Looking forward to the upgrade.