1064 SQL syntax Error - Max Value Changed ...HELP!!

[Canvas101]

Hi,

I really hope one of you wise people in here can help me solve my problem.

Please see the following page;

http://www.canvas101.co.uk/products_all.html

Now this page used to display 20 product here...automatically generated through zen Cart, it used to show all the products that were for sale through this page.

Anyway I manegd to find out how to turn these of after an hour of searchig around.,..

Anyway my step to getting those images removed invloved the follwing path...

From the admin panel of the site, I clicked on configuration the maximum setting, about 7th from the bottom you see a option called "Maximum display of products all pasges.

Now I changed this setting to "0" so no images will display on the

Gallery page - http://www.canvas101.co.uk/products_all.html

The only thing now is that Im faced with some kind of bad code 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 '-0, 0' at line 8
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 FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id), products_description pd WHERE p.products_status = 1 and p.products_destination = 0 AND p.products_id = pd.products_id AND pd.language_id = 1 order by pd.products_name limit -0, 0]

If i changed the total maximum value to 1 or 2 and the gallery page then works fine, its almost as if she dont like two people touch....What im trying to do is change so no products dispaly, it becomes a white section.

I really would appreciate anyoness help on this very urgent matter.

Many Thanks

[DrByte]

1. Don't set it to 0.

2. Please explain again *why* you chose to set it to 0 ... ?
Are you saying you don't want an "all products" page ?

Setting the display for "all products" to zero doesn't make any sense ...


3. And, I see you've set your Products New max-per-page to "one" ... which means folks have to scroll through your 254 products one-by-one ... which also seems rather non-friendly. Then again, you've turned off the New Products link so maybe you don't want folks using that page at all anyway.

[Canvas101]

Dr Byte.

Ok what im trying to do is leave the page as it is the gallery page... The only thing I dont want displaying on this page is the all products at the bottom. I want to get rid of the feature that displays the 254 products. All I want is a blank page so i can add my own page created in HTML. I know how to add my new page I just dont know how to get rid of the products that display at the bottom. I figures if i change the figure to 0 this will stop any products from displaying, but instead brings up the error i posted in previous page.

Many Thanks

[DrByte]

So, you're trying to completely change the functionality of the "all products" page to make it be an independent page which only displays static content which you manually edit?

If that's your intent, why don't you just create a true dedicated page for that purpose?
The About Us contribution is an example of a static added page which could be adapted for such a purpose.
It would be a lot easier to manage that way. Plus, your visitors could access it as index.php?main_page=mygallery (or whatever you call it)