lblanks240 Posted August 17, 2010 Posted August 17, 2010 i am getting the following error when i try to update a product how can i fix it 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_to_rss from products p, products_description pd where p.products_id' at line 1 select pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, 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.manufacturers_id from, p.products_to_rss from products p, products_description pd where p.products_id = '8013' and p.products_id = pd.products_id and pd.language_id = '1' [TEP STOP] thanks lenard Quote
♥FWR Media Posted August 17, 2010 Posted August 17, 2010 (edited) i am getting the following error when i try to update a product how can i fix it 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_to_rss from products p, products_description pd where p.products_id' at line 1 select pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, 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.manufacturers_id from, p.products_to_rss from products p, products_description pd where p.products_id = '8013' and p.products_id = pd.products_id and pd.language_id = '1' [TEP STOP] thanks lenard The problem is as below ( in red ) p.manufacturers_id from, p.products_to_rss from products p There could be other problems with the query but I just reported on the obvious issue. Edited August 17, 2010 by FWR Media Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work.
lblanks240 Posted August 17, 2010 Author Posted August 17, 2010 The problem is as below ( in red ) p.manufacturers_id from, p.products_to_rss from products p There could be other problems with the query but I just reported on the obvious issue. thanks it worked Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.