1064 Error in Syntax

I am currently getting the below error. This keeps on happening now and again (once every 2 weeks) and my website will be down for a few hours but will then correct itself and work ok! Any ideas?

e.g http://www.thefashionhut.co.uk/vans-...0a&filter_id=6


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 7
in:
[select p.products_quantity, p.products_rrp, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products p left join zen_specials s on p.products_id = s.products_id, zen_products_description pd, zen_manufacturers m where p.products_status = 1 and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '18' limit -0, 0]

Upon further reading in this forum it seems my database cache is the problem.

Do I need to do this?: http://www.zen-cart.com/forum/showth...cache+turn+off

What version of Zen Cart are you using?

Version is 1.3.8a; Database Patch Level: 1.3.8

What do you have in Admin->Config->Maximum Values for settings that are set to 0 ?

Just Maximum Orders Detail Display on Admin Orders Listing

Okay. What addons have you installed?

Google Base Feeder and SEO URLs. SEO URLs was only installed a few weeks ago but this problem has been ongoing for over 2 months now.

Google Base Feeder was installed approx. 3 months ago.

DrByte,

Any ideas? Website has just gone down again!

Quote:

---

select p.products_quantity, p.products_rrp, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, ...

---

Which addon has added this products_rrp field to your products table?

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.