I am trying to move a DotNetNuke site to a new host. The site was version 4.7.0. Performed all incremental updates through 6.1.4 so that the current site has the same version of the destination on the new host. Using the Database Publishing Wizard, I get the following error. I am not sure what this means though or how to resolve. I am relatively new to DNN and any help would be greatly appreciated. Thanks.
TITLE: SqlPubWiz
------------------------------
An error occured while trying to publish the following script:
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[EventsMasterAvailableModules]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROCEDURE [dbo].[EventsMasterAvailableModules]
(
@PortalID int,
@ModuleID int
)
AS
Select @ModuleID as ModuleID, c.PortalID, 0 as MasterID, a.ModuleID as SubEventID, a.ModuleTitle as SubEventTitle
from dbo.Modules a
left join dbo.ModuleDefinitions b on a.ModuleDefID = b.ModuleDefID
left join dbo.DesktopModules d on b.DesktopModuleID = d.DesktopModuleID
left join dbo.TabModules t on a.ModuleID = t.ModuleID
left join dbo.Tabs c on t.TabID = c.TabID
where
d.BusinessControllerClass = ''DotNetNuke.Modules.Events.EventController, DotNetNuke.Modules.Events'' AND
c.PortalID = @PortalID and
a.ModuleID Not In (select SubEventID from dbo.EventsMaster where ModuleID = @ModuleID) AND
a.ModuleID Not In (select ModuleID from dbo.EventsMaster where SubEventID = @ModuleID) AND
a.ModuleID != @ModuleID
Group BY a.ModuleTitle, c.PortalID, a.ModuleID
Order By a.ModuleTitle
'
END
------------------------------
ADDITIONAL INFORMATION:
Invalid column name 'ModuleTitle'.
Invalid column name 'ModuleTitle'.
Invalid column name 'ModuleTitle'. (System.Web.Services)