Debug Message - Perch 3.0.3
[1] SELECT * FROM perch3_pages WHERE pagePath='/search-results.php' LIMIT 1
[1] SELECT * FROM perch3_shop_cart WHERE cartID=37
[1] SELECT * FROM perch3_shop_cart WHERE cartID=37
Using template: /templates/search/search-form.html
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[12] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath REGEXP '[[:<:]]products\/?[[:>:]]' AND LENGTH(catTreePosition) - LENGTH(REPLACE(catTreePosition, "-", ""))=1) ORDER BY catTreePosition ASC
[12] Using template: /templates/categories/side-nav.html
Using cart from cache.
[27] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
Using template: /addons/apps/perch_shop/templates/shop/cart/mini-cart.html
Using template: /addons/apps/perch_members/templates/members/login/mini-login.html
[65] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_brands main ON idx.itemID=main.brandID AND idx.itemKey='brandID' AND ((idx.indexKey='status' AND idx.indexValue='1')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[10] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_brands main ON idx.itemID=main.brandID AND idx.itemKey='brandID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='brandID' AND idx2.indexKey='title' AND idx.itemID IN ('1', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '2', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '3', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '4', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '5', '50', '51', '52', '53', '54', '55', '56', '57', '58', '59', '6', '60', '61', '62', '63', '64', '65', '7', '8', '9') WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, brandID ) as tbl WHERE (brandDeleted IS NULL) GROUP BY itemID, sortval ORDER BY RAND() LIMIT 0, 10
[10] Using template: /addons/apps/perch_shop/templates/shop/brands/list2.html
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[12] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath REGEXP '[[:<:]]products\/?[[:>:]]' AND LENGTH(catTreePosition) - LENGTH(REPLACE(catTreePosition, "-", ""))=1) ORDER BY catTreePosition ASC
[12] Using template: /templates/categories/side-nav.html
Search term: mob
[nil] SELECT SQL_CALC_FOUND_ROWS DISTINCT 'PerchContent_SearchHandler' AS source, MATCH(ci.itemSearch) AGAINST('mob') AS score, r.regionPage AS col1, ci.itemSearch AS col2, ci.itemJSON AS col3, r.regionOptions AS col4, p.pageNavText AS col5, p.pageTitle AS col6, regionTemplate AS col7, r.regionKey AS col8 FROM perch3_content_regions r, perch3_content_items ci, perch3_pages p WHERE r.regionID=ci.regionID AND r.regionRev=ci.itemRev AND r.pageID=p.pageID AND r.regionPage!='*' AND r.regionSearchable=1 AND (MATCH(ci.itemSearch) AGAINST('mob') OR MATCH(ci.itemSearch) AGAINST('mob') ) AND r.regionPage LIKE '/%' UNION SELECT 'PerchShop_SearchHandler' AS source, MATCH(s.searchBody) AGAINST('mob') AS score, p.title, p.productSlug, p.productDynamicFields, p.productTemplate, productID, "", "", "" FROM perch3_shop_search s, perch3_shop_products p WHERE p.productDeleted IS NULL AND p.productID=s.itemKey AND s.itemType='product' AND MATCH(s.searchBody) AGAINST('mob') AND p.productID IN ( SELECT itemID FROM perch3_shop_index WHERE itemKey='productID' AND itemID=p.productID AND indexKey='status' AND indexValue=1 ) ORDER BY score DESC LIMIT 0, 10
[nil] SELECT SQL_CALC_FOUND_ROWS DISTINCT 'PerchContent_SearchHandler' AS source, 0-(LENGTH(r.regionPage)-LENGTH(REPLACE(r.regionPage, '/', ''))) AS score, r.regionPage AS col1, ci.itemSearch AS col2, ci.itemJSON AS col3, r.regionOptions AS col4, p.pageNavText AS col5, p.pageTitle AS col6, regionTemplate AS col7, r.regionKey AS col8 FROM perch3_content_regions r, perch3_content_items ci, perch3_pages p WHERE r.regionID=ci.regionID AND r.regionRev=ci.itemRev AND r.pageID=p.pageID AND r.regionPage!='*' AND r.regionSearchable=1 AND ci.itemSearch REGEXP '[[:<:]]mob[[:>:]]' AND r.regionPage LIKE '/%' UNION SELECT 'PerchShop_SearchHandler' AS source, p.stock_level AS score, p.title, p.productSlug, p.productDynamicFields, p.productTemplate, p.productID, "", "", "" FROM perch3_shop_search s, perch3_shop_products p WHERE p.productDeleted IS NULL AND p.productID=s.itemKey AND s.itemType='product' AND ( concat(" ", s.searchBody, " ") REGEXP '[[:<:]]mob[[:>:]]' ) AND p.productID IN ( SELECT itemID FROM perch3_shop_index WHERE itemKey='productID' AND itemID=p.productID AND indexKey='status' AND indexValue=1 ) ORDER BY score ASC LIMIT 0, 10
[0] SELECT FOUND_ROWS() AS `count`
Using template: /templates/search/search-result.html
Updated
Can you post your full diagnostics report?
It looks like you've got 50+ items in your
perch3_shop_searchtable. Do they look sane to you?Yes, all of the data looks right
Is it always zero results, no matter the search term?
Yes, that's right.
Any way to fix this?
I'm not sure I have any suggestions as to why it's not matching.