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
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Upgrade from 5.4.4 to 5.5.0 caused site to fail to loadUpgrade from 5.4.4 to 5.5.0 caused site to fail to load
Previous
 
Next
New Post
8/19/2010 12:36 PM
 
William Severance


www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
Paul Cutcliffe wrote:
. . . then copy the two lines containing SQL Server connection details and the line containing the machine id from the old web.config into the newly provided resource.config file, then rename the old web.config file to something with the date in, then rename resource.config to web.config. 
Paul,

Your method of manually making changes to web.config may be the problem. Since DNN 4.06.02, it has not been necessary to manually modify the configuration file to merge settings from your existing web.config with those of the upgrade version. Infact, manual modification can cause problems such as this as manual changes may block the upgrade process from making other needed changes.

The upgrade packages intentionally do not include a web.config file to avoid overwriting the existing web.config file. When you browse to the site after copying/uploading files from the extracted upgrade package, all updates to web.config will be done automatically at the correct point during the upgrade.

I would suggest that you try upgrading again but this time do not manually merge release.config with your existing web.config. Should an application error occur again, please set cutomErrors="Off" in the web.config then browse back to the site to be able to see the complete error message which you may then post to this forum.
Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
8/19/2010 1:08 PM
 
Paul Cutcliffe


www.EastbourneIT.com
Joined: 9/28/2006
Posts: 55
Fantastic! That's the way I always thought the upgrade process should work! But that's what I mean, as there doesn't appear to be any documentation telling you what to do (please correct me if I'm wrong), I've resorted to reading old forum posts which probably only related to really old versions. Thanks for the advice - I will attempt the upgrade again now. My guess is that the other user with the same issue, Kano, probably followed the same steps that I did. I shall come back to you shortly, when, hopefully, my site (www.EastbourneIT.com) will be successfully upgraded.
 
New Post
8/19/2010 1:24 PM
 
Paul Cutcliffe


www.EastbourneIT.com
Joined: 9/28/2006
Posts: 55
Okay, upgrade performed, but there was an error in the upgrade log - here is a copy of the whole thing:
 
Upgrading DotNetNuke


Current Assembly Version: 05.05.00


Current Database Version: 05.04.04






Upgrade Status Report


00:00:00.093 - Upgrading to Version: 05.05.00
00:00:01.984 -   Executing Script: 05.05.00.SqlDataProvider Error! (see 05.05.00.log.resources for more information)
00:00:09.562 -   Executing Application Upgrades: 05.05.00 Success
00:00:10.515 -   Cleaning Up Files: 05.05.00 Success
00:00:10.515 -   Updating Config Files: 05.05.00 Success
00:00:10.562 - Performing General Upgrades
00:00:10.765 - Installing Optional Modules:
00:00:10.765 -   Installing Package File HTML_Community_05.04.03_Install:  Success
00:00:12.421 -   Installing Package File Messaging_01.01.00_Install:  Success
00:00:12.656 -   Installing Package File Taxonomy_01.01.00_Install:  Success
00:00:12.875 -   Installing Package File Telerik_05.05.00_Install:  Success
00:00:17.125 - Installing Optional Skins:
00:00:17.125 - Installing Optional Containers:
00:00:17.125 - Installing Optional Languages:
00:00:17.125 - Installing Optional Providers:
00:00:17.156 -   Installing Package File AspNetMembershipProvider_05.02.00_Install:  Success
00:00:17.359 -   Installing Package File CorePermissionProvider_05.01.01_Install:  Success
00:00:17.609 -   Installing Package File CoreSitemapProvider_5.5.0.0_Install:  Success
00:00:17.906 -   Installing Package File DatabaseLoggingProvider_05.01.01_Install:  Success
00:00:18.046 -   Installing Package File DNNMembershipProvider_05.01.03_Install:  Success
00:00:18.140 -   Installing Package File DNNMenuNavigationProvider_05.01.00_Install:  Success
00:00:18.250 -   Installing Package File DNNTreeNavigationProvider_05.01.00_Install:  Success
00:00:18.328 -   Installing Package File FckHtmlEditorProvider_02.00.04_Install:  Success
00:00:21.750 -   Installing Package File FileBasedCachingProvider_05.01.03_Install:  Success
00:00:21.843 -   Installing Package File FileModuleCachingProvider_05.04.03_Install:  Success
00:00:21.921 -   Installing Package File MemoryModuleCachingProvider_05.02.01_Install:  Success
00:00:22.015 -   Installing Package File SchedulingProvider_05.02.01_Install:  Success
00:00:22.109 -   Installing Package File SearchIndexProvider_05.01.00_Install:  Success
00:00:22.234 -   Installing Package File SearchProvider_05.01.01_Install:  Success
00:00:22.312 -   Installing Package File SolpartMenuNavigationProvider_05.01.00_Install:  Success
00:00:22.453 -   Installing Package File TelerikEditorProvider_05.04.02_Install:  Success
00:00:22.968 - Installing Optional AuthSystems:
00: -   Installing Package File LiveID_01.00.01_Install:  Success
00:00:23.937 -   Installing Package File OpenID_02.00.00_Install:  Success
00:00:24.203 - Installing Optional Packages:
Upgrade Complete


