Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...I have some Unresolved 4.08.00 Upgrade Issues Please helpI have some Unresolved 4.08.00 Upgrade Issues Please help
Previous
 
Next
New Post
9/12/2008 12:11 PM
 
Franc Simari


Joined: 11/19/2005
Posts: 114

I like to upgrade my DNN instance from 4.08.00 to the latest version 4.09.00 I understand it fixes many of the issues I am presently experiencing.

Last time I did an upgrade was from 4.04.00 to 4.08.00 in the process I got hit with all these errors.

My question is: should fix all these errors before I upgrade to 4.09.00 and if I have to could someone offer some hints.

Or does the new version corrects these errors/issues.

Thanks for your help.

 

Version errors are separated by a line of **************************************************************

 View Upgrade Log For Version: 04.04.01

Allows you to view the database upgrade log for a specific version   00.00.00 01.00.00 01.00.01 01.00.02 01.00.03 01.00.04 01.00.05 01.00.06 01.00.07 01.00.08 01.00.09 01.00.10 02.00.00 02.00.01 02.00.02 02.00.03 02.00.04 02.01.01 02.01.02 02.02.00 02.02.01 02.02.02 03.00.01 03.00.02 03.00.03 03.00.04 03.00.05 03.00.06 03.00.07 03.00.08 03.00.09 03.00.10 03.00.11 03.00.12 03.00.13 03.01.00 03.01.01 03.02.00 03.02.01 03.02.02 03.02.03 03.02.04 03.02.05 03.02.06 03.02.07 03.03.00 03.03.01 03.03.02 03.03.03 04.00.00 04.00.01 04.00.02 04.00.03 04.00.04 04.00.05 04.00.06 04.00.07 04.03.00 04.03.01 04.03.02 04.03.03 04.03.04 04.03.05 04.03.06 04.03.07 04.04.00 04.04.01 04.05.00 04.05.01 04.05.02 04.05.03 04.05.04 04.05.05 04.06.00 04.06.01 04.06.02 04.07.00 04.08.00 DotNetNuke.Data DotNetNuke.Schema DotNetNuke.SetUp UnInstall Upgrade   Go 
System.Data.SqlClient.SqlException: Ambiguous column name 'PortalId'.
Ambiguous column name 'PortalId'.
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)


CREATE procedure dbo.[egb_GetPortalRoles]

@PortalId int

AS
SELECT R.RoleId,
R.PortalId,
R.RoleGroupId,
R.RoleName,
R.Description,
'ServiceFee' = case when convert(int,R.ServiceFee) <> 0 then R.ServiceFee else null end,
'BillingPeriod' = case when convert(int,R.ServiceFee) <> 0 then R.BillingPeriod else null end,
'BillingFrequency' = case when convert(int,R.ServiceFee) <> 0 then L1.Text else '' end,
'TrialFee' = case when R.TrialFrequency <> 'N' then R.TrialFee else null end,
'TrialPeriod' = case when R.TrialFrequency <> 'N' then R.TrialPeriod else null end,
'TrialFrequency' = case when R.TrialFrequency <> 'N' then L2.Text else '' end,
'IsPublic' = case when R.IsPublic = 1 then 'True' else 'False' end,
'AutoAssignment' = case when R.AutoAssignment = 1 then 'True' else 'False' end,
RSVPCode,
IconFile
FROM dbo.egb_Roles R
LEFT OUTER JOIN dbo.egb_Lists L1 ON R.BillingFrequency = L1.Value
LEFT OUTER JOIN dbo.egb_Lists L2 ON R.TrialFrequency = L2.Value
WHERE ( PortalId = @PortalId OR PortalId is null )
AND L1.ListName='Frequency'
AND L2.ListName='Frequency'
ORDER BY R.RoleName

***********************************************************************************************************************************************
 
 View Upgrade Log For Version: 04.05.00

Allows you to view the database upgrade log for a specific version   00.00.00 01.00.00 01.00.01 01.00.02 01.00.03 01.00.04 01.00.05 01.00.06 01.00.07 01.00.08 01.00.09 01.00.10 02.00.00 02.00.01 02.00.02 02.00.03 02.00.04 02.01.01 02.01.02 02.02.00 02.02.01 02.02.02 03.00.01 03.00.02 03.00.03 03.00.04 03.00.05 03.00.06 03.00.07 03.00.08 03.00.09 03.00.10 03.00.11 03.00.12 03.00.13 03.01.00 03.01.01 03.02.00 03.02.01 03.02.02 03.02.03 03.02.04 03.02.05 03.02.06 03.02.07 03.03.00 03.03.01 03.03.02 03.03.03 04.00.00 04.00.01 04.00.02 04.00.03 04.00.04 04.00.05 04.00.06 04.00.07 04.03.00 04.03.01 04.03.02 04.03.03 04.03.04 04.03.05 04.03.06 04.03.07 04.04.00 04.04.01 04.05.00 04.05.01 04.05.02 04.05.03 04.05.04 04.05.05 04.06.00 04.06.01 04.06.02 04.07.00 04.08.00 DotNetNuke.Data DotNetNuke.Schema DotNetNuke.SetUp UnInstall Upgrade   Go 
System.Data.SqlClient.SqlException: The object 'IX_egb_TabPermission' is dependent on column 'RoleID'.
ALTER TABLE DROP COLUMN RoleID failed because one or more objects access this column.
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 TABLE dbo.egb_TabPermission
DROP COLUMN RoleID


