Products per page not working after updating viruemart to 3.2.2

[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.

[Ventsi Genchev]

Thank you, Milbo.

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

Code Select Expand

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

[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?

[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.

[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:

Code Select Expand

self::$limit= $mainframe->getUserStateFromRequest('com_virtuemart.'.$view.'.limit', VmConfig::get('llimit_init_FE', 24), 24, 'int');

[Milbo]

I dont know which value you set there.

[Ventsi Genchev]

If you mean virtuemart.cfg:
list_limit=6
llimit_init_FE=6

[Milbo]

no, in the vm config. the template tab

[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:

[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?

[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

Code Select Expand

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.

[mfarooqi]

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

[rage76]

Anything further on this please?

This is keeping me from updating my VM