Register  Login  
  February 6, 2012  
Search_Blog Minimize
Print  

Blog_Archive Minimize
Print  

Blog    
View_Blog Minimize
Jun 23

Written by: host
Tuesday, June 23, 2009 4:46 PM 

The new release of DNN 5.1 does have a small (very small) issue when converting from V4 DNN site.  The problem exists with a key and the conversion script does not drop the key due to a naming issue.  There is a fix and is available from the support wesite. 

If you are upgrading from 4, please read.  The issue is simple to fix as even if you don't you should not encounter any problems.

 I have included Charles Nurses' comments and script below - a direct copy from the support.dotnetnuke.com site. 


 

There is a bug in the 5.0.0 script which renames the Primary Key from PK_EventLogMaster with no object qualifer to PK_{objectQualifier}EventLog.

Unfortunately the Schema.SqlDataProvider script introduced in 5.0 (and the basis of all 5.x new installs, 5.0.0, 5.0.1 and 5.1.0) names this key PK_{objectQualifier}EventLogMaster.

The problem is that the 5.1.0 script attempts to drop this key, and place it on the new Identity column (EventID) for performance improvements when clearing the log.

So pre 5.0 sites will get an error when upgrading from the 5.1.0 script file.

It does not affect the site - all that happens is that these sites have the primary key on the wrong column and will not get the performance gain.

This will be fixed in the next maintenance release.  In the meantime users experiencing this issue can paste this script in the Host SQL module.

/* Fix bug in changing the primary key of EventLog Table */
/*********************************************************/

--Some scenarios had the primary key as PK_{objectQualifier}EventLog
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_{objectQualifier}EventLog'))
    BEGIN
        ALTER TABLE {databaseOwner}{objectQualifier}EventLog
            DROP CONSTRAINT PK_{objectQualifier}EventLog
       
        ALTER TABLE {databaseOwner}{objectQualifier}EventLog
            ADD CONSTRAINT PK_{objectQualifier}EventLogMaster PRIMARY KEY CLUSTERED ( LogEventID )
    END   
GO


 


Tags:

1 comment(s) so far...

Re: Chinese Footware - and the removal of...

GameCoach Factory Outlet Onlineare usuallyCoach Factoryin By Coach Outlet Online on   Thursday, February 02, 2012 1:18 AM


Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
Enter the code shown above in the box below
Add Comment   Cancel 

Blog_List Maximize
Print  

  Home | Blog | Forum | Subscriptions | Free Modules | Videos   Page generated in 0.078253 seconds.
  Copyright 2010 by TressleWorks   Terms Of Use | Privacy Statement