PDA

View Full Version : Category Specials



michael_s
09-01-2007, 09:00 AM
Can anyone please help me!

When I add more than one category as special I get the following error:

" 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 count(*) as total from products A, products_description B , products_to_categories E left join specials C on C.products_id = A.products_id left join special_product F on A.products_id = F.product_id left join special_category D on E.categories_id = D.categ_id where E.categories_id = 44 and E.products_id = A.products_id and A.products_id = B.products_id and B.language_id = '1' "


More... (http://www.oscommerce.com/community/contributions,3831)