Number of Products per page...

[devyani]

this a great addon! Worked like a charm on 1.5.1 too!

[devyani]

Hi,
I had this issue which got sorted after correction in the - /includes/classes/split_page_results.php file.
When I was clicking on these links :
http://bambino.co.in/index.php?main_page=products_new
http://bambino.co.in/index.php?main_page=products_all
http://bambino.co.in/index.php?main_page=specials
... etc

I was getting this error:

1064 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 '*) as total FROM zen_products p left join zen_manufacturers m on (p.manufacture' at line 1
in:
[select count(distinct *) as total FROM zen_products p left join zen_manufacturers m on (p.manufacturers_id = m.manufacturers_id) left join zen_products_to_categories p2c on p.products_id = p2c.products_id left join zen_products_description pd on p.products_id = pd.products_id WHERE p.products_status = 1 AND pd.language_id = 1 and p.products_date_added >=20140706]


After making the corrections (as suggested by Lat9; http://www.zen-cart.com/showthread.p...products/page2) all was sorted.