 |
|
|
Joined: 4/14/2005
Posts: 232
|
|
|
Hello,
I am trying to upgrade from 6.2.7 to 7.1.2. I have had problems with it and it gets stuck on 2% of the upgrade. Then I have followed this post: http://www.chrishammond.com/blog/item... and run the two SQL queries. After I refresh my page it guides me through the upgrade again, but then it get stuck on 26%. This is very frustrating... Any ideas?
DotNetNuke
Upgrade
Current Version - 07.01.02
Upgrade - Version 07.01.02
1Account Info
2Upgrade
View Website
3:16 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:9b794f29-ef6e-4559-9560-571f4f614e0c
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
|
| |
|
|
 | |
|
|
|
try this one:
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 vw_Modules.ModuleId
This seems to be a compatibiltiy issue in SQL Server 2008, I had no upgrade issues in SQL Server 2012 (make sure to set Database Compatibility Level to maximium value).
|
| |
|
|
| |