Error 1104 message missing right side columns

[condorknight]

Hi need some help.

I get this message on my site under the new products on certain pages:

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 okay

 

select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '21' and p.products_status = '1' order by p.products_date_added desc limit 9

 

[TEP STOP]

 

and the right side columns are gone.

Any ideas on what caused this

 

Thanks

[arietis]

Hi need some help.

I get this message on my site under the new products on certain pages:

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 okay

 

there was someone else in the last day or so with the same problem. search the forums. if you put:

site:www.oscommerce.com/forums MAX_JOIN_SIZE

 

into google's search, the first link has the answer for you.

[condorknight]

Thank you for your help

[Guest]

this is a bug in MYSQL you need to be using v4.3 or above it was sorted out by the lads at MYSQL

[condorknight]

The mysql version is 5.0.24a

The max size is 300000

 

It has fixed a couple but three to four are still showing the problem error

if you would like to check it out i can post the link here