please help me about Froogle.php

[william_c]

I have installed the Froogle Feed Generator (http://breakmyzencart.com), when I run the script, the system return SQL error message:

: SQL error Unknown column 'p.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.brandbags.biz/index.php?main_page=',pt.type_handler,'_info&currency=USD&products_id=' ,p.products_id) AS link, 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 title, 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_link, pc.categories_id AS prodCatID, c.parent_id AS catParentID, cd.categories_name AS catName FROM categories c, categories_description cd, products p, products_description pd, products_to_categories pc left join manufacturers m on ( m.manufacturers_id = p.manufacturers_id ) left join specials s on ( s.products_id = p.products_id AND ( (s.expires_date > CURRENT_DATE) OR (s.expires_date = 0) ) ) left join 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

Information:

• Zen Cart 1.3.0.2
• MySQL 5.0.24
• PHP Version: 4.4.1 (Zend: 1.3.0)

Please help me how to resolve the problem. Thanks!

[superprg]

p.manufacturers_id'?
It should be m.manufactureres_id I think

[william_c]

What's your meaning? I think this is MYSQL version problem. How to change the SQL code?

[JayMcB74]

The error is due to running SQL 5. The From statement now needs to inclose the tables.

  FROM 
categories c, 
categories_description cd, 
products p, 
products_description pd, 
products_to_categories pc

needs to be:

 FROM 
(categories c, 
categories_description cd, 
products p, 
products_description pd, 
products_to_categories pc)

corrected sql statement in froogle.php ->

$sql = "
        SELECT concat( '" . $productURLstart . $productURLend . "' ,p.products_id) AS product_url,
        p.products_model AS prodModel,
        p.manufacturers_id,
        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 (" . TABLE_CATEGORIES . " c,
        " . TABLE_CATEGORIES_DESCRIPTION . " cd,
        " . TABLE_PRODUCTS . " p,
        " . TABLE_PRODUCTS_DESCRIPTION . " pd,
        " . TABLE_PRODUCTS_TO_CATEGORIES . " pc)
        left join " . TABLE_MANUFACTURERS . " m on ( m.manufacturers_id = p.manufacturers_id )
        left join " . TABLE_SPECIALS . " s on ( s.products_id = pc.products_id AND ( (s.expires_date > CURRENT_DATE) OR ($
        left join " . TABLE_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
        ";