error msgs in the admin section

[stephan.gerlach]

I get weird error messages in the admin section in the following menus

 

catalog>reviews

catalog>specials

catalog>products expected

 

and some other ones. The error messages look like this

 

select pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '1' order by p.products_date_available DESC limit -20, 20

 

and they basicly happen because those sections are empty. Ones i added somethign to those sections via phpmyadmin the errors are no longer.

 

Are there any easy fixes for that??

[stephan.gerlach]

I saw a few posts about problems like this and i tried a few things but it is still not working.

 

Anybody got any ideas?

[Guest]

soundslike a bad install or contributions you have been trying to add are not installed properly

[Jan Zonjee]

This is the infamous 'limit -20,20' bug. Follow the link for the solution (an offset is no longer allowed to have a negative value in more recent mysql versions).

[stephan.gerlach]

Thanks alot. problem sorted