Feedmachine perfect for 2 years, now have error

[webmaster69]

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

[Jim_System]

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

[webmaster69]

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

[webmaster69]

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