The file it mentions (05.05.00.log.resources) seems to be full or errors:


System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'DefaultLanguageGuid' in table 'dbo.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)






/* Add DefaultLanguageGuid Column to Tabs Table */
/************************************************/


IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME='Tabs' AND COLUMN_NAME='DefaultLanguageGuid')
    BEGIN
        -- Add new Column
        ALTER TABLE dbo.Tabs
            ADD DefaultLanguageGuid uniqueidentifier NULL
    END






System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'UniqueId' in table 'dbo.Folders' 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)






/**********************************************************/
/* Adding UniqueId and VersionGuid Columns to Folders Table */
/**********************************************************/
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME='Folders' AND COLUMN_NAME='UniqueId')
     BEGIN
           -- Add a new UniqueId Column
ALTER TABLE dbo.Folders
                ADD UniqueId UNIQUEIDENTIFIER NOT NULL CONSTRAINT DF_Folders_UniqueId DEFAULT NEWID()

ALTER TABLE dbo.Folders 
ADD CONSTRAINT IX_Folders_UniqueId UNIQUE NONCLUSTERED
(
UniqueId
)
     END




System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.AddFile', 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)






/**********************************************************/
/* Modify AddFile SP  */
/**********************************************************/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[AddFile]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
    DROP PROCEDURE dbo.AddFile




System.Data.SqlClient.SqlException: There is already an object named 'AddFile' in the database.
   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.AddFile
    @PortalId int,
    @UniqueId uniqueidentifier,
    @VersionGuid uniqueidentifier,
    @FileName nvarchar(100),
    @Extension nvarchar(100),
    @Size int,
    @Width int,
    @Height int,
    @ContentType nvarchar(200),
    @Folder nvarchar(200),
    @FolderID int,
@CreatedByUserID   int,
@Hash varchar(40)
AS
    DECLARE @FileID int
    SELECT @FileId = FileID FROM dbo.Files WHERE FolderID = @FolderID AND FileName = @FileName


    IF @FileID IS Null
        BEGIN
          INSERT INTO dbo.Files (
            PortalId,
            UniqueId,
            VersionGuid,
            FileName,
            Extension,
            Size,
            Width,
            Height,
            ContentType,
            Folder,
            FolderID,
CreatedByUserID,
CreatedOnDate,
LastModifiedByUserID,
LastModifiedOnDate,
SHA1Hash
          )
          VALUES (
            @PortalId,
            @UniqueId,
            @VersionGuid,
            @FileName,
            @Extension,
            @Size,
            @Width,
            @Height,
            @ContentType,
            @Folder,
            @FolderID,
@CreatedByUserID,
getdate(),
@CreatedByUserID,
getdate(),
@Hash
          )


          SELECT @FileID = SCOPE_IDENTITY()
        END
    ELSE
        BEGIN
          UPDATE dbo.Files
          SET    FileName = @FileName,
                 VersionGuid = @VersionGuid,
                 Extension = @Extension,
                 Size = @Size,
                 Width = @Width,
                 Height = @Height,
                 ContentType = @ContentType,
                 Folder = @Folder,
                 FolderID = @FolderID,