System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'RoleID' in table 'dbo.egb_TabPermission' is specified more than once.
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 TABLE dbo.egb_TabPermission ADD
RoleID int NULL


System.Data.SqlClient.SqlException: The object 'IX_egb_ModulePermission' is dependent on column 'RoleID'.
ALTER TABLE DROP COLUMN RoleID failed because one or more objects access this column.
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 TABLE dbo.egb_ModulePermission
DROP COLUMN RoleID


System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'RoleID' in table 'dbo.egb_ModulePermission' is specified more than once.
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 TABLE dbo.egb_ModulePermission ADD
RoleID int NULL


System.Data.SqlClient.SqlException: The object 'IX_egb_FolderPermission' is dependent on column 'RoleID'.
ALTER TABLE DROP COLUMN RoleID failed because one or more objects access this column.
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 TABLE dbo.egb_FolderPermission
DROP COLUMN RoleID


System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'RoleID' in table 'dbo.egb_FolderPermission' is specified more than once.
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 TABLE dbo.egb_FolderPermission ADD
RoleID int NULL
 
********************************************************************************************************************************************


 View Upgrade Log For Version: 04.05.02

Allows you to view the database upgrade log for a specific version   00.00.00 01.00.00 01.00.01 01.00.02 01.00.03 01.00.04 01.00.05 01.00.06 01.00.07 01.00.08 01.00.09 01.00.10 02.00.00 02.00.01 02.00.02 02.00.03 02.00.04 02.01.01 02.01.02 02.02.00 02.02.01 02.02.02 03.00.01 03.00.02 03.00.03 03.00.04 03.00.05 03.00.06 03.00.07 03.00.08 03.00.09 03.00.10 03.00.11 03.00.12 03.00.13 03.01.00 03.01.01 03.02.00 03.02.01 03.02.02 03.02.03 03.02.04 03.02.05 03.02.06 03.02.07 03.03.00 03.03.01 03.03.02 03.03.03 04.00.00 04.00.01 04.00.02 04.00.03 04.00.04 04.00.05 04.00.06 04.00.07 04.03.00 04.03.01 04.03.02 04.03.03 04.03.04 04.03.05 04.03.06 04.03.07 04.04.00 04.04.01 04.05.00 04.05.01 04.05.02 04.05.03 04.05.04 04.05.05 04.06.00 04.06.01 04.06.02 04.07.00 04.08.00 DotNetNuke.Data DotNetNuke.Schema DotNetNuke.SetUp UnInstall Upgrade   Go 
System.Data.SqlClient.SqlException: There is already an object named 'IX_egb_ModulePermission' in the database.
Could not create constraint. See previous errors.
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)


/* add unique constraint */
ALTER TABLE dbo.egb_ModulePermission ADD CONSTRAINT
IX_egb_ModulePermission UNIQUE NONCLUSTERED
(
ModuleID,
PermissionID,
RoleID,
UserID
) ON [PRIMARY]


System.Data.SqlClient.SqlException: There is already an object named 'IX_egb_TabPermission' in the database.
Could not create constraint. See previous errors.
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)


/* add unique constraint */
ALTER TABLE dbo.egb_TabPermission ADD CONSTRAINT
IX_egb_TabPermission UNIQUE NONCLUSTERED
(
TabID,
PermissionID,
RoleID,
UserID
) ON [PRIMARY]


System.Data.SqlClient.SqlException: There is already an object named 'IX_egb_FolderPermission' in the database.
Could not create constraint. See previous errors.
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)


/* add unique constraint */
ALTER TABLE dbo.egb_FolderPermission ADD CONSTRAINT
IX_egb_FolderPermission UNIQUE NONCLUSTERED
(
FolderID,
PermissionID,
RoleID,
UserID
) ON [PRIMARY]


System.Data.SqlClient.SqlException: There is already an object named 'IX_egb_Permission' in the database.
Could not create constraint. See previous errors.
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)


