Repairing the Search Results module in DotNetNuk 4.x

Just recently i answered a question on the DotNetNuke forums about re installing the Search Results module. This is somewhat tricky as you cannot do it by hand.. it can only be done by sql script.

Thist is the complete procedure

1. Download a DotNetNuke installation zip with the same version as the application you want to repair (you can quickly find out the version of your application by going to Host > HostSettings).
2. Copy the files /admin/Search/SearchResults.ascx and admin/Search/SearchResults.ascx.vb to the same folder in your broken site
3. You might also need to check \admin\Search\App_LocalResources\SearchResults.ascx.resx
4. log on to your site as host, and go to Host > SQL
5. copy the following script in the page, select "run as script" and click "Execute":

DECLARE @DesktopModuleID INT
DECLARE @ModuleDefID INT
DECLARE @ModuleName NVARCHAR(50)
SELECT @ModuleName = 'Search Results'
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules]([FriendlyName],[Description] ,[Version] ,[IsPremium] ,[IsAdmin] ,[FolderName],[ModuleName],[SupportedFeatures] ) VALUES (@ModuleName,'The Search Reasults module provides the ability to display search results.' ,'01.00.00' ,0,0 ,@ModuleName ,@ModuleName ,0 )
SELECT @DesktopModuleID = SCOPE_IDENTITY()
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions]([FriendlyName],[DesktopModuleID],[DefaultCacheTime]) VALUES (@ModuleName,@DesktopModuleID,-1)
SELECT @ModuleDefID = SCOPE_IDENTITY()
INSERT INTO {databaseOwner}[{objectQualifier}ModuleControls] ([ModuleDefID] ,[ControlSrc] ,[ControlType] ,[ViewOrder] ,[SupportsPartialRendering]) VALUES (@ModuleDefID ,'Admin/Search/SearchResults.ascx' ,-1 ,0 ,0)

The search results module is now registered again. Now the only thing that needs to be done is to create a new page in your portal and put the Search Results module in it (The page does not have to exist in the menu, but must be enabled).