News:

Support the VirtueMart project and become a member

Main Menu

Can't see any [SOLVED]

Started by marcelodias, January 17, 2013, 11:54:05 AM

Previous topic - Next topic

marcelodias

Hello everybody,
major error on my site.
Since i made the update to 2.0.18a i canĀ“t see any product in front office, i can only see this error:

vmError: exeSortSearchListQuery Column 'ordering' in order clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `jzr70_virtuemart_products_pt_pt` as l JOIN `jzr70_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `jzr70_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `jzr70_virtuemart_categories_pt_pt` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `jzr70_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `jzr70_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `jzr70_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `jzr70_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` = 67 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, 99

I tried everything, like update virtuemart-aio, clear cache and "update tables" in "Tools & Migration" but did not resolve the problem.
My joomla version is 2.5.8 and virtuemart 2.0.18a.

Please i appreciate your help as soon as possible!

jjk

Perhaps you will find the solution if you follow the links in these two posts: http://forum.virtuemart.net/index.php?topic=111437.msg374529#msg374529
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

marcelodias

Solution found!!!  ;D
What i did:
- Component Virtuemart >Configuration>Shopfront
- At the bottom i click in "Latest Products - Sort order of display" and changed "Last created products first" to "Last modified products first"
- And that's all, start to work again  :o then i changed again to "Last created products first" and still work.

Very odd  ???, but is working and is all i want.

jjk

Might be that it just was necessary to "Save" the configuration once after the update.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations