Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mysql problem after deleting sub category


janice171

Recommended Posts

Hi,

 

i deleted some sub categories that appeared in the 'specials' category and now i get this error message in the admin panel...

 

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]

 

...does anyone know where or how this can be resolved??

 

thank you

 

janice

Link to comment
Share on other sites

I FOUND THE ANSWER IN THIS THREAD

http://www.oscommerce.com/forums/index.php?sho...06entry687806

 

Hi,

 

i deleted some sub categories that appeared in the 'specials' category and now i get this error message in the admin panel...

 

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]

 

...does anyone know where or how this can be resolved??

 

thank you

 

janice

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...