|
|
|
Joined: 12/4/2005
Posts: 16
|
|
|
Hello, I get this message:
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.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, Boolean asyncWrite) 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:e14182a1-bd3d-4a5f-b49b-f12cc271681a 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
----------
Thank you for help.
|
|
|
|
| |
|
|
|
please run the following Statement in Host > SQL, before restarting the upgrade procedure:
CREATE PROCEDURE dbo.[GetRecycleModules]
( @PortalID int
)
AS
BEGIN
SELECT OwnerPortalID,
PortalID,
vw_Modules.TabID,
vw_Modules.TabModuleID,
vw_Modules.ModuleID,
vw_Modules.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
JOIN TabModules ON vw_Modules.TabModuleID = TabModules.TabModuleID
WHERE vw_Modules.PortalId = @PortalID
ORDER BY vw_Modules.ModuleId
END
GO
|
|
|
|
| |
|
|
Joined: 12/4/2005
Posts: 16
|
|
|
I did it, I get this error again:
----
0% 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.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, Boolean asyncWrite) 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:93fd4c45-3972-4728-afa1-00e39a05f137 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
|
|
|
|
| |
|
|
|
|
www.dynamisys.co.uk Joined: 3/26/2006
Posts: 2001
|
|
|
When Sebastian said restart; he meant recover the files and the database as they were before you began. Run his sql Try the upgrade again.
Is that what you did?
Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk
|
|
|
|
| |
|
|
Joined: 12/4/2005
Posts: 16
|
|
|
Yes, I did it...
1. I restored directory and database to 7.1.1 version
2. I run SQL script (result was green - OK)
3. I copied file from Upgrade package 7.1.2
4. I get the same error
|
|
|
|
| |