New Products has SQL error message

[lilguppy]

On my website when you click on "New Products" I get this message

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 11
in:
its goes on with more info but is this an easy fix somewhere?

[schoolboy]

We actually need the "more info"... how else can we see where the error lies?

[Ajeh]

Sounds like a Maximum Value setting set to 0 but that is just a guess as there isn't enough information, as schoolboy has pointed out ...

[lilguppy]

Sounds like a Maximum Value setting set to 0 but that is just a guess as there isn't enough information, as schoolboy has pointed out ...

You were right thank you
I had it set to 0 so i switched it to 7 days

[lilguppy]

ok I did the switch but that didnt work
Still getting this error message
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 11
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, p.master_categories_id FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id), zen_products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 and p.products_date_added >=20100615 order by p.products_date_added DESC, pd.products_name limit -0, 0]

[Ajeh]

Check the other Maximum Values for anything related to New ... a search on NEW will help you find them ...

[lilguppy]

it worked thank you so much
I had to edit the Maximum values "New Products Page - Number per Pge" it was set to zero

[Ajeh]

Thanks for the update that fixing the Maximum Values on the New Products resolved the error on division by zero ...