MySQL UPDATE issues

Dev Shed Forums Sponsor:

October 14th, 2012, 02:06 PM

rseigel

Registered User

Join Date: Oct 2012

Posts: 6

Time spent in forums: 53 m 48 sec
Reputation Power: 0

MySQL UPDATE issues

Hello,

I'm working with the 1.5.1 version of PrestShop in case anyone is familiar with it. I've included my original message in the Presta forums below.

Quote:

So, it seems that the quantity field is no longer used in the product table and is instead pulled from the stock_available table. Thanks for the hour of total confusion Presta developers. :angry:

I'm trying to update the quantities using a script outside of Presta (dropshipping - I pull the stock availability from them daily). It was working fine until the quantity field moved.

Here's the SQL I'm trying to run:

Code:

UPDATE stock_available
SET stock_available.quantity = 1
FROM stock_available
INNER JOIN product
ON stock_available.id_product = product.id_product
WHERE product.supplier_reference = 'BKFLAGPL';

The real script uses variables for stock_available.quantity and product.supplier_reference. I'm just trying to get the basic SQL to work.

I get the following error:

Quote:

#1064 - 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 'FROM stock_available INNER JOIN product ON stock_available.id_product = product.' at line 3

Any ideas on where I'm going wrong?

Any and all help would be much appreciated.

October 14th, 2012, 02:20 PM

Guelphdad

Hockey face

Dev Shed God 7th Plane (8000 - 8499 posts)

Join Date: Nov 2001

Location: St. Catharines, Canada

Posts: 8,141

Time spent in forums: 2 Months 3 Weeks 3 Days 20 h 34 m 13 sec
Reputation Power: 1315

you can't make up your own syntax. the FROM clause is incorrect.

Try the following

Code:

UPDATE 
  stock_available, product
SET 
  stock_available.quantity = 1
WHERE 
  stock_available.id_product = product.id_product
AND 
  product.supplier_reference = 'BKFLAGPL';

Last edited by Guelphdad : October 14th, 2012 at 02:22 PM.

October 14th, 2012, 02:24 PM

rseigel

Registered User

Join Date: Oct 2012

Posts: 6

Time spent in forums: 53 m 48 sec
Reputation Power: 0

Holy crap. You just saved me a lot of agony.

IT WORKS!

Viewing: Dev Shed Forums > Databases > MySQL Help > MySQL UPDATE issues

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump