News:

Looking for documentation? Take a look on our wiki

Main Menu

[Fixed] SQL error after update to 3.8.2

Started by balai, June 03, 2020, 13:10:59 PM

Previous topic - Next topic

balai

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

Here is the query that generates the error:

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?
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

balai

Quote from: jenkinhill on June 03, 2020, 13:38:46 PM
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.