[Fixed] SQL error after update to 3.8.2

[balai]

Debug stack: https://www.awesomescreenshot.com/image/4870199/639c63eb755764ec0086210fc3349bde

Here is the query that generates the error:

Code Select Expand

SELECT  c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.category_parent_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug  FROM #__virtuemart_categories as c  LEFT JOIN `#__virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id`  WHERE  (c.`category_parent_id` = 13 ) AND  c.`published` = 1  ORDER BY c.ordering,category_name ASC

Seems like several columns such as: category_layout, category_parent_id are missing from that table

Update: The error is fixed after downloading the package and installing/update using the Joomla installer.

[jenkinhill]

Is this 3.8.2 or 3.8.2 10325 - the latest current download which is out of position on http://dev.virtuemart.net/projects/virtuemart/files?

[balai]

Is this 3.8.2 or 3.8.2 10325 - the latest current download which is out of position on http://dev.virtuemart.net/projects/virtuemart/files?

I just pressed the "Update" btn in the Joomla updates. Hence i suppose it's the one that is available as stable in the VM repo.
To fix it, i downloaded the "com_virtuemart.3.8.2.10325_package_or_extract.zip" and installed/updated with the file.