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

Started by lysov, December 02, 2012, 18:47:23 PM

Previous topic - Next topic

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
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

lysov

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

bytelord

Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

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
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
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

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
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

Milbo

COM_VIRTUEMART_SEF_EDITSHIPPING is obsolete

Quote from: bytelord on December 03, 2012, 13:07:12 PM
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?
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

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.
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

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

Quote from: csimmo on December 04, 2012, 04:16:06 AM
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