Author Topic: [ SOLVED ] Products do not display  (Read 1079 times)

tweetie

  • Beginner
  • *
  • Posts: 11
[ SOLVED ] Products do not display
« on: April 16, 2013, 22:58:42 pm »
Just upgraded to 2.0.20b using Joomla 2.5.9

Now I get the following error:

vmError: exeSortSearchListQuery Column 'ordering' in order clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `j25_virtuemart_products_en_gb` as l JOIN `j25_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `j25_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `j25_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `j25_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `j25_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `j25_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `j25_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` = 7 AND ( s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY ordering ASC LIMIT 0, 10

Similar error in administrator trying to view product list.

Please advise.

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27601
  • Always on vacation
    • Jenkin Hill Internet
Re: Products do not display
« Reply #1 on: April 16, 2013, 23:27:31 pm »
Same as here: http://forum.virtuemart.net/index.php?topic=112606

Fix is to Enable database Update tools  in Configuration/Shop then go to Tools & Migration and hit "Install or if necessary update tables" button. But backup first, as always when working on the database.
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 VM 3.6.10.10211 on Joomla 3.9.13 PHP 7.0.33

tweetie

  • Beginner
  • *
  • Posts: 11
Re: Products do not display
« Reply #2 on: April 29, 2013, 20:34:24 pm »
Thank you. I had missed the part about "Enable database Update tools  in Configuration/Shop" - it has worked now.