Page 2 DNN 5 Upgrade Error- Should I be worried?

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

Home All Forums

Home

Our Community

General Discuss...

DNN 5 Upgrade Error- Should I be worried?

1/4/2009 4:34 PM

Frozen DNN

Joined: 3/30/2007

Posts: 515

Re: DNN 5 Upgrade Error- Should I be worried?

5.0.0 Log

/* Update IconFile References for Admin Tabs */
/*********************************************/

UPDATE dbo.Tabs
SET IconFile = '~/images/' + IconFile
WHERE IconFile LIKE 'icon_%'
AND (TabPath LIKE '//Host%' OR TabPath LIKE '//Admin%')

/* Set Admin and Host Pages to be Secure By Default */
/****************************************************/

UPDATE dbo.[Tabs]
    SET IsSecure = 1
WHERE PortalID IS NULL
    OR TabID IN (SELECT AdminTabId FROM dbo.[Portals])
    OR ParentId IN (SELECT AdminTabId FROM dbo.[Portals])

System.Data.SqlClient.SqlException: Cannot find the object 'Register_ResponseListByModuleIDUserID', because it does not exist or you do not have permission.
Cannot find the object 'Register_ResponseListUserIDByModuleID', because it does not exist or you do not have permission.
Cannot find the object 'NTForums_GetForumsByGroup2', because it does not exist or you do not have permission.
   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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole)

if exists (select * from dbo.sysusers where name='website1') begin declare @exec nvarchar(2000) declare @name varchar(150) declare sp_cursor cursor for select o.name as name from dbo.sysobjects o where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 ) and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0 and o.name not like N'#%%' and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_') open sp_cursor fetch sp_cursor into @name while @@fetch_status >= 0 begin select @exec = 'grant EXECUTE on ' + @name + ' to [website1]' execute (@exec) fetch sp_cursor into @name end deallocate sp_cursor end

System.Data.SqlClient.SqlException: Cannot find the object 'ColumnAlreadyExists', because it does not exist or you do not have permission.
   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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.GrantUserDefinedFunctionsPermission(String ScalarPermission, String TablePermission, String LoginOrRole)

if exists (select * from dbo.sysusers where name='website1') begin declare @exec nvarchar(2000) declare @name varchar(150) declare @isscalarfunction int declare @istablefunction int declare sp_cursor cursor for select o.name as name, OBJECTPROPERTY(o.id, N'IsScalarFunction') as IsScalarFunction from dbo.sysobjects o where ( OBJECTPROPERTY(o.id, N'IsScalarFunction') = 1 OR OBJECTPROPERTY(o.id, N'IsTableFunction') = 1 ) and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0 and o.name not like N'#%%' and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_') open sp_cursor fetch sp_cursor into @name, @isscalarfunction while @@fetch_status >= 0 begin if @IsScalarFunction = 1 begin select @exec = 'grant EXECUTE on ' + @name + ' to [website1]' execute (@exec) fetch sp_cursor into @name, @isscalarfunction end else begin select @exec = 'grant SELECT on ' + @name + ' to [website1]' execute (@exec) fetch sp_cursor into @name, @isscalarfunction end end deallocate sp_cursor end

Thanks!!

1/6/2009 1:09 AM

Frozen DNN

Joined: 3/30/2007

Posts: 515

Re: DNN 5 Upgrade Error- Should I be worried?

Bump!

5/9/2009 10:17 AM

Ferit Nuri

www.fnthosting.com
Joined: 9/4/2003

Posts: 15

Re: DNN 5 Upgrade Error- Should I be worried?

same error on my non-english (Regional Settings) test machine. i have fixed @isscalarfunction to @IsScalarFunction and @istablefunction to @IsTableFunction from the 05.00.01 source code. i uploaded fixed version of the DotNetNuke.SqlDataProvider.dll to my website for my customers. if you want it you can download from here and manually upload to your bin folder.

6/24/2009 8:19 PM

Frozen DNN

Joined: 3/30/2007

Posts: 515

Re: DNN 5 Upgrade Error- Should I be worried? 5.1 log

5.1 Log

System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
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)

/* Update Tab IconFileLarge */
/****************************/
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_hostsettings_32px.gif' WHERE IconFile='~/images/icon_hostsettings_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_sitesettings_32px.gif' WHERE IconFile='~/images/icon_sitesettings_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_moduledefinitions_32px.gif' WHERE IconFile='~/images/icon_moduledefinitions_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_filemanager_32px.gif' WHERE IconFile='~/images/icon_filemanager_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_vendors_32px.gif' WHERE IconFile='~/images/icon_vendors_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_sql_32px.gif' WHERE IconFile='~/images/icon_sql_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_scheduler_32px.gif' WHERE IconFile='~/images/icon_scheduler_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_language_32px.gif' WHERE IconFile='~/images/icon_language_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_search_32px.gif' WHERE IconFile='~/images/icon_search_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_lists_32px.gif' WHERE IconFile='~/images/icon_lists_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_hostusers_32px.gif' WHERE IconFile='~/images/icon_hostusers_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_skins_32px.gif' WHERE IconFile='~/images/icon_skins_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_moduledefinitions_32px.gif' WHERE IconFile='~/images/icon_moduledefinitions_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_lists_32px.gif' WHERE IconFile='~/images/icon_lists_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_whatsnew_32px.gif' WHERE IconFile='~/images/icon_whatsnew_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_tabs_32px.gif' WHERE IconFile='~/images/icon_tabs_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_securityroles_32px.gif' WHERE IconFile='~/images/icon_securityroles_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_users_32px.gif' WHERE IconFile='~/images/icon_users_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_sitelog_32px.gif' WHERE IconFile='~/images/icon_sitelog_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_bulkmail_32px.gif' WHERE IconFile='~/images/icon_bulkmail_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_recyclebin_32px.gif' WHERE IconFile='~/images/icon_recyclebin_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_viewstats_32px.gif' WHERE IconFile='~/images/icon_viewstats_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_wizard_32px.gif' WHERE IconFile='~/images/icon_wizard_16px.gif'
UPDATE dbo.Tabs SET IconFileLarge='~/images/icon_solutions_32px.gif' WHERE IconFile='~/images/icon_solutions_16px.gif'

