I am getting this error after upgrading Stock by Attributes to 1.4.14:
I'm using ZC 1.3.9d. Was using Stock by Attributes 4.7 (which I found out is only listed as 1.3.8 compatible). I encountered an error where all variants listed somehow deleted themselves (they only showed up as ":" instead of the normal "Color:Red" etc). This became a problem seeing as how I would have to manually re-add hundreds of variants and stock levels for each.1054 Unknown column 'sort' in 'order clause'
in:
[select * from zen_products_with_attributes_stock where products_id="337" order by sort ASC;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
So I downloaded and installed update 1.4.14, which is 1.3.9 compatible and has several fixes as well. I extracted files into my directory, overwriting them (I do have backups). Then I go to admin and see this error. I removed all option values from all products and the error was gone, but no products had attributes. I added one option value to one product and the error came back. The products_id is simply the first item when you're looking at the categories (I deleted the attributes for 337 and the next item in the list was shown). Also set all quantities for those items to 0 using easy populate and still no luck.
Has anyone had this problem before or could someone help me! The rest of the website seems fine, it's just this mod isn't working anymore.
Bookmarks