Problem with sort by...

Try to overwrite all files and folders under:

components\com_virtuemart\
and
administrator\components\com_virtuemart\

from copy that is working ok. But be aware which version you use to copy from.

By errors you posted previously it appears db is OK because that fields relay do no exist in latest VM they where present in old versions.

Also you could compare database structure with that that works normally and fix VM tables manually if you locate any difference.

I am affraid, that any way this is a problem with Your VM templates. I repeat again my first question:

Why sorting is not working correct on Your Demos ?

This is the main question and reply - reliable reply, that this is not general template problem - next we can to make next tests and look for a solution...

We are template making company and our jurisdiction is under templates/hot_ecommerce/ because that are only files made by us all rest all joomla and vm default. We can not clean mess made by vm and they are famous by hazards they make with later updates. All I see is that it appears some vm core files are outdated and solution I told you might work.

To make situation more clear, please explain me, why is this difference:



adress lines generated by Joomla version 2.5.14, Virtuemart 2.0.22c installed via hot_ecommerce25_hotstart.zip:


http://,,,/index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&Itemid=154&filter_product=0&orderby=m.mf_name

http://,,,/index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&Itemid=154&filter_product=0&orderby=c.category_name

http://,,,/index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&Itemid=154&filter_product=0&orderby=p.product_name




adress lines generated by Joomla version 2.5.14, Virtuemart 2.0.22c installed via default Virtuemart demo template "mov..so":



http://.../index.php?option=com_virtuemart&view=category&virtuemart_category_id=11&Itemid=104&orderby=mf_name

http://.../index.php?option=com_virtuemart&view=category&virtuemart_category_id=11&Itemid=104&orderby=category_name

http://.../index.php?option=com_virtuemart&view=category&virtuemart_category_id=11&Itemid=104&orderby=product_name


In second section are existing columns: mf_name, category_name, product_name

In first section (Your template) are unknown column names: m.mf_name, c.category_name, p.product_name

PS. I preffer to work with Your templates - IMHO Your templates from graphic side are a fev levels higher like "mov..so"....

PS2. It is Your responsibility to make template compatibile with CMS in 100%, nor 50%...

PS3. I tested Your suggestion to replace components\com_virtuemart\ and administrator\components\com_virtuemart\ - no result - in adress line (SEF is off for now) still are existing unknown column names... - I am affraid, these adresses are generated by template... Precisely, Your not actual demo-installer, mmaking some mess because of some "out of date" files, not corrected for actual version J! and VM...

Try this to go vm admin in backed, then configuration->configuration> "Product Order Settings" tab then check some "Available Sort-by fields" (ones you need) and save

GREAT !!!

Now is working! I am lucky man. Thank You for this help!

Regards

goeher

PS. I think, this subject will be "most wanted" on Your forum...