Guest Posted March 10, 2007 Share Posted March 10, 2007 Hi, I having problem getting the STORE FEEDS contribution to work. I am trying to run the google feed but all I get is the following error: : SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.cfbsupplies.co.uk/product_info.php?language=en¤cy=GBP&products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.cfbsupplies.co.uk/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM categories, categories_description, products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND products.products_status != 0 AND products.products_price != 0 AND products.products_price != '' AND products_description.language_id = '1' AND products_description.language_id = '1' AND categories_description.language_id = '1' ORDER BY products.products_id ASC I have no idea what this means and was wondering if someone could help me fix it. Thanks David. Link to comment Share on other sites More sharing options...
Nullachtfuffzehn Posted March 10, 2007 Share Posted March 10, 2007 First thing I would check out is, if the table products has a field called manufacturers_id. Usually it should be there. If so, check your database, in case of need try to repair it. Don't forget to make a backup before. If the field is not there, you're in trouble... No, not really, you can add the field easily with your database admin console. Link to comment Share on other sites More sharing options...
Guest Posted March 10, 2007 Share Posted March 10, 2007 First thing I would check out is, if the table products has a field called manufacturers_id. Usually it should be there. If so, check your database, in case of need try to repair it. Don't forget to make a backup before. If the field is not there, you're in trouble... No, not really, you can add the field easily with your database admin console. Thanks for the reply ullachtfuffzehn. Yeap its there, type: int (11), Null: yes, Default: Null, whatever that means. What the next thing to check? Link to comment Share on other sites More sharing options...
Nullachtfuffzehn Posted March 10, 2007 Share Posted March 10, 2007 Thanks for the reply ullachtfuffzehn. Yeap its there, type: int (11), Null: yes, Default: Null, whatever that means. What the next thing to check? That sounds weird... The column is there, but SQL doesn't recognize it. So did you try to optimize/repair the table? Link to comment Share on other sites More sharing options...
Guest Posted March 11, 2007 Share Posted March 11, 2007 looks like the line does not conform to mysql 5x. You could try eliminating the joins and replace them by doing the checks in the where clause in your script. Link to comment Share on other sites More sharing options...
Nullachtfuffzehn Posted March 11, 2007 Share Posted March 11, 2007 looks like the line does not conform to mysql 5x. You could try eliminating the joins and replace them by doing the checks in the where clause in your script. Sorry if I ask, but how can you replace joins with where clauses in SQL? That doesn't make any sense to me. Joins and where clauses are two different kinds of things. I'm working with databases and SQL for twenty years now and can't believe that mySQL 5.0 dropped it now... I'm just curious... Has the SQL standard changed somehow and I didn't notice it? Link to comment Share on other sites More sharing options...
Guest Posted March 11, 2007 Share Posted March 11, 2007 Sorry if I ask, but how can you replace joins with where clauses in SQL? That doesn't make any sense to me. Joins and where clauses are two different kinds of things. I'm working with databases and SQL for twenty years now and can't believe that mySQL 5.0 dropped it now... I'm just curious... Has the SQL standard changed somehow and I didn't notice it? who said mysql5x dropped it? You can go around rearranging the tables and the joins to make it work. Or you could properly join all tables or you could use the "where" clause instead. Either way will work. This problem is caused likely because the order of the tables is incorrect with the joins and not with the database contents. Link to comment Share on other sites More sharing options...
charly Posted August 2, 2007 Share Posted August 2, 2007 Hi I have the same problem can you explain what i need to do in laymen terms ? or should i get someone to sort it for me Charly Charly My fav site Spend most my cash there dont tell the wife:-) Link to comment Share on other sites More sharing options...
Guest Posted November 2, 2007 Share Posted November 2, 2007 Hello all, I've had the same problem and found the solution to be related to the current version throwing up errors when using MySQL 5. This can be resolved by making the following change: Around line 89: FROM categories, categories_description, products, products_description, products_to_categories Change to: FROM (categories, categories_description, products, products_description, products_to_categories) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.