Our programmer added that a couple of weeks ago and works fine. This error has been ongoing for months now.
Printable View
Our programmer added that a couple of weeks ago and works fine. This error has been ongoing for months now.
What's your setting for Admin->Config->max values->Products Listing- Number Per Page?
For some reason it's using a zero for that setting and thus throwing the error you mention.
Setting is 12.
I was under the impression it was to do with cache?
No, the error is that somehow the code is generating a "LIMIT -0, 0" statement ... when the "-0" should be a positive integer.
Whatever condition is causing the split-page-class to calculate a 0 despite the built-in safeties is the root cause of your problem.
$listing_sql is generated by default_filters.php
$listing_sql is then passed to the split-page function via the product_listing.php module, to determine which subset ("page") of records to be used for displaying the product listing.
Then the template renders the output.
I suspect something to be amuck with either the customized SQL you have in the filters, perhaps causing a zero-result dataset that somehow fails to trigger any "sorry, no records found", and still attempts to pull up 0 records.