SQL syntax error

[jdippenaar]

Hi,

I'm getting the error below when I click on 'Catalog' / 'Categories/Products' :

 

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, MAX_ROW_LISTS_OPTIONS' at line 1

select * from products_options where language_id = '1' order by products_options_id limit -0, MAX_ROW_LISTS_OPTIONS

 

The 'limit -0', is the issue as that is not valid SQL but how do I fix it and where does the '-0' come from?

 

Thanks heaps all!

 

J

[flashzoomer]

you need to find problem in the includes/classes/split_page_results.php