/* add unique constraint */
ALTER TABLE dbo.egb_Permission ADD CONSTRAINT
IX_egb_Permission UNIQUE NONCLUSTERED
(
PermissionCode,
ModuleDefID,
PermissionKey
) ON [PRIMARY]


System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_egb_DesktopModules_ModuleName'. Cannot insert duplicate key in object 'dbo.egb_DesktopModules'.
Cannot insert the value NULL into column 'DesktopModuleID', table 'EGB.dbo.egb_ModuleDefinitions'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The statement has been terminated.
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)


declare @DesktopModuleID int

insert into dbo.egb_DesktopModules (
FriendlyName,
Description,
Version,
IsPremium,
IsAdmin,
FolderName,
ModuleName
)
values (
'Google Adsense',
'Allows you to serve Google Adsense ads in your site',
'01.00.00',
0,
0,
'Adsense',
'Adsense'
)

SET @DesktopModuleID = @@IDENTITY

DECLARE @ModuleDefID int

insert into dbo.egb_ModuleDefinitions (
FriendlyName,
DesktopModuleId,
DefaultCacheTime
)
values (
'Adsense',
@DesktopModuleID,
1200
)

SET @ModuleDefID = @@IDENTITY

insert into dbo.egb_ModuleControls (
ControlKey,
ControlTitle,
ModuleDefID,
ControlSrc,
IconFile,
ControlType,
ViewOrder
)
values (
null,
null,
@ModuleDefID ,
'Admin/Vendors/Adsense.ascx',
null,
0,
null
)

insert into dbo.egb_ModuleControls (
ControlKey,
ControlTitle,
ModuleDefID,
ControlSrc,
IconFile,
ControlType,
ViewOrder
)
values (
'Edit',
'Edit Adsense',
@ModuleDefID ,
'Admin/Vendors/EditAdsense.ascx',
null,
1,
null
)


System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_egb_DesktopModules_ModuleName'. Cannot insert duplicate key in object 'dbo.egb_DesktopModules'.
Cannot insert the value NULL into column 'DesktopModuleID', table 'EGB.dbo.egb_ModuleDefinitions'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The statement has been terminated.
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)


declare @DesktopModuleID int

insert into dbo.egb_DesktopModules (
FriendlyName,
Description,
Version,
IsPremium,
IsAdmin,
FolderName,
ModuleName
)
values (
'Feed Explorer',
'Allows users to browse RSS feeds using a tabbed user interface',
'01.00.00',
0,
0,
'FeedExplorer',
'FeedExplorer'
)

SET @DesktopModuleID = @@IDENTITY

DECLARE @ModuleDefID int

insert into dbo.egb_ModuleDefinitions (
FriendlyName,
DesktopModuleId,
DefaultCacheTime
)
values (
'Feed Explorer',
@DesktopModuleID,
-1
)

SET @ModuleDefID = @@IDENTITY

insert into dbo.egb_ModuleControls (
ControlKey,
ControlTitle,
ModuleDefID,
ControlSrc,
IconFile,
ControlType,
ViewOrder
)
values (
null,
null,
@ModuleDefID ,
'Admin/Syndication/FeedExplorer.ascx',
null,
0,
null
)

insert into dbo.egb_ModuleControls (
ControlKey,
ControlTitle,
ModuleDefID,
ControlSrc,
IconFile,
ControlType,
ViewOrder
)
values (
'Settings',
'Feed Explorer Settings',
@ModuleDefID ,
'Admin/Syndication/FeedExplorerSettings.ascx',
null,
1,
null
)


*********************************************************************************************************************************************

 
View Upgrade Log For Version: 04.05.03

Allows you to view the database upgrade log for a specific version   00.00.00 01.00.00 01.00.01 01.00.02 01.00.03 01.00.04 01.00.05 01.00.06 01.00.07 01.00.08 01.00.09 01.00.10 02.00.00 02.00.01 02.00.02 02.00.03 02.00.04 02.01.01 02.01.02 02.02.00 02.02.01 02.02.02 03.00.01 03.00.02 03.00.03 03.00.04 03.00.05 03.00.06 03.00.07 03.00.08 03.00.09 03.00.10 03.00.11 03.00.12 03.00.13 03.01.00 03.01.01 03.02.00 03.02.01 03.02.02 03.02.03 03.02.04 03.02.05 03.02.06 03.02.07 03.03.00 03.03.01 03.03.02 03.03.03 04.00.00 04.00.01 04.00.02 04.00.03 04.00.04 04.00.05 04.00.06 04.00.07 04.03.00 04.03.01 04.03.02 04.03.03 04.03.04 04.03.05 04.03.06 04.03.07 04.04.00 04.04.01 04.05.00 04.05.01 04.05.02 04.05.03 04.05.04 04.05.05 04.06.00 04.06.01 04.06.02 04.07.00 04.08.00 DotNetNuke.Data DotNetNuke.Schema DotNetNuke.SetUp UnInstall Upgrade   Go 
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_egb_ModuleControls'. Cannot insert duplicate key in object 'dbo.egb_ModuleControls'.
The statement has been terminated.
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)

