Admin>Tools>Admin Settings = '1064 You have an error in your SQL syntax;'

[gaffettape]

Hi,

When I go to 'Admin>Tools>Admin Settings' 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 1
in:
[select admin_id, admin_name, admin_email, admin_pass, admin_level from admin order by admin_name limit -0, 0]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I'm using ZC v1.3.9f - PHP v5.3.1 - MySQL v5.0.91-community

Anyone have any ideas what could cause this error message?

Thanks.

[Ajeh]

Check the Configuration ... Maximum Values ... and see what the setting is for:
Search Results Per Page

The default is 20 ...

If set to 0, you will get errors like this ...

[gaffettape]

Thanks Linda,

Yep that did it

I changed that setting a few days ago as I wanted to show all the search results on a single page, also I want to show all the products in a category (i.e Product Listing) on the same page as well. What would be the correct setting to achieve this, without causing such errors?

Thanks

[Ajeh]

A really big number ...

[gaffettape]

A really big number ...

Haha lol, got ya

Thanks Linda