error message 1064-newsletters and product notification

I have two sites in development using zen cart. One is using a lot of zen cart features, the other has been stripped down. Both are on the same server using the same sql version which is MySQL 5.0.45

For the more customized site, which has newsletters and product notification turned off, I am getting the following message:

Status Action
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 newsletters_id, title, length(content) as content_length, length(content_html) as content_html_length, module, date_added, date_sent, status from newsletters order by date_added desc 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.

Message does not show on the other site so it isn't the sql version--what can I do to get rid of this message, and if we aren't using newsletters or product notification on that site anyway, does the error message matter?

When you see SQL error messages talking about "-0, 0", that's usually a result of having one of your Admin->Configuration->Maximum Values set to 0 mistakenly ... specifically the one that controls how many entries to list on the page where the error is occurring.

If you've got the newsletter stuff "turned off" because you're not using it, then why are you accessing that page? Or are you getting that error on some other page for some reason?

You are right, I had the search results per page set to 0. Changed it and the Newsletter and Product Notifications Manager page is working and it was also affecting a few other pages, i.e. Template Selection.
I think, because this site has so many features turned off, I probably at some point set the search results to 0 in an attempt to turn off the search results feature, which of course didn't work.
Thanks so much for your quick reply, the site is going beta live today and getting the admin working at 100% is a big relief to me.
Gail Scanlan