Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

"specials" error message


edwinx

Recommended Posts

Posted

Hi,

 

when trying to go to the specials.php page, I get this:

 

 

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

 

any idea? the specials box in the left side was removed, so i tried to access the specials.php directly. I am using MySQL 4.1.14 and PHP Version 4.3.11

Posted

the osc documentation of the latest release includes instruction for manual upgrade.

Archived

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

×
×
  • Create New...