Howdy,
I have setup a Search site which looks at a folder that contains numerous sites under the folder.
Everything else I have setup is basically a direct copy of another search page that works. However this is the error message I get (in red too) that appears when I hit the search button…
File: [SYSTEM_ROOT]/core/include/assertions.inc Line: 479
Message: [ASSERT EXCEPTION] DB Error: unknown error
SELECT DISTINCT(ai.assetid), SUM(ai.score) as search_score, SUM(ai.score) AS sort_by FROM sq_asset_indexing ai, sq_asset_link_tree alt1, sq_asset_link_tree alt2, sq_asset_link al1, sq_asset_link al2, sq_asset a WHERE a.assetid = ai.assetid AND al1.majorid = '91' AND al1.linkid = alt1.linkid AND alt2.treeid LIKE (alt1.treeid || '%') AND alt2.linkid = al2.linkid AND ai.assetid = al2.minorid AND a.status IN ('16') AND a.type_code IN (SELECT type_code FROM sq_asset_type_inherited WHERE inherited_type_code IN ('page_standard', 'pdf_file', 'word_doc')) AND (ai.value LIKE '%display%') GROUP BY ai.assetid, sort_by [nativecode=ERROR: aggregates not allowed in GROUP BY clause] (LINE 747 IN [SYSTEM_ROOT]/packages/search/search_manager/search_manager.inc)
This is a known bug in RC2. Set your sort order to "Name" instead of Relevance and it'll work.
Oh my god it worked! :lol: Thankyou so much for the quick response…
Ahhh I could just kiss you man!
Thankfully I shall refrain from doing so 
Oh, I'm just happy you're happy. 
(And quiet, the rest of you).