Setting Default Order by to Creation Date = NO Products Displayed

[BigAlStorm]

This is an odd issue.

The shop works fine but recently a client wanted newest products first.

I set Default product sort order to Creation date

No products displayed - just blank content area but the joomla template is visible

So I set debug on to diagnose issue

Server error 500, now page is standard error 500 page

Code Select Expand

500 - JDatabaseMySQLi::query: 1052 - Column 'created_on' in order clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `jos_virtuemart_products_en_gb` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `jos_virtuemart_product_categories` ON p.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `jos_virtuemart_product_categories`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `jos_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `jos_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `jos_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `jos_virtuemart_product_categories`.`virtuemart_category_id` = 1 AND (s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )) ORDER BY created_on ASC LIMIT 0, 100

This is the error on the database call

Anyone know why this happens?

WHilst looking for a creation date ont eh actual products I couldnt find any information

ANy help would be great.

Al

[richard@wittie]

I've got the same problem. Is there anyone who has experienced this an may have a solution?
Would be greatfull.

Regards,
Richard