Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

problems with admin side - specials - newsletter


jhardman2

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:

 

Specials

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

 

[TEP STOP]

 

 

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

Archived

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

×
×
  • Create New...