LastModifiedByUserID = @CreatedByUserID,
LastModifiedOnDate = getdate(),
SHA1Hash = @Hash
          WHERE  FileId = @FileID
        END


    SELECT @FileID




System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.UpdateFile', 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)






/**********************************************************/
/* Modify UpdateFile SP  */
/**********************************************************/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UpdateFile]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
    DROP PROCEDURE dbo.UpdateFile




System.Data.SqlClient.SqlException: There is already an object named 'UpdateFile' in the database.
   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.[UpdateFile]
    @FileId int,
    @VersionGuid uniqueidentifier,
    @FileName nvarchar(100),
    @Extension nvarchar(100),
    @Size int,
    @Width int,
    @Height int,
    @ContentType nvarchar(200),
    @Folder nvarchar(200),
    @FolderID int,
@LastModifiedByUserID   int,
@Hash varchar(40)
AS
    UPDATE dbo.Files
        SET    FileName = @FileName,
               VersionGuid = @VersionGuid,
               Extension = @Extension,
               Size = @Size,
               Width = @Width,
               Height = @Height,
               ContentType = @ContentType,
               Folder = @Folder,
               FolderID = @FolderID,
               LastModifiedByUserID = @LastModifiedByUserID,
               LastModifiedOnDate = getdate(),
  SHA1Hash = @Hash
    WHERE  FileId = @FileId




System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.AddFolder', 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)






/**********************************************************/
/* Modify AddFolder SP  */
/**********************************************************/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[AddFolder]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
    DROP PROCEDURE dbo.AddFolder




System.Data.SqlClient.SqlException: There is already an object named 'AddFolder' in the database.
   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.[AddFolder]
    @PortalID int,
    @UniqueId uniqueidentifier,
    @VersionGuid uniqueidentifier,
    @FolderPath varchar(300),
    @StorageLocation int,
    @IsProtected bit,
    @IsCached bit,
    @LastUpdated datetime,
    @CreatedByUserID   int
AS
    INSERT INTO dbo.Folders (
        PortalID, 
        UniqueId,
        VersionGuid,
        FolderPath, 
        StorageLocation, 
        IsProtected, 
        IsCached, 
        LastUpdated,
        CreatedByUserID,
        CreatedOnDate,
        LastModifiedByUserID,
        LastModifiedOnDate
    )
    VALUES (
        @PortalID, 
        @UniqueId,
        @VersionGuid,
        @FolderPath, 
        @StorageLocation, 
        @IsProtected, 
        @IsCached, 
        @LastUpdated,
        @CreatedByUserID,
        getdate(),
        @CreatedByUserID,
        getdate()
    )
    SELECT SCOPE_IDENTITY()




System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.UpdateFolder', 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)






/**********************************************************/
/* Modify UpdateFolder SP  */
/**********************************************************/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UpdateFolder]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
    DROP PROCEDURE dbo.UpdateFolder




System.Data.SqlClient.SqlException: There is already an object named 'UpdateFolder' in the database.
   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.[UpdateFolder]
    @PortalID int,
    @VersionGuid uniqueidentifier,
    @FolderID int,
    @FolderPath varchar(300),
    @StorageLocation int,
    @IsProtected bit,
    @IsCached bit,
    @LastUpdated datetime,
    @LastModifiedByUserID   int
