stephan.gerlach Posted June 3, 2005 Share Posted June 3, 2005 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?? Link to comment Share on other sites More sharing options...
stephan.gerlach Posted June 3, 2005 Author Share Posted June 3, 2005 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? Link to comment Share on other sites More sharing options...
Guest Posted June 3, 2005 Share Posted June 3, 2005 soundslike a bad install or contributions you have been trying to add are not installed properly Link to comment Share on other sites More sharing options...
Jan Zonjee Posted June 3, 2005 Share Posted June 3, 2005 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). Link to comment Share on other sites More sharing options...
stephan.gerlach Posted June 3, 2005 Author Share Posted June 3, 2005 Thanks alot. problem sorted Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.