weerd

Hi all, I've seen this problem before - it has to do with the mysql syntax and adding brackets in newer versions of mysql. this is the code that worked fo me: $products_query_raw = "select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from (" . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on p2c.categories_id = cd.categories_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . $languages_id . "' and cd.language_id = '" . $languages_id . "' order by $order"; Note the added open and close brackets "(" & ")" near TABLE_PRODUCTS_DESCRIPTION and TABLE_PRODUCTS_TO_CATEGORIES. Change this in both catalog_products_with_images.php & in catalog_products_with_images_full.php Hope this helps! And Thanks for the great contrib! :thumbsup:

Hi guys, First of all many, many, many, thanks to all the wonderful people for making such a great contrib!! I used the Short Description Mod ( www.oscommerce.com/community/contributions,3123 ) in my store before finding the godsend that is Easypopulate, so had to find a way to get EP to catch my short descr field and receive and give that data to my store - soo.....after much testing and a migraine (as i am new to the world of OSCommerce and php) i found out how to edit the easypopulate file to get it to work. I posted it on the Easy Populate & Products Attributes Contribution download - http://www.oscommerce.com/community/contributions,500 It's just so you can use a file comparison tool and do a search on "products_info" and you'll see what to add to your file. So hopefully this will help out some people that are new like me :blush: BTW - Surfalot - thanks for all the help u provide :D