AS
    UPDATE dbo.Folders
        SET    FolderPath = @FolderPath,
               VersionGuid = @VersionGuid,
               StorageLocation = @StorageLocation,
               IsProtected = @IsProtected,
               IsCached = @IsCached,
               LastUpdated = @LastUpdated,
               LastModifiedByUserID = @LastModifiedByUserID,
               LastModifiedOnDate = getdate()
        WHERE  ((PortalID = @PortalID) OR (PortalID IS Null AND @PortalID IS Null)) AND FolderID = @FolderID




System.Data.SqlClient.SqlException: Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
   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)






/* Modify AddTab */
/*****************/


IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[AddTab]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
    DROP PROCEDURE dbo.AddTab




System.Data.SqlClient.SqlException: There is already an object named 'AddTab' in the database.
   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.[AddTab]
    @ContentItemID int,
    @PortalID int,
    @UniqueId uniqueidentifier,
    @VersionGuid uniqueidentifier,
    @DefaultLanguageGuid uniqueidentifier,
    @LocalizedVersionGuid uniqueidentifier,
    @TabName nvarchar(50),
    @IsVisible bit,
    @DisableLink bit,
    @ParentId int,
    @IconFile nvarchar(100),
    @IconFileLarge nvarchar(100),
    @Title nvarchar(200),
    @Description nvarchar(500),
    @KeyWords nvarchar(500),
    @Url nvarchar(255),
    @SkinSrc nvarchar(200),
    @ContainerSrc nvarchar(200),
    @TabPath nvarchar(255),
    @StartDate datetime,
    @EndDate datetime,
    @RefreshInterval int,
    @PageHeadText nvarchar(500),
    @IsSecure bit,
    @PermanentRedirect bit,
    @SiteMapPriority float,
    @CreatedByUserID int,
    @CultureCode nvarchar(50)


AS


    INSERT INTO dbo.Tabs (
        ContentItemID,
        PortalID,
        UniqueId,
        VersionGuid,
        DefaultLanguageGuid,
        LocalizedVersionGuid,
        TabName,
        IsVisible,
        DisableLink,
        ParentId,
        IconFile,
        IconFileLarge,
        Title,
        Description,
        KeyWords,
        IsDeleted,
        Url,
        SkinSrc,
        ContainerSrc,
        TabPath,
        StartDate,
        EndDate,
        RefreshInterval,
        PageHeadText,
        IsSecure,
        PermanentRedirect,
        SiteMapPriority,
        CreatedByUserID,
        CreatedOnDate,
        LastModifiedByUserID,
        LastModifiedOnDate,
        CultureCode
    )
    VALUES (
        @ContentItemID,
        @PortalID,
        @UniqueId,
        @VersionGuid,
        @DefaultLanguageGuid,
        @LocalizedVersionGuid,
        @TabName,
        @IsVisible,
        @DisableLink,
        @ParentId,
        @IconFile,
        @IconFileLarge,
        @Title,
        @Description,
        @KeyWords,
        0,
        @Url,
        @SkinSrc,
        @ContainerSrc,
        @TabPath,
        @StartDate,
        @EndDate,
        @RefreshInterval,
        @PageHeadText,
        @IsSecure,
        @PermanentRedirect,
        @SiteMapPriority,
        @CreatedByUserID,
        getdate(),
        @CreatedByUserID,
        getdate(),
        @CultureCode
    )


    SELECT SCOPE_IDENTITY()




System.Data.SqlClient.SqlException: There is already an object named 'AddTabModule' in the database.
   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.[AddTabModule]
    @TabId                  int,
    @ModuleId               int,
