I have zen cart version 1.3 and the feeder is not working. I keep getting this error when generating a file:
: SQL error Unknown column 'p.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://trinorthlighting.com/Store/index.php?main_page=',pt.type_handler,'_info¤cy=USD&products_id=' ,p.products_id) AS product_url, p.products_model AS prodModel, p.products_weight, p.products_type, m.manufacturers_name AS mfgName, m.manufacturers_id, p.products_id AS id, pd.products_name AS name, pd.products_description AS description, p.products_status AS prodStatus, FORMAT( IFNULL(s.specials_new_products_price, p.products_price),2) AS price, p.products_image AS image_url, pc.categories_id AS prodCatID, c.parent_id AS catParentID, cd.categories_name AS catName FROM zen_categories c, zen_categories_description cd, zen_products p, zen_products_description pd, zen_products_to_categories pc left join zen_manufacturers m on ( m.manufacturers_id = p.manufacturers_id ) left join zen_specials s on ( s.products_id = p.products_id AND ( (s.expires_date > CURRENT_DATE) OR (s.expires_date = 0) ) ) left join zen_product_types pt on p.products_type = pt.type_id WHERE p.products_price > 0 AND p.products_id=pd.products_id AND p.products_id=pc.products_id AND pc.categories_id=c.categories_id AND c.categories_id=cd.categories_id ORDER BY p.products_id ASC