/************************************************************/
/***** SqlDataProvider *****/
/***** *****/
/***** *****/
/***** Note: To manually execute this script you must *****/
/***** perform a search and replace operation *****/
/***** for dbo. and egb_ *****/
/***** *****/
/************************************************************/

declare @ModuleControlID int

select @ModuleControlID = null

select @ModuleControlID = ModuleControlID
from dbo.egb_ModuleControls
where ModuleDefID is null
and ControlKey = 'Adsense'

if @ModuleControlID is null
begin
insert into dbo.egb_ModuleControls (
ControlKey,
ControlTitle,
ModuleDefID,
ControlSrc,
IconFile,
ControlType,
ViewOrder
)
values (
'Adsense',
'Google Adsense',
null,
'Admin/Vendors/EditAdsense.ascx',
null,
2,
null
)
end
else
begin
update dbo.egb_ModuleControls
set ControlSrc = 'Admin/Vendors/EditAdsense.ascx',
ControlType = 2
where ModuleDefID is null
and ControlKey = 'Adsense'
end


*******************************************************************************************************************************


View Upgrade Log For Version: 04.05.04

Allows you to view the database upgrade log for a specific version   00.00.00 01.00.00 01.00.01 01.00.02 01.00.03 01.00.04 01.00.05 01.00.06 01.00.07 01.00.08 01.00.09 01.00.10 02.00.00 02.00.01 02.00.02 02.00.03 02.00.04 02.01.01 02.01.02 02.02.00 02.02.01 02.02.02 03.00.01 03.00.02 03.00.03 03.00.04 03.00.05 03.00.06 03.00.07 03.00.08 03.00.09 03.00.10 03.00.11 03.00.12 03.00.13 03.01.00 03.01.01 03.02.00 03.02.01 03.02.02 03.02.03 03.02.04 03.02.05 03.02.06 03.02.07 03.03.00 03.03.01 03.03.02 03.03.03 04.00.00 04.00.01 04.00.02 04.00.03 04.00.04 04.00.05 04.00.06 04.00.07 04.03.00 04.03.01 04.03.02 04.03.03 04.03.04 04.03.05 04.03.06 04.03.07 04.04.00 04.04.01 04.05.00 04.05.01 04.05.02 04.05.03 04.05.04 04.05.05 04.06.00 04.06.01 04.06.02 04.07.00 04.08.00 DotNetNuke.Data DotNetNuke.Schema DotNetNuke.SetUp UnInstall Upgrade   Go 
System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'IsSecure' in table 'dbo.egb_Tabs' is specified more than once.
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 TABLE dbo.egb_Tabs ADD
IsSecure bit NOT NULL CONSTRAINT DF_egb_Tabs_IsSecure DEFAULT (0)


 


 
 
 
New Post
9/15/2008 12:10 PM
 
Brandon Haynes Haynes


brandonhaynes.org
Joined: 2/6/2006
Posts: 1172

Hi Franc,

Probably not the news you wanted to hear, but yes, I do recommend rectifying some of these data-layer errors before proceeding.  It seems that for whatever reason your database is a bit out of sync, causing cascading upgrade errors. 

How long has it been since your most recent upgrade?  Is restoring your state and re-upgrading to 4.8 an option?  Obviously a clean automated upgrade would be the easiest path.  Typically you would not want to proceed with these sorts of errors.

Assuming that isn't an option (hopefully it is) you would likely need to use MSSQL Management Studio to manually investigate each failure, determine its cause, and execute a correction.  These sorts of corrections will require moderate skill with TSQL and an appreciation for the underlying data structure of DNN. 

Depending on the commerciality level of your deployment, you might also consider investing in an hour or two of professional help in upgrading and ensuring that your database is of consistent integrity.

One mitigating factor could be that your site continues to operate (I assume).  I would not expect a site without the GetPortalRoles SP to operate at all -- yet the log you posted above suggests that there was a failure in creating this procedure.

Hope this gets you started in thinking about how to take your next steps!

Brandon

 

Brandon Haynes
BrandonHaynes.org
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...I have some Unresolved 4.08.00 Upgrade Issues Please helpI have some Unresolved 4.08.00 Upgrade Issues Please help


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out