@ModuleTitle nvarchar(256),
@Header ntext,
@Footer ntext,
    @ModuleOrder            int,
    @PaneName               nvarchar(50),
    @CacheTime              int,
    @CacheMethod varchar(50),
    @Alignment              nvarchar(10),
    @Color                  nvarchar(20),
    @Border                 nvarchar(1),
    @IconFile               nvarchar(100),
    @Visibility             int,
    @ContainerSrc           nvarchar(200),
    @DisplayTitle           bit,
    @DisplayPrint           bit,
    @DisplaySyndicate       bit,
    @IsWebSlice bit,
    @WebSliceTitle nvarchar(256),
    @WebSliceExpiryDate     datetime,
    @WebSliceTTL int,
    @UniqueId uniqueidentifier,
    @VersionGuid uniqueidentifier,
    @DefaultLanguageGuid uniqueidentifier,
    @LocalizedVersionGuid uniqueidentifier,
    @CultureCode nvarchar(10),
    @CreatedByUserID   int


AS
    INSERT INTO dbo.TabModules ( 
        TabId,
        ModuleId,
        ModuleTitle,
        Header,
        Footer,
ModuleOrder,
        PaneName,
        CacheTime,
        CacheMethod,
        Alignment,
        Color,
        Border,
        IconFile,
        Visibility,
        ContainerSrc,
        DisplayTitle,
        DisplayPrint,
        DisplaySyndicate,
        IsWebSlice,
        WebSliceTitle,
        WebSliceExpiryDate,
        WebSliceTTL,
        UniqueId,
        VersionGuid,
        DefaultLanguageGuid,
        LocalizedVersionGuid,
        CultureCode,
        CreatedByUserID,
        CreatedOnDate,
        LastModifiedByUserID,
        LastModifiedOnDate
    )
    VALUES (
        @TabId,
        @ModuleId,
        @ModuleTitle,
        @Header,
        @Footer,
        @ModuleOrder,
        @PaneName,
        @CacheTime,
        @CacheMethod,
        @Alignment,
        @Color,
        @Border,
        @IconFile,
        @Visibility,
        @ContainerSrc,
        @DisplayTitle,
        @DisplayPrint,
        @DisplaySyndicate,
        @IsWebSlice,
        @WebSliceTitle,
        @WebSliceExpiryDate,
        @WebSliceTTL,
        @UniqueId,
        @VersionGuid,
        @DefaultLanguageGuid,
        @LocalizedVersionGuid,
        @CultureCode,
        @CreatedByUserID,
        getdate(),
        @CreatedByUserID,
        getdate()
    )






System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.DeleteTabModule', 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)






/* Update DeleteTabModule  */
/***************************/


IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[DeleteTabModule]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.DeleteTabModule




System.Data.SqlClient.SqlException: There is already an object named 'DeleteTabModule' in the database.
   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.[DeleteTabModule]
@TabId      int,
@ModuleId   int,
@SoftDelete bit
AS
IF @SoftDelete = 1
UPDATE dbo.TabModules
SET IsDeleted = 1,
VersionGuid = newId()
WHERE  TabId = @TabId
AND    ModuleId = @ModuleId
ELSE
DELETE
FROM   dbo.TabModules 
WHERE  TabId = @TabId
AND    ModuleId = @ModuleId






System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.RestoreTabModule', 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)






/* Update RestoreTabModule */
/***************************/


IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[RestoreTabModule]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.RestoreTabModule




System.Data.SqlClient.SqlException: There is already an object named 'RestoreTabModule' in the database.
   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.[RestoreTabModule]
@TabId      int,
@ModuleId   int
AS
UPDATE dbo.TabModules
SET IsDeleted = 0,
VersionGuid = newId()
WHERE  TabId = @TabId
AND    ModuleId = @ModuleId






System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.UpdateModuleOrder', 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)






/* Update UpdateModuleOrder */
/***************************/


IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UpdateModuleOrder]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE dbo.UpdateModuleOrder




System.Data.SqlClient.SqlException: There is already an object named 'UpdateModuleOrder' in the database.
   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.[UpdateModuleOrder]
