webmaster69 Posted March 20, 2009 Share Posted March 20, 2009 Hi, first of all what a fantastic contribution, it's saved me hours of work and a lot of head scratching and it's so simple to use. I have been sucessfully using feedmachine for at least 2 years with no problems at all. Today I have added some new products to my store and now get an error when generating the feed. So I'm thinking it may have something to do with the amount of products (I now have 930 products). Below is a copy of the error which occurs when the feed is generated languages array built currencies array built taxes array built countries array built categories array built 1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okaySELECT COUNT(*) as count FROM products p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id LEFT JOIN manufacturers_info mi ON m.manufacturers_id = mi.manufacturers_id AND pd.language_id = mi.languages_id LEFT JOIN products_to_categories ptc ON pd.products_id = ptc.products_id LEFT JOIN specials s ON ptc.products_id = s.products_id LEFT JOIN categories c ON ptc.categories_id = c.categories_id LEFT JOIN categories_description cd ON c.categories_id = cd.categories_id AND pd.language_id = cd.language_id WHERE pd.language_id IN(1) AND p.products_status = 1 ORDER BY p.products_id[TEP STOP] Thanks Frank Quote Link to comment Share on other sites More sharing options...
Jim_System Posted March 25, 2009 Share Posted March 25, 2009 Hi, the same thing has happened to me, I now have the same fault. Any help on this from the osCommerce community would be really appreciated. I have also tried all the other feed generating contributions and I can't find any others that generate feeds for the different PPC / Search engines. So it would be a real shame if feedmachine can not be fixed, as I know many of the osCommerce community rely on it. Thanks Jim Quote Link to comment Share on other sites More sharing options...
webmaster69 Posted April 6, 2009 Author Share Posted April 6, 2009 Any help on this from the osCommerce community would be really appreciated. I have also tried all the other feed generating contributions and I can't find any others that generate feeds for the different PPC / Search engines. So it would be a real shame if feedmachine can not be fixed, as I know many of the osCommerce community rely on it. The version I had installed was version 2.13, I have tried using all the other later versions as well but get the exact same error. Thanks Frank Quote Link to comment Share on other sites More sharing options...
webmaster69 Posted April 10, 2009 Author Share Posted April 10, 2009 catalog/admin/feedmachine.php Approx line 270 find the line that starts $master_query = tep_db_query('SELECT s.*, cd.*, c.*, ptc.*, mi. And add before this line // SQL_BIG_SELECTS = 1 - added to solve 1104 MYSQL error message tep_db_query("set sql_big_selects=1"); That’s it! Cheers Frank Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.