Error on FP after setting Shopfront option.

[jeoff]

I posted this in the General Questions forum but I think it needs to be placed in this forum (my previous topic can be closed/removed).

I am using VM 2.0.8e on Joomla 2.5.6. No other VM plugins are installed.

When I go to: Configuration - Shopfront and set the option "Do not Display Product, if child products also out of stock"
I get the following error on the front page of the shop:

----------
vmError: exeSortSearchListQuery Column 'product_sales' in order clause is ambiguous SQL=SELECT * FROM `idrqt_virtuemart_products_nl_nl` as l JOIN `idrqt_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `idrqt_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `idrqt_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `idrqt_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `idrqt_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `idrqt_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` LEFT OUTER JOIN `idrqt_virtuemart_products` children ON p.`virtuemart_product_id` = children.`product_parent_id` WHERE ( p.`published`="1" AND (p.`product_in_stock` - p.`product_ordered` >"0" OR children.`product_in_stock` - children.`product_ordered` > "0") AND ( s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY product_sales DESC LIMIT 0, 5
---------

Some more info! I only see this error when logged in as a Joomla Superuser. Normal users or visitors who did not sign in do not see this error message


Any ideas?

The reason why I want to set this option in the first place (in case I understand this wrong).
I am setting up a website that sells clothes. I create a parent article for a clothing item with 0 in stock. I then create child items through the Custom Fields tab for each size I have of that item (so the same item, but then size Large, Medium, Small etc.) wich each child item having a certain number of stock.

This way I would have to set the option for the parent item to show: Do not Display Product, if child products also out of stock

But like I said I see the error message above on the front page. The store seems to work OK for the rest.

Any help would be greatly appreciated!

[bytelord]

Hello,

First of all be sure that you have update both new VM core and VM AIO in the current version (2.0.8e) successfully.
You can try reinstall AIO. If problem persists then you should first backup your entire site and then go to BE --> Tools -> Tools and Migration and use the option
"Install tables or if necessary update them".

Hope it helps,

Regards,

BL

[jeoff]

Hi!

Thanks for your reply. I tried updating AIO and the option: "Install tables or if necessary update them"
Unfortunately this did not help.

However I did find another correlation: If I go to Configuration -> Templates ->  and UNcheck the option: Show Top ten products

Then the error message is gone also.

Some somehow the query that displays the top ten products on the shops front page throws an error if the option "Do not Display Product, if child products also out of stock" is selected.


Strange!!

EDIT: I just noticed I also have the problem if I search in the shop. yet if I change the option from "Do not Display Product, if child products also out of stock" to "Do not Display Product" the error message disappears.

But for the clothing store I need the option: "Do not Display Product, if child products also out of stock"

[jeoff]

If anyone experiences this problem, you can find the solution here

http://forum.virtuemart.net/index.php?topic=106284.0

Thanks to GJC Webdesign!