@TabId              int,
@ModuleId           int,
@ModuleOrder        int,
@PaneName           nvarchar(50)
AS
UPDATE dbo.TabModules
SET ModuleOrder = @ModuleOrder,
PaneName = @PaneName,
VersionGuid = newId()
WHERE TabId = @TabId
AND ModuleId = @ModuleId






System.Data.SqlClient.SqlException: There is already an object named 'UpdateTabModule' in the database.
   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.[UpdateTabModule]
    @TabModuleId            int,
    @TabId int,
    @ModuleId int,
@ModuleTitle nvarchar(256),
@Header ntext,
@Footer ntext,
    @ModuleOrder int,
    @PaneName nvarchar(50),
    @CacheTime int,
    @CacheMethod varchar(50),
    @Alignment nvarchar(10),
    @Color nvarchar(20),
    @Border nvarchar(1),
    @IconFile nvarchar(100),
    @Visibility int,
    @ContainerSrc nvarchar(200),
    @DisplayTitle bit,
    @DisplayPrint bit,
    @DisplaySyndicate bit,
    @IsWebSlice bit,
    @WebSliceTitle nvarchar(256),
    @WebSliceExpiryDate datetime,
    @WebSliceTTL int,
    @VersionGuid uniqueidentifier,
    @DefaultLanguageGuid uniqueidentifier,
    @LocalizedVersionGuid uniqueidentifier,
    @CultureCode nvarchar(10),
    @LastModifiedByUserID int


AS
    UPDATE dbo.TabModules
        SET    
            TabId = @TabId,
            ModuleId = @ModuleId,
ModuleTitle = @ModuleTitle,
Header = @Header,
Footer = @Footer, 
            ModuleOrder = @ModuleOrder,
            PaneName = @PaneName,
            CacheTime = @CacheTime,
            CacheMethod = @CacheMethod,
            Alignment = @Alignment,
            Color = @Color,
            Border = @Border,
            IconFile = @IconFile,
            Visibility = @Visibility,
            ContainerSrc = @ContainerSrc,
            DisplayTitle = @DisplayTitle,
            DisplayPrint = @DisplayPrint,
            DisplaySyndicate = @DisplaySyndicate,
            IsWebSlice = @IsWebSlice,
            WebSliceTitle = @WebSliceTitle,
            WebSliceExpiryDate = @WebSliceExpiryDate,
            WebSliceTTL = @WebSliceTTL,
            VersionGuid = @VersionGuid,
            DefaultLanguageGuid = @DefaultLanguageGuid,
            LocalizedVersionGuid = @LocalizedVersionGuid,
            CultureCode= @CultureCode,
            LastModifiedByUserID = @LastModifiedByUserID,
            LastModifiedOnDate = getdate()
        WHERE  TabModuleId = @TabModuleId






System.Data.SqlClient.SqlException: There is already an object named 'EnsureLocalizationExists' in the database.
   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.EnsureLocalizationExists
@PortalId       int,
@CultureCode nvarchar(10)
AS
IF NOT EXISTS (SELECT * FROM dbo.PortalLocalization WHERE CultureCode=@CultureCode AND Portalid=@PortalId)
BEGIN
DECLARE @PortalName nvarchar(128)
DECLARE @LogoFile nvarchar(50)
DECLARE @FooterText nvarchar(100)
DECLARE @Description nvarchar(500)
DECLARE @KeyWords nvarchar(500)
DECLARE @BackgroundFile nvarchar(50)
DECLARE @HomeTabId int
DECLARE @LoginTabId int
DECLARE @UserTabId int
DECLARE @AdminTabId int
DECLARE @RegisterTabId int

DECLARE @defaultlanguage nvarchar(10)

SELECT @defaultlanguage= DefaultLanguage FROM dbo.Portals WHERE Portalid=@PortalId


