News:

Looking for documentation? Take a look on our wiki

Main Menu

Products per page not working after updating viruemart to 3.2.2

Started by Ventsi Genchev, May 19, 2017, 10:49:23 AM

Previous topic - Next topic

Milbo

I think I fixed it, please try the new router http://dev.virtuemart.net/attachments/download/1083/com_virtuemart.3.2.3_extract_first.9579.zip

But it cannot really work per category. Atm the limit is set in the constructor of the router and we had to set it, when we know which category is loaded.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Ventsi Genchev

Thank you, Milbo.

With this router.php, I get the following when I enter into category:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN `#__virtuemart_products_bg_bg` as l ON l.`virtuemart_product_id` =' at line 1

BR
Audio Store:
https://vsystem.bg - Bulgarian language
https://vsystem.bg/en - English

Milbo

ah come on give me an idea. How many languages do you use? and where do you get the error? on which view? if category, which product groups are activated?
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Ventsi Genchev

I have 2 languages on the site: Bulgarian and English.
I sent you a private message with a link to my test site. If you need administrative access, just say.
Now it is with the old router.php. If you want, I'll upload the new one again.
Audio Store:
https://vsystem.bg - Bulgarian language
https://vsystem.bg/en - English

Ventsi Genchev

I just installed the full version of com_virtuemart.3.2.3_extract_first.9579.zip.
The error is gone, but now the products on the page are 24.  :)

It is obviously due to:
self::$limit= $mainframe->getUserStateFromRequest('com_virtuemart.'.$view.'.limit', VmConfig::get('llimit_init_FE', 24), 24, 'int');
Audio Store:
https://vsystem.bg - Bulgarian language
https://vsystem.bg/en - English

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Ventsi Genchev

If you mean virtuemart.cfg:
list_limit=6
llimit_init_FE=6
Audio Store:
https://vsystem.bg - Bulgarian language
https://vsystem.bg/en - English

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Ventsi Genchev

On the second page of this topic I posted photos. I have not changed anything since then.
This is the configuration of the template tab:
Audio Store:
https://vsystem.bg - Bulgarian language
https://vsystem.bg/en - English

Ventsi Genchev

I just tested with an original VM installation: VirtueMart3.2.0_Joomla_3.6.5-Stable-Full_Package.zip
I only changed the following:

  • Frontend default items per list view: 6
  • For 3 items per row: 6,12
Everything works OK. But:

Update VM with com_virtuemart.3.2.2_extract_first.zip
Always the first category load shows 18 products per page. The problem also exists with the original installation.

Then I updated to version com_virtuemart.3.2.3_extract_first.9579.zip and Joomla 3.7.2.
The situation is the same, except for the fact that there are already 24 products per page. But this is for understandable reasons - changing the number 18 to 24 in the router.php.

Ok, assuming this problem exists with an original installation, what do we do?
Audio Store:
https://vsystem.bg - Bulgarian language
https://vsystem.bg/en - English

mfarooqi

I had the same issue.. May be the scenario was very different but the default values is only 10 none of the other way was working.
I updated mywebsite from 1.5 to 2.5 and then 3. onward to 3.7.2 .. but when I was preparing it's template my pagination was stuck at 10

I had tried backend coding.. settings, everything as told in above methods.. but nothing was possible..


but i nothing was working.

I changed my theme.. and wow . it didn't work either ....

when I checked categories ... there all categories were having only 10 .. WHAT??.. i have 300+ categories.. who is gonna work for them...

I opened my mysql database program (or use your phpmyadmin) and run a query

UPDATE `iaox0_virtuemart_categories` SET limit_list_step = ''

and it worked like a charm.




Ventsi Genchev

com_virtuemart.3.2.3.9587_extract_first.zip - The problem still exists.
Audio Store:
https://vsystem.bg - Bulgarian language
https://vsystem.bg/en - English

mfarooqi

Quote from: Venci Gentchev on July 02, 2017, 08:13:09 AM
com_virtuemart.3.2.3.9587_extract_first.zip - The problem still exists.

Can you please open phpmyadmin and browse table values for XXXX_virtuemart_categories "here XXXX should be your table's prefix" and see what values are under "limit_list_step" ?

Ventsi Genchev

Yes, why not  :)

limit_list_step: 3,6
limit_list_initial: 6
Audio Store:
https://vsystem.bg - Bulgarian language
https://vsystem.bg/en - English

rage76

Anything further on this please?

This is keeping me from updating my VM  :(