Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

SQL error in product details


Recommended Posts



Successfully installed the mod on clean MS2, however I'm getting this error when I click into any products on the new store(s):


1064 - syntax error near '((products p left join manufacturers m on p.manufacturers_id = m.manufacturers_i' at line 1

select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_qty_blocks, p.products_tax_class_id, p.distributors_id, IF(s.status = '1' AND s.stores_id = '2', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = '1' AND s.stores_id = '2', s.specials_new_products_price, p.products_price) as final_price from products_to_categories p2c, ((products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd) left join specials s on p.products_id = s.products_id and s.stores_id = '2') INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '2' AND p.products_status = '1' and p.products_id = '15' and pd.products_id = '15' and pd.language_id = '1'


Can anyone help?

Running on PHP5 with mysql3.23




Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...