IF EXISTS (SELECT * FROM dbo.PortalLocalization WHERE CultureCode=@defaultlanguage AND Portalid=@PortalId)
BEGIN
--clone the default language
SELECT 
@PortalName = PortalName,
@LogoFile = LogoFile,
@FooterText = FooterText,
@Description = Description,
@KeyWords = KeyWords,
@BackgroundFile = BackgroundFile,
@HomeTabId = HomeTabId,
@LoginTabId = LoginTabId,
@UserTabId = UserTabId,
@AdminTabId = AdminTabId,
@RegisterTabId = RegisterTabId 
FROM dbo.PortalLocalization WHERE CultureCode=@defaultlanguage AND Portalid=@PortalId

INSERT INTO dbo.PortalLocalization (
PortalId,
CultureCode,
PortalName,
LogoFile,
FooterText,
Description,
KeyWords,
BackgroundFile, 
HomeTabId,
LoginTabId,
UserTabId,
AdminTabId,
RegisterTabId,
CreatedByUserID,
CreatedOnDate,
LastModifiedByUserID,
LastModifiedOnDate
) 
VALUES (
@PortalId,
@CultureCode,
@PortalName,
@LogoFile,
@FooterText,
@Description,
@KeyWords,
@BackgroundFile,
@HomeTabId,
@LoginTabId,
@UserTabId,
@AdminTabId,
@RegisterTabId,
-1,
getdate(),
-1,
getdate()
)
END
ELSE
BEGIN
IF EXISTS (select * from dbo.PortalLocalization where CultureCode='en-us' and Portalid=@PortalId)
BEGIN
--if defaultlanguage is missing clone en-us if available
SELECT 
@PortalName = PortalName,
@LogoFile = LogoFile,
@FooterText = FooterText,
@Description = Description,
@KeyWords = KeyWords,
@BackgroundFile = BackgroundFile,
@HomeTabId = HomeTabId,
@LoginTabId=LoginTabId,
@UserTabId=UserTabId,
@AdminTabId=AdminTabId,
@RegisterTabId=RegisterTabId 
FROM dbo.PortalLocalization where CultureCode='en-us' and Portalid=@PortalId

INSERT INTO dbo.PortalLocalization (
PortalId,
CultureCode,
PortalName,
LogoFile,
FooterText,
Description,
KeyWords,
BackgroundFile, 
HomeTabId,
LoginTabId,
UserTabId,
AdminTabId,
RegisterTabId,
CreatedByUserID,
CreatedOnDate,
LastModifiedByUserID,
LastModifiedOnDate
) 
VALUES (
@PortalId,
@CultureCode,
@PortalName,
@LogoFile,
@FooterText,
@Description,
@KeyWords,
@BackgroundFile,
@HomeTabId,
@LoginTabId,
@UserTabId,
@AdminTabId,
@RegisterTabId,
-1,
getdate(),
-1,
getdate()
)
END
ELSE
BEGIN
IF EXISTS (select top 1 * from dbo.PortalLocalization where  Portalid=@PortalId)
BEGIN
--cannot select by particular culturecode as defaultlanguage has been deleted (possible in early versions of DotNetNuke)
SELECT TOP 1 
@PortalName = PortalName,
@LogoFile = LogoFile,
@FooterText = FooterText,
@Description = Description,
@KeyWords = KeyWords,
@BackgroundFile = BackgroundFile,
@HomeTabId = HomeTabId,
@LoginTabId=LoginTabId,
@UserTabId=UserTabId,
@AdminTabId=AdminTabId,
@RegisterTabId=RegisterTabId 
FROM dbo.PortalLocalization where portalid=@PortalId

INSERT INTO dbo.PortalLocalization (
PortalId,
CultureCode,
PortalName,
LogoFile,
FooterText,
Description,
KeyWords,
BackgroundFile, 
HomeTabId,
LoginTabId,
UserTabId,
AdminTabId,
RegisterTabId,
CreatedByUserID,
CreatedOnDate,
LastModifiedByUserID,
LastModifiedOnDate
) 
VALUES (
@PortalId,
@CultureCode,
@PortalName,
@LogoFile,
@FooterText,
@Description,
@KeyWords,
@BackgroundFile,
@HomeTabId,
@LoginTabId,
@UserTabId,
@AdminTabId,
@RegisterTabId,
-1,
getdate(),
-1,
getdate()
)
END
END
END
END




