Hi Ash,
I Had the same issue, attempting to set the module setting via the db didn't work either. For the record, I tried:
declare @moduleID int, @groupSearchResultsTabId int
set @moduleID = 1314 -- replace with your group detail module id
set @groupSearchResultsTabId = 365 -- replace with your group search results tab id
select * from dbo.ModuleSettings where ModuleID= @moduleID and SettingName like '%tabid%'
update dbo.ModuleSettings set SettingValue = @groupSearchResultsTabId where ModuleID = @moduleID and SettingName = 'SearchResultsTabID'
INSERT INTO [ModuleSettings] ([ModuleID],[SettingName],[SettingValue]) VALUES (@moduleID, 'GroupSearchResultsTabID', @groupSearchResultsTabId)
The solution for me was to edit \DesktopModules\Smart-Thinker - UserGroup\UserGroupDetail.ascx and replace the two references to GroupSearchResultsTabID (one for category search, one for tags) with the tab id to my group search results page, hardcoding the result. ie:
Catgegory: NavigateUrl='<%# DotNetNuke.Common.Globals.NavigateURL(365, Null.NullString, "CID=" + Eval("CategoryID")) %>'
Tags: NavigateUrl='<%# DotNetNuke.Common.Globals.NavigateURL(365, Null.NullString, "S=" + Container.DataItem) %>'
Cheers,
Tim