Problem with sort by...

This is my first post on this forum, then Hello !

And the main subject: on my test-www, based on eCommerce template, "sort by manufacturer name" and "sort by product name" is not working. When I am looking on Your demo (on all VM templates !), situation is this same - blank screen...

Why?

Regards

goeher

Replace:

templates\hot_ecommerce\html\com_virtuemart\category\default.php

with one in attachment.

It is still this same...

Error report (for "sort by manufacturer"):


vmError: exeSortSearchListQuery Unknown column 'm.mf_name' in 'order clause' SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `c0wsv_virtuemart_products_pl_pl` as l JOIN `c0wsv_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `c0wsv_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `c0wsv_virtuemart_categories_pl_pl` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `c0wsv_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `c0wsv_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `c0wsv_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `c0wsv_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` = 1 AND `pc`.`virtuemart_category_id` > 0 AND ( s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY m.mf_name ASC LIMIT 0, 9


Error report (for "sort by product name"):

vmError: exeSortSearchListQuery Unknown column 'p.product_name' in 'order clause' SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `c0wsv_virtuemart_products_pl_pl` as l JOIN `c0wsv_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `c0wsv_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `c0wsv_virtuemart_categories_pl_pl` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `c0wsv_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `c0wsv_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `c0wsv_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `c0wsv_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` = 1 AND `pc`.`virtuemart_category_id` > 0 AND ( s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY p.product_name ASC LIMIT 0, 9



Joomla version 2.5.14
Virtuemart 2.0.22c

Installation was made from Your hot_ecommerce25_hotstart.zip and updated to latest versions

I tryed "install or if necessary update tables", but without any result...

Regards

Goeher

Check if there are database conflicts. Go you Extension Manager->Database Tab, if there is come link saying click here to fix database click on it

After repair - note, that with database everythig is OK.

Test - no change. Still these same errors...


Another installation on this same server and version of J! and VM, based on default virtuemart demo template (mov..so) - sorting is working without problems and without problematic asks about 'm.mf_name' and 'p.product_name'.

Please, try to switch on error reporting on Your demo - You will have these same errors for sure...

Copy:

components\com_virtuemart\views\category\tmpl\default.php

to

templates\hot_ecommerce\html\com_virtuemart\category\defualt.php
(before that rename one you already have)

Check what happens.

---

EDIT
Did you update VM also?