Products

Solutions

Resources

Partners

Community

Blog

About

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 ...Error in 05.01.00.SqlDataProvider on upgrade from 5.00.01 to 5.01.00Error in 05.01.00.SqlDataProvider on upgrade from 5.00.01 to 5.01.00
Previous
 
Next
New Post
7/2/2009 3:29 PM
 

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'

 


 

 
New Post
7/2/2009 6:38 PM
 

there seem to be either modifications in admin or host menu, or there are pages with  same icon file / module control source.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
7/3/2009 10:34 AM
 

I found the problem. I am using a third-party menu module which placed an update trigger on the Tabs table. I disabled the trigger temporarily and re-ran the database update script. No errors that time.

I don't know if the module developer erred in placing a trigger on a core database table or not, but it might be good practice for the DNN upgrade script to disable triggers on any table on which it performs an UPDATE statement (and then re-enable them afterward). It would be a simple addition to the script.

Thanks.

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Error in 05.01.00.SqlDataProvider on upgrade from 5.00.01 to 5.01.00Error in 05.01.00.SqlDataProvider on upgrade from 5.00.01 to 5.01.00


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