Warning: Division by zero ..split_page_results.php on line 76

[Sunabac]

Warning: Division by zero in /var/www/aaa/xxx.com/docs/yyy/includes/classes/split_page_results.php on line 76

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 '-0, 0' at line 10
in:
[SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status FROM Clive_products p LEFT JOIN Clive_manufacturers m ON (p.manufacturers_id = m.manufacturers_id), Clive_products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 order by p.products_date_added DESC, pd.products_name limit -0, 0]

I get the above error on a test site (test.pridepak.com/Clive) when you click the link for new products. The only change made in config/new listing is that I put "0" for weight. i have not work on it for a while, so there are no "new" products, but that should not give me an error like this, right?

Server info:

Server OS: Linux x2web04.myhosting.com 2.6.18-3-686 #1 SMP Mon Dec 4 16:41:14 UTC 2006 i686
PHP Version: 5.1.6 (Zend: 2.1.0)
Apache 2.0 Handler
Zen Cart 1.3.7
Database Patch Level: 1.3.7

[Ajeh]

Check your Maximum Values ... sounds like you set some to 0 ...

[Ajeh]

Most likely it is this setting:

New Products Listing- Number Per Page
Number of new products' listings per page

[Sunabac]

Most likely it is this setting:

Yes, thank you! I had Number per page 0 and Limit New to 0