System.Data.SqlClient.SqlException: There is already an object named 'GetHostSettings' in the database.
   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.[GetHostSettings]
AS
IF NOT EXISTS ( select 1 from dbo.HostSettings where SettingName = 'GUID' )
 INSERT INTO dbo.HostSettings ( SettingName, SettingValue, SettingIsSecure ) values ( 'GUID', newid(), 0 )


SELECT SettingName,
  SettingValue,
  SettingIsSecure,
  CreatedByUserID,
  CreatedOnDate,
      LastModifiedByUserID,
  LastModifiedOnDate
FROM   dbo.HostSettings


Having said all that, the site seems to work okay. Should I worry about these errors? Can I fix them?


Thanks again for all your assistance!
 
New Post
8/19/2010 3:11 PM
 
William Severance


www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
The good news is that you got past the earlier application error that was most likely due to the web.config issue. The bad news is that because many of the modifications to database objects in the 05.05.00.SqlDataProvider script failed to execute, your site, while initially appearing to function is likely to have serious issues in some functions and its data integrity either now or when performing later upgrades. You will need to restore the filesystem and database from the 5.4.4 backups. But before doing so, let's try to find out what happened by answering the following:

1. After the first failed upgrade attempt you indicated that you restored back to 5.4.4. Did you restore the database backup as well as the filesystem backup?
2. Is the value for the objectQualifier in the web.config blank?
3. Is the dbo user in the db_Owner role in the database or some more limited role?
4. Is the database user specified in the connection strings in web.config in the db_Owner role in the database or some more limited role?
5. What is the MS SQL Server version (2000, 2005, 2008)?
5. Please run the following query in the Host-->SQL screen with "Run as Script" checked:

SELECT name, uid, USER_NAME(uid) As 'Username'
FROM dbo.sysobjects
WHERE (uid=@uid)
AND (OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
AND (name in ('{objectQualifier}AddFile', '{objectQualifier}UpdateFile',
'{objectQualifier}AddFolder', '{objectQualifier}UpdateFolder',
'{objectQualifier}AddTab', '{objectQualifier}AddTabModule',
'{objectQualifier}DeleteTabModule', '{objectQualifier}RestoreTabModule',
'{objectQualifier}UpdateModuleOrder', '{objectQualifier}UpdateTabModule',
'{objectQualifier}EnsureLocalizationExists',
'{objectQualifier}GetHostSettings'))

GO

I am most interested to know what value appears in the UserName column and if that user has been granted db_Owner role in database. The common factor in most of the script errors appears to be insufficient permissions to drop certain stored procedures. Yet, other drops in the script apparently completed without error.

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
8/23/2010 10:54 AM
 
AbrieViljoen

Joined: 10/22/2007
Posts: 1
My solution:

1.) I went into the "DotNetNuke_Community_05.05.00_Upgrade.zip\Install\Telerik_05.05.00_Install.zip" file and extracted the new "Telerik.Web.UI.dll" file from the Bin folder, it's about 16Mb.

2.) Then with my FTP I went into the Bin folder on my website and uploaded the extracted Telerik.Web.UI.dll file overwriting the old file that was about 15MB, after that the upgrade went on smoothly.

I also updated my web.config file from the DotNetNuke_Community_05.05.00_Install.zip file, only changing my connection setting to the needed setup, but I don't think you have to do this step to get everything working again.
 
 Page 2 of 2
Previous12 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Upgrade from 5.4.4 to 5.5.0 caused site to fail to loadUpgrade from 5.4.4 to 5.5.0 caused site to fail to load


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