I haven't seen anyone else mention this exact error, but upon upgrading my 5.00.01 to 5.01.00, the only error was
Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information)
Below is the log file in its entirety. Any ideas??
**********
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: 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 icons */
UPDATE dbo.Tabs SET IconFile='~/images/icon_dashboard_16px.gif', IconFileLarge='~/images/icon_dashboard_32px.gif' WHERE TabPath='//Host//Dashboard'
UPDATE dbo.Tabs SET IconFile='~/images/icon_extensions_16px.gif', IconFileLarge='~/images/icon_extensions_32px.gif' WHERE TabPath='//Host//Extensions'
UPDATE dbo.Tabs SET IconFile='~/images/icon_extensions_16px.gif', IconFileLarge='~/images/icon_extensions_32px.gif' WHERE TabPath='//Admin//Extensions'
UPDATE dbo.ModuleControls SET IconFile='~/images/icon_extensions_32px.gif' WHERE ControlSrc='DesktopModules/Admin/Extensions/Extensions.ascx'
UPDATE dbo.ModuleControls SET IconFile='~/images/icon_extensions_32px.gif' WHERE ControlSrc='DesktopModules/Admin/Extensions/EditExtension.ascx'
UPDATE dbo.ModuleControls SET IconFile='~/images/icon_extensions_32px.gif' WHERE ControlSrc='DesktopModules/Admin/Extensions/PackageWriter.ascx'
UPDATE dbo.ModuleControls SET IconFile='~/images/icon_extensions_32px.gif' WHERE ControlSrc='DesktopModules/Admin/Extensions/Editors/EditModuleControl.ascx'
UPDATE dbo.ModuleControls SET IconFile='~/images/icon_extensions_32px.gif' WHERE ControlSrc='DesktopModules/Admin/Extensions/Editors/ImportModuleDefinition.ascx'
UPDATE dbo.ModuleControls SET IconFile='~/images/icon_extensions_32px.gif' WHERE ControlSrc='DesktopModules/Admin/Extensions/BatchInstall.ascx'
UPDATE dbo.ModuleControls SET IconFile='~/images/icon_extensions_32px.gif' WHERE ControlSrc='DesktopModules/Admin/Extensions/ExtensionWizard.ascx'
UPDATE dbo.ModuleControls SET IconFile='~/images/icon_extensions_32px.gif' WHERE ControlSrc='DesktopModules/Admin/Extensions/UsageDetails.ascx'
UPDATE dbo.ModuleControls SET IconFile='~/images/icon_dashboard_32px.gif' WHERE ControlSrc='DesktopModules/Admin/Dashboard/Dashboard.ascx'