Hello all, I've been stuck on this error for almost a month. I tried many avenues to fix it but, unsuccessful. What is hapening is I am able to create a product in any category no problem. But if I go back and try to edit the created product, I get this message. I did all sorts or reasearch online and tried everything I could possiblly find can someone please help me?
I am running oscommerce 2.3.1 MySQL 5.5.23-55
PHP Version 5.2.17
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 'p, products_description pd where p.products_id = '33' and p.products_id = pd.pro' at line 1
select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.products_ship_sep, p.manufacturers_id products p, products_description pd where p.products_id = '33' and p.products_id = pd.products_id and pd.language_id = '1'
Latest News: (loading..)
Hani1188Member Since 14 Mar 2012
OFFLINE Last Active Jun 26 2012 06:42 AM
- Group Members
- Active Posts 16
- Profile Views 1,104
- Age Age Unknown
- Birthday Birthday Unknown