mtrob

I did another clean install, and didn't have to make the change above, so I must have done that. I have products in for two stores and they show up properly in the product listings for each store, but I am still getting the same SQL error when I click on any of the products in either store: 1064 - You have an error in your SQL syntax 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 = '1', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = '1' AND s.stores_id = '1', 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 = '1) INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '1' AND p.products_status = '1' and p.products_id = '3' and pd.products_id = '3' and pd.language_id = '1' Any ideas most appreciated. Thanks, Todd

Hi, I'm having a problem with a clean install of osC 2.2-2 and M-S 1.9. Initially, the main store and secondary store showed the same products. I found that there wasn't anything setting the STORES_ID, so I added a "define ('STORES_ID' , <store number>);" to the end of the includes/configure.php for each store. That worked (did the database_tables.php too). I can now enter products and they show up in the right store, but if I click on any of those products to view them, I get: 1064 - You have an error in your SQL syntax 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 = '3', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = '1' AND s.stores_id = '3', 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 = '3') INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '3' AND p.products_status = '1' and p.products_id = '31' and pd.products_id = '31' and pd.language_id = '1' I found this code segment in includes/classes/price_schedule.php. I stepped through it as best I could and it seems to have everything substituted properly, but I'm not that strong on SQL. Any thoughts on what might be up? Thanks, Todd