oscommerce 1104 ERROR Fix

[michael_s]

This fix applies to sites suffering from the folllowing error message on their product listing pages:


1104 - The SELECT would examine more rows than MAX_JOIN_SIZE. Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ok

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id,
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price)
as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c
left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id
and pd.language_id = '4' and p2c.categories_id = '230' order by pd.products_name limit 0, 10

Fix works on sites running php4 or above, and oscommerce 2.2, although ti may also work on earlier versions of both.

No files to upload, just amend code in product_info.php and index.php

More...