Hello all,
We are trying to upgrade from 6.2.9 to 7.1.2 but we are having a problem as described below. I had this problem in the past and Sebastian suggested to create a stored procedure using this. However, the problem is not fixed. The site upgrade still hangs there. I have set the Database compatibility level to 100. (We are using SQL Server 2008 R2.)
This upgrade is very important to us since we had multiple problems with the security and also with the File Manager.
Thanks in advance.
DotNetNuke
Upgrade
Current Version - 07.01.02
Upgrade - Version 07.01.02
1Account Info
2Upgrade
View Website
10:21 Minutes | 26% ERROR occured - System.Data.SqlClient.SqlException (0x80131904): Ambiguous column name 'ModuleId'.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)
ClientConnectionId:91c6785d-61d3-420f-bbc1-ffb8bed81543
CREATE PROCEDURE dbo.[GetRecycleModules] @PortalID int AS SELECT OwnerPortalID, PortalID, vw_Modules.TabID, vw_Modules.TabModuleID, vw_Modules.ModuleID, ModuleDefID, vw_Modules.ModuleOrder, vw_Modules.PaneName, vw_Modules.ModuleTitle, vw_Modules.CacheTime, vw_Modules.CacheMethod, vw_Modules.Alignment, vw_Modules.Color, vw_Modules.Border, vw_Modules.IconFile, AllTabs, vw_Modules.Visibility, vw_Modules.IsDeleted, vw_Modules.Header, vw_Modules.Footer, StartDate, EndDate, vw_Modules.ContainerSrc, vw_Modules.DisplayTitle, vw_Modules.DisplayPrint, vw_Modules.DisplaySyndicate, vw_Modules.IsWebSlice, vw_Modules.WebSliceTitle, vw_Modules.WebSliceExpiryDate, vw_Modules.WebSliceTTL, InheritViewPermissions, IsShareable, IsShareableViewOnly, DesktopModuleID, DefaultCacheTime, ModuleControlID, BusinessControllerClass, IsAdmin, SupportedFeatures, ContentItemID, [Content], ContentTypeID, ContentKey, Indexed, StateID, vw_Modules.CreatedByUserID, vw_Modules.CreatedOnDate, LastContentModifiedOnDate, vw_Modules.UniqueId, vw_Modules.VersionGuid, vw_Modules.DefaultLanguageGuid, vw_Modules.LocalizedVersionGuid, vw_Modules.CultureCode, TabModules.LastModifiedByUserID, TabModules.LastModifiedOnDate FROM vw_Modules INNER JOIN TabModules ON vw_Modules.TabModuleID = TabModules.TabModuleID WHERE PortalId = @PortalID ORDER BY ModuleId
Retry View Logs
Updating Database
Updating Extensions
Visit Website