/* Add Host and Admin Page Descriptions */
/****************************/
UPDATE dbo.Tabs SET Description='Manage configuration settings which apply to all portals.' WHERE TabPath='//Host//Host Settings' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Add, modify, and delete portals.' WHERE TabPath='//Host//Portals' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Install, add, modify and delete modules.' WHERE TabPath='//Host//Module Definitions' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Manage files.' WHERE TabPath='//Host//File Manager' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Manage vendor accounts, banner advertising and affiliate referrals.' WHERE TabPath='//Host//Vendors' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Execute SQL queries against the database.' WHERE TabPath='//Host//SQL' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Add, modify and delete scheduled tasks to be run at specified intervals.' WHERE TabPath='//Host//Schedule' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Manage localization for differing time zones and languages across all portals.' WHERE TabPath='//Host//Languages' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Manage search settings associated with DotNetNuke''s search capability.' WHERE TabPath='//Host//Search Admin' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Manage common lists.' WHERE TabPath='//Host//Lists' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Manage host user accounts.' WHERE TabPath='//Host//Superuser Accounts' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Manage skins and containers for all portals.' WHERE TabPath='//Host//Skins' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Install, add, modify and delete extensions, such as modules, skins and language packs.' WHERE TabPath='//Host//Extensions' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Provides a summary of the major features for each release.' WHERE TabPath='//Host//WhatsNew' AND PortalID IS NULL
UPDATE dbo.Tabs SET Description='Summary view of application and site settings.' WHERE TabPath='//Host//Dashboard' AND PortalID IS NULL

UPDATE dbo.Tabs SET Description='Manage configuration settings for the portal.' WHERE TabPath='//Admin//SiteSettings'
UPDATE dbo.Tabs SET Description='Manage pages within the portal.' WHERE TabPath='//Admin//Tabs'
UPDATE dbo.Tabs SET Description='Install, add, modify and delete extensions, such as modules, skins and language packs.' WHERE TabPath='//Admin//Extensions'
UPDATE dbo.Tabs SET Description='Manage security roles for the portal.' WHERE TabPath='//Admin//SecurityRoles'
UPDATE dbo.Tabs SET Description='Manage user accounts for the portal.' WHERE TabPath='//Admin//UserAccounts'
UPDATE dbo.Tabs SET Description='Manage vendor accounts, banner advertising and affiliate referrals within the portal.' WHERE TabPath='//Admin//Vendors'
UPDATE dbo.Tabs SET Description='View statistical reports on site activity for the portal.' WHERE TabPath='//Admin//SiteLog'
UPDATE dbo.Tabs SET Description='Send email messages to users, security roles and specific email addresses.' WHERE TabPath='//Admin//Newsletters'
UPDATE dbo.Tabs SET Description='Manage files within the portal.' WHERE TabPath='//Admin//FileManager'
UPDATE dbo.Tabs SET Description='View, restore or permanently recycle pages and modules that have been deleted from the portal.' WHERE TabPath='//Admin//RecycleBin'
UPDATE dbo.Tabs SET Description='View a historical log of database events such as event schedules, exceptions, account logins, module and page changes, user account activities, security role activities, etc.' WHERE TabPath='//Admin//LogViewer'
UPDATE dbo.Tabs SET Description='Configure portal settings, page design and apply a site template using a step-by-step wizard.' WHERE TabPath='//Admin//SiteWizard'
UPDATE dbo.Tabs SET Description='DotNetNuke Solutions Explorer page provides easy access to locate free and commercial DotNetNuke modules, skin and more.' WHERE TabPath='//Admin//Solutions'

System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
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)

UPDATE dbo.Tabs SET Title='Pages', TabName='Pages' WHERE TabPath='//Admin//Tabs'

/* Enable link of Admin, Host tabs */
UPDATE dbo.Tabs SET DisableLink=0 WHERE TabPath='//Admin' OR TabPath='//Host'

System.Data.SqlClient.SqlException: Table 'EventLog' already has a primary key defined on it.
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)

/* Change primary key of EventLog Table */
/****************************************/

IF NOT EXISTS (SELECT 1 FROM INformATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'dbo.EventLog' AND COLUMN_NAME = 'LogEventID')
    BEGIN
        --Note this name does NOT have an object qualifier in 4.x upgrades
        IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
            ALTER TABLE dbo.EventLog
                DROP CONSTRAINT PK_EventLogMaster

        --Note this name does have an object qualifier in 5.x installs
        IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
            ALTER TABLE dbo.EventLog
                DROP CONSTRAINT PK_EventLogMaster

        ALTER TABLE dbo.EventLog
            ADD LogEventID bigint NOT NULL IDENTITY (1, 1)

        ALTER TABLE dbo.EventLog
            ADD CONSTRAINT PK_EventLogMaster PRIMARY KEY CLUSTERED ( LogEventID )
    END

----------------------

Anyone? Please. How do I fix the error?

6/24/2009 8:37 PM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: DNN 5 Upgrade Error- Should I be worried? 5.1 log

there seems to be an issue in your data, difficult to analyse in forums. please contact me offline for assistance (leupold (at) gamma-concept.de)

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

Page 2 of 4

Home

Our Community

General Discuss...

DNN 5 Upgrade Error- Should I be worried?

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:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)