2.0.12 - 2.0.15a: trouble with sort order of the products in a category

[lysov]

Hi, when I click on the 'Creation date' or 'SKU' in the FE category view  ("Sort by" combo-box)  I get an error:
Not Found
/catalog/health-and-education/councils-of-the-kind-doctor/by,`p`.created_on was not found on this server.
or
The requested URL /catalog/health-and-education/councils-of-the-kind-doctor/by,`p`.product_sku was not found on this server.

When I switch off Joomla SEF flag, it works fine and url looks like
/index.php?option=com_virtuemart&view=category&virtuemart_category_id=28&Itemid=120&lang=ru&language=ru-RU&orderby=`p`.created_on
or
/index.php?option=com_virtuemart&view=category&virtuemart_category_id=28&Itemid=120&lang=ru&language=ru-RU&orderby=`p`.product_sku

For example look this:  http://www.litera.spb.ru/catalog/health-and-education/councils-of-the-kind-doctor/
Here 'ISBN' = SKU and 'Дата выпуска' = creation_date

[bytelord]

Hello,

Please check the sef ini translation file for the language you are using under language\en-GB\en-GB.com_virtuemart.sef.ini for example for English and check if the keys are translated.
key for created_on   -> COM_VIRTUEMART_SEF_CREATED_ON

Regards

[lysov]

Tnx, I have checked this, now I am using standart set ru-RU translation files

[bytelord]

So, you check the RU sef translation? Is it working?

[lysov]

Yes, but unsuccessfully. First of all I checked ru-RU.com_virtuemart.sef.ini, it is Ok: all keywords from en version are present and translated. Next I tried to replace ru version to the English

Code Select Expand

cp  en-GB/en-GB.com_virtuemart.sef.ini  ru-RU/ru-RU.com_virtuemart.sef.ini
Unfortunately it did not help, the situation has not changed 

[bytelord]

Hi,

Did you enable from the Joomla global configuration -> site -> SEO Settings -> Unicode Aliases ?

Regards

[lysov]

No (as default). Now I swiched "Unicode Aliases" to Enable and tested with original  ru-RU.com_virtuemart.sef.ini:  the situation has not changed.  It is strange that the error occurs only when I specify "created_on" and SKU and is not dependent on the version of the file ru-RU.com_virtuemart.sef.ini

[lysov]

The only difference between the keywords of English and Russian versions of the file com_virtuemart.sef.ini is COM_VIRTUEMART_SEF_EDITSHIPPING (ru version) and COM_VIRTUEMART_SEF_EDIT_SHIPMENT (en)

[bytelord]

Hi,

Could be something on the route, works for me but the translated strings are not right one for me also. Give a try also to enable translate string under configuration -> SEO

Regards

[Milbo]

COM_VIRTUEMART_SEF_EDITSHIPPING is obsolete

Could be something on the route, works for me but the translated strings are not right one for me also.

What does not work? translated seo?

[bytelord]

Yes, as i see the issue with the translated strings returns somehow, using en-gb and sef keys translated the url is by,`p`.created_on instead of the translated one.
The COM_VIRTUEMART_SEF_EDITSHIPPING is not there anymore as you mention, may lysov using old language files for ru-RU but as far as i know jjk have fixed all of them.

[lysov]

Ok, but another question: why dublicate tag 'ru' in the non-SEF url?
/index.php?option=com_virtuemart&view=category&virtuemart_category_id=28&Itemid=120&lang=ru&language=ru-RU&orderby=`p`.created_on

[csimmo]

I have a similar issue I have posted for me this:
I found a fix, but I need help applying it
This does not work:
http://www2.abtsystems.com.au/services/shop-servicing/by,m.mf_name.html
But if I delete the m. and make it like this:
http://www2.abtsystems.com.au/services/shop-servicing/by,mf_name.html
it works fine!!!

How do I apply it?

[lysov]

I have a similar issue I have posted for me this:
I found a fix, but I need help applying it
This does not work:
http://www2.abtsystems.com.au/services/shop-servicing/by,m.mf_name.html
But if I delete the m. and make it like this:
http://www2.abtsystems.com.au/services/shop-servicing/by,mf_name.html
it works fine!!!

How do I apply it?

Hi, csimmo. What is your VM version? I have no problem to sort by manufacturers.

To bytelord (offtopic):
Probably have to fix router.php, can I hope to correct sql-query?
router.php line 971 from
   $query = 'SELECT * FROM `#__menu`  where `link` like "index.php?option=com_virtuemart%" and client_id=0 and published=1 and (language="*" or language="'.$this->langTag.'")'  ;

to
   $query = 'SELECT * FROM `#__menu` where `link` like "index.php?option=com_virtuemart%" and client_id=0 and published=1 and (language="*" or language LIKE "'.$this->langTag.'")';
Please see my explanation at http://forum.virtuemart.net/index.php?topic=99711.msg335341#msg335341

[lysov]

I noticed one important (perhaps) feature: if I change the default number of displayed products on the page (pagination), sorting works!
error       http://www.litera.spb.ru/catalog/health-and-education/councils-of-the-kind-doctor/by,%60p%60.product_sku
works     http://www.litera.spb.ru/catalog/health-and-education/councils-of-the-kind-doctor/by,%60p%60.product_sku/
works     http://www.litera.spb.ru/catalog/health-and-education/councils-of-the-kind-doctor/by,%60p%60.product_sku/results,1-72