Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1064 Error when clicking on "Specials"


Recommended Posts

I am receiving an odd error when I click on specials (I have active specials right now):




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


select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9"





I am NOT getting this error because my content = 0 (a familiar bug when I see 1064). Instead, I have 2 active specials going on right now. Any advice as to why this is coming about????





Link to comment
Share on other sites

Well the negative limit (-9, 9) is invalid on your newer version of mysql.


1. I would apply the changes to split_page_results.php (both admin and catalog versions).


2. If you are still getting the negative lower limit then it must be comming from a contribution that is generating the sql code. Have you installed any contributions regarding specials? If so you'll need to check the code.




Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...