Eaviator Posted July 14, 2011 Share Posted July 14, 2011 (edited) OK, I now have run into a problem. While I was checking my SEO for a product and was editing it I have run into this code: 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 'from products p left join products_to_discount_categories ptdc on 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_qty_blocks, 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 products p, ptdc.discount_categories_id from products p left join products_to_discount_categories ptdc on p.products_id = ptdc.products_id, products_description pd where p.products_id = '39' and p.products_id = pd.products_id and pd.language_id = '1' [TEP STOP] Can someone help me figure out what's causing it. I suspect that it's the catalog/admin/categories.php query that I asked about a couple of pages back because this is where the code resides, can someone help me figure out what I've done wrong here? Many thanks in advance all, much appreciated. DougB Edited July 14, 2011 by Eaviator Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.