Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

problems with admin side - specials - newsletter


Recommended Posts

I am having a problem with the admin side of osCommerce.


With particular sections of the administration panel i get the following error if there are no records in the database:



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


select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20





This happens with the products/categories, speicals, newsletters.


It goes away if I add records manaully to the database.


Surely this behaviour can't be by design, but I did a fresh install of version 2.2 and encounted the same probem. Does anyone have any idea how to avoid this?


Thanks heaps.

Link to comment
Share on other sites


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

  • Create New...