Author Topic: [Fixed] SQL error after update to 3.8.2  (Read 1058 times)

balai

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 1479
[Fixed] SQL error after update to 3.8.2
« on: June 03, 2020, 13:10:59 pm »
Debug stack: https://www.awesomescreenshot.com/image/4870199/639c63eb755764ec0086210fc3349bde

Here is the query that generates the error:

Code: [Select]
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

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28314
  • Always on vacation
    • Jenkin Hill Internet
Re: [Fixed] SQL error after update to 3.8.2
« Reply #1 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?
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

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

Currently using VirtueMart  4.0.2 10661 on Joomla 3.10.9 PHP 7.4.29

balai

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 1479
Re: [Fixed] SQL error after update to 3.8.2
« Reply #2 on: June 03, 2020, 15:13:21 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.