Error when upgrading DNN: Executing Script: 05.01.00.SqlDataProvider Error! - Let It Shine - DNN Support Blog - DotNetNuke Support

Text Adjustment:

Background Styles:

Monday, February 06, 2012

DNN Support

Forums > DotNetNuke Support > DotNetNuke Support

Reply To Topic

Topic: Error when upgrading DNN: Executing Script: 05.01.00.SqlDataProvider Error!

Posted By Mark Buelsing on 01 Apr 2010 06:00 PM
When upgrading DNN from 4.X to 5.X, if you see an error in the upgrade Status Report that looks like this: 00:00:00.046 - Upgrading to Version: 05.01.00 00:00:00.296 - Executing Script: 05.00.00.SqlDataProvider Success 00:00:05.859 - Executing Script: 05.00.01.SqlDataProvider Success 00:00:08.093 - Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information) 00:00:19.718 - Executing Application Upgrades: 05.00.00 Success 00:00:57.203 - Executing Application Upgrades: 05.00.01 Success This is a relatively benign issue concerning the EventLog table. It can be safely ignored, however it will make your site just a little faster if you take care of it. The following explanation was taken from a forum post found here: http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/107/threadid/315586/scope/posts/threadpage/2/Default.aspx “When you upgrade a 04.09.04 install version with the upgrade script from 05.01.00, the script tries to (and succeeds) in adding a new bigint field (autonumber, not null) called "LogEventID" in the EventLog table. The script fails however in making this field the primary field. You can manually remove the primary key from the field LogGUID (but leave the field in the table) and make the LogEventID a primary key. As already stated this error will have no impact on the application, however when it is not the primary key it will slow down performance when doing lookup's in the table with this field because it is not indexed”

Username:

Security Code: