Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Feedmachine perfect for 2 years, now have error


Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 2 weeks later...

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...