#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Posts
    6
    Rep 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.

    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:

    #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.
  2. #2
  3. Hockey face
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    St. Catharines, Canada
    Posts
    8,147
    Rep Power
    1317
    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 03:22 PM.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Posts
    6
    Rep Power
    0
    Holy crap. You just saved me a lot of agony.

    IT WORKS!

IMN logo majestic logo threadwatch logo seochat tools logo