On the website im designing, if you click the main image on the home page, it will take you to view "all products". I didnt want this page to show up, so in the "All Listing" in admin I changed everything to "0" and now, as you can see, you get a page with a bunch of lines.

When I go to config>maximum values and change "maximum display of products all page" from 10 to 0, I get the following 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 9
in:
[SELECT p.products_type, p.products_id, 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 order by pd.products_name limit -0, 0]


How can I turn this page off? I am going to change the link so that it is directed to another page that im designing, but I dont want "All Products" to be a page that could be accessible and I dont want it to show up in my footer.

My website:

www<dot>homeandgiftavenue<dot>com

Thanks for your help!