Author Topic: Products per page not working after updating viruemart to 3.2.2  (Read 3525 times)

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9416
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #30 on: June 14, 2017, 09:56:51 am »
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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Venci Gentchev

  • Jr. Member
  • **
  • Posts: 180
    • Bulgarian Computer Store
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #31 on: June 14, 2017, 10:07:11 am »
Thank you, Milbo.

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

Code: [Select]
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
No pain, no gain, no site!

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9416
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #32 on: June 14, 2017, 10:09:16 am »
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?
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Venci Gentchev

  • Jr. Member
  • **
  • Posts: 180
    • Bulgarian Computer Store
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #33 on: June 14, 2017, 10:15:18 am »
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.
No pain, no gain, no site!

Venci Gentchev

  • Jr. Member
  • **
  • Posts: 180
    • Bulgarian Computer Store
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #34 on: June 14, 2017, 11:13:03 am »
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]
self::$limit= $mainframe->getUserStateFromRequest('com_virtuemart.'.$view.'.limit', VmConfig::get('llimit_init_FE', 24), 24, 'int');
No pain, no gain, no site!

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9416
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #35 on: June 14, 2017, 11:34:27 am »
I dont know which value you set there.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Venci Gentchev

  • Jr. Member
  • **
  • Posts: 180
    • Bulgarian Computer Store
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #36 on: June 14, 2017, 11:46:01 am »
If you mean virtuemart.cfg:
list_limit=6
llimit_init_FE=6
No pain, no gain, no site!

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9416
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #37 on: June 14, 2017, 14:33:26 pm »
no, in the vm config. the template tab
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Venci Gentchev

  • Jr. Member
  • **
  • Posts: 180
    • Bulgarian Computer Store
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #38 on: June 14, 2017, 14:38:32 pm »
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:
No pain, no gain, no site!

Venci Gentchev

  • Jr. Member
  • **
  • Posts: 180
    • Bulgarian Computer Store
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #39 on: June 18, 2017, 17:33:16 pm »
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?
No pain, no gain, no site!

mfarooqi

  • Beginner
  • *
  • Posts: 33
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #40 on: June 30, 2017, 04:53:20 am »
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]
UPDATE `iaox0_virtuemart_categories` SET limit_list_step = ''
and it worked like a charm.




Venci Gentchev

  • Jr. Member
  • **
  • Posts: 180
    • Bulgarian Computer Store
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #41 on: July 02, 2017, 08:13:09 am »
com_virtuemart.3.2.3.9587_extract_first.zip - The problem still exists.
No pain, no gain, no site!

mfarooqi

  • Beginner
  • *
  • Posts: 33
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #42 on: July 12, 2017, 11:33:30 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" ?

Venci Gentchev

  • Jr. Member
  • **
  • Posts: 180
    • Bulgarian Computer Store
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #43 on: July 12, 2017, 11:42:25 am »
Yes, why not  :)

limit_list_step: 3,6
limit_list_initial: 6
No pain, no gain, no site!

rage76

  • Jr. Member
  • **
  • Posts: 129
Re: Products per page not working after updating viruemart to 3.2.2
« Reply #44 on: July 19, 2017, 19:15:57 pm »
Anything further on this please?

This is keeping me from updating my VM  :(