I am running version 1.2.5 of zen because there is too much work to upgrade with customisations.

When running froogle contrib I get this message :

: SQL error 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| sql = SELECT concat( 'http://www.chalfontgifts.co.uk/shop/index.php?main_page=',pt.type_handler,'_info&currency=GBP&products_id=' ,p.products_id) AS product_url, p.products_model AS prodModel, p.products_weight, p.products_type, m.manufacturers_name AS mfgName, m.manufacturers_id, p.products_id AS id, pd.products_name AS name, pd.products_description AS description, p.products_status AS prodStatus, FORMAT( IFNULL(s.specials_new_products_price, p.products_price),2) AS price, p.products_image AS image_url, pc.categories_id AS prodCatID, c.parent_id AS catParentID, cd.categories_name AS catName FROM (categories c, categories_description cd, products p, products_description pd, products_to_categories pc) left join manufacturers m on ( m.manufacturers_id = p.manufacturers_id ) left join specials s on ( s.products_id = p.products_id AND ( (s.expires_date > CURRENT_DATE) OR (s.expires_date = 0) ) ) left join product_types pt on p.products_type = pt.type_id WHERE p.products_price > 0 AND p.products_id=pd.products_id AND p.products_id=pc.products_id AND pc.categories_id=c.categories_id AND c.categories_id=cd.categories_id ORDER BY p.products_id ASC


I think the problem is in this part of the code :

if (isset($_GET['generate'])) {
// Start TIMER
$stimer = explode( ' ', microtime() );
$stimer = $stimer[1] + $stimer[0];
// -----------
$sql = "
SELECT concat( '" . $productURLstart . "',pt.type_handler,'" . $productURLend . "' ,p.products_id) AS product_url,
p.products_model AS prodModel, p.products_weight, p.products_type,
m.manufacturers_name AS mfgName,
m.manufacturers_id,
p.products_id AS id,
pd.products_name AS name,
pd.products_description AS description,
p.products_status AS prodStatus,
FORMAT( IFNULL(s.specials_new_products_price, p.products_price),2) AS price,
p.products_image AS image_url,
pc.categories_id AS prodCatID,
c.parent_id AS catParentID,
cd.categories_name AS catName
FROM (" . TABLE_CATEGORIES . " c,
" . TABLE_CATEGORIES_DESCRIPTION . " cd,
" . TABLE_PRODUCTS . " p,
" . TABLE_PRODUCTS_DESCRIPTION . " pd,
" . TABLE_PRODUCTS_TO_CATEGORIES . " pc)

left join " . TABLE_MANUFACTURERS . " m on ( m.manufacturers_id = p.manufacturers_id )
left join " . TABLE_SPECIALS . " s on ( s.products_id = p.products_id AND ( (s.expires_date > CURRENT_DATE) OR (s.expires_date = 0) ) )
left join " . TABLE_PRODUCT_TYPES . " pt on p.products_type = pt.type_id
WHERE p.products_price > 0
AND p.products_id=pd.products_id
AND p.products_id=pc.products_id
AND pc.categories_id=c.categories_id
AND c.categories_id=cd.categories_id
ORDER BY
p.products_id ASC
";
$catInfo = "
SELECT
c.categories_id AS curCatID,
c.parent_id AS parentCatID,
cd.categories_name AS catName
FROM
(" . TABLE_CATEGORIES . " c,
" . TABLE_CATEGORIES_DESCRIPTION . " cd)
WHERE c.categories_id = cd.categories_id
";
function findCat($curID, $catTempPar, $catTempDes, $catIndex)
{
if( (isset($catTempPar[$curID])) && ($catTempPar[$curID] != 0) )
{
if(isset($catIndex[$catTempPar[$curID]]))
{

I need to add this : SET SESSION SQL_BIG_SELECTS=1;
somewhere in the code.
Please can someone advise where this should be placed and what syntax.

This only started happening since I added special prices to products.

Thanks
Laurie