Jump to content



Latest News: (loading..)

Hani1188

Member Since 14 Mar 2012
OFFLINE Last Active Jun 26 2012 06:42 AM
-----

Topics I've Started

Error when trying to edit a product

16 June 2012 - 02:50 AM

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'

[TEP STOP]