October 14th, 2012, 02:06 PM
MySQL UPDATE issues
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.
Any and all help would be much appreciated.
October 14th, 2012, 02:20 PM
you can't make up your own syntax. the FROM clause is incorrect.
Try the following
stock_available.quantity = 1
stock_available.id_product = product.id_product
product.supplier_reference = 'BKFLAGPL';
Last edited by Guelphdad; October 14th, 2012 at 02:22 PM.
October 14th, 2012, 02:24 PM
Holy crap. You just saved me a lot of agony.