I'm upgrading a site from DNN 4.9.4 to 5.5.0
AFTER doing the upgrade, I discovered that I needed to upgrade Aggregator. So ... I attempted to install the 6.0.9 module. I got this error:
| Info |
Start Sql execution: 05.06.02.SqlDataProvider file |
| Warning |
SQL Execution resulted in following
Exceptions:
System.Data.SqlClient.SqlException: Invalid column name 'ModuleTitle'.
Invalid column name 'ModuleTitle'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
at
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script,
Boolean UseTransactions)
ALTER PROCEDURE dbo.AIWeb_DNNStuff_Aggregator_GetTabModules
(
@TabId int,
@ModuleId int,
@ShowAllModules bit,
@AggregatorModuleId int,
@PortalId int
)
AS
-- Delete any modules that have been orphaned by a user delete of an
aggregator
DELETE FROM dbo.AIWeb_DNNStuff_Aggregator_Tab WHERE ModuleId NOT IN
(SELECT ModuleId FROM dbo.AIWeb_Modules WHERE IsDeleted = 0)
-- Select currently selected module
SELECT T.TABNAME,T.TABORDER,TM.TabModuleId, T.TabName + '>' +
M.ModuleTitle FullModuleTitle FROM dbo.AIWeb_TabModules TM
INNER JOIN dbo.AIWeb_Modules M ON TM.ModuleId = M.ModuleId
INNER JOIN dbo.AIWeb_Tabs T ON T.TabId = TM.TabId
INNER JOIN dbo.AIWeb_DNNStuff_Aggregator_Module AM ON AM.TabModuleId =
TM.TabModuleId
WHERE AM.AggregatorModuleId = @AggregatorModuleId
UNION
-- Now, select remaining
SELECT T.TABNAME,T.TABORDER,TM.TabModuleId, T.TabName + '>' +
M.ModuleTitle FullModuleTitle FROM dbo.AIWeb_TabModules TM
INNER JOIN dbo.AIWeb_Modules M ON TM.ModuleId = M.ModuleId
INNER JOIN dbo.AIWeb_Tabs T ON T.TabId = TM.TabId
INNER JOIN dbo.AIWeb_ModuleDefinitions MD ON MD.ModuleDefID =
M.ModuleDefID
INNER JOIN dbo.AIWeb_DesktopModules DM ON MD.DesktopModuleID =
DM.DesktopModuleID
WHERE
-- this tab
(TM.TabId = @TabId OR @ShowAllModules = 1)
AND
-- not this module
TM.ModuleId <> @ModuleId
AND
-- module not deleted
M.IsDeleted = 0
AND
-- tab not deleted
T.IsDeleted = 0
AND
-- not already aggregated in this tab
TM.TabModuleId NOT IN (SELECT AM1.TabModuleId
FROM dbo.AIWeb_DNNStuff_Aggregator_Tab AS A1 INNER JOIN
dbo.AIWeb_DNNStuff_Aggregator_Module AS AM1 ON
A1.AggregatorTabId = AM1.AggregatorTabId INNER JOIN
dbo.AIWeb_TabModules AS TM1 ON AM1.TabModuleId =
TM1.TabModuleID INNER JOIN
dbo.AIWeb_Modules AS M1 ON TM1.ModuleID =
M1.ModuleID INNER JOIN
dbo.AIWeb_TabModules ON A1.ModuleId =
dbo.AIWeb_TabModules.ModuleID
WHERE (TM1.TabID = @TabId) AND (dbo.AIWeb_TabModules.TabID = @TabId)
OR
(A1.ModuleId = @ModuleId))
AND
-- not an aggregator itself
M.ModuleId NOT IN (SELECT A2.ModuleId FROM
dbo.AIWeb_DNNStuff_Aggregator_Tab A2
INNER JOIN dbo.AIWeb_DNNStuff_Aggregator_Module AM2 ON
A2.AggregatorTabId = AM2.AggregatorTabId
INNER JOIN dbo.AIWeb_TabModules TM2 ON AM2.TabModuleId =
TM2.TabModuleId
WHERE TM2.ModuleId = @moduleid
)
AND
-- same portal
T.PortalId = @PortalId
AND
-- not an admin module
DM.IsAdmin = 0
|
| Info |
End Sql execution: 05.06.02.SqlDataProvider file |
Any suggestions?