Ok I uninstalled framework .net 4 and website is set for framework .net 2 now with framework .net 3.5 PS1 installed. Here is the error I get when trying to do the upgrade:
Upgrading DotNetNuke
Current Assembly Version: 05.05.00
Current Database Version: 05.01.04
Upgrade Status Report
00:00:00.140 - Upgrading to Version: 05.05.00
00:00:00.200 - Executing Script: 05.02.00.SqlDataProvider Error! (see 05.02.00.log.resources for more information)
00:00:01.692 - Executing Script: 05.02.01.SqlDataProvider Error! (see 05.02.01.log.resources for more information)
00:00:02.103 - Executing Script: 05.02.02.SqlDataProvider Error! (see 05.02.02.log.resources for more information)
00:00:02.123 - Executing Script: 05.02.03.SqlDataProvider Success
00:00:02.173 - Executing Script: 05.03.00.SqlDataProvider Error! (see 05.03.00.log.resources for more information)
00:00:02.703 - Executing Script: 05.03.01.SqlDataProvider Success
00:00:02.713 - Executing Script: 05.04.00.SqlDataProvider Error! (see 05.04.00.log.resources for more information)
00:00:03.294 - Executing Script: 05.04.01.SqlDataProvider Success
00:00:03.324 - Executing Script: 05.04.02.SqlDataProvider Success
00:00:03.364 - Executing Script: 05.04.03.SqlDataProvider Success
00:00:03.404 - Executing Script: 05.04.04.SqlDataProvider Success
00:00:03.444 - Executing Script: 05.05.00.SqlDataProvider Error! (see 05.05.00.log.resources for more information)
00:00:05.397 - Executing Application Upgrades: 05.02.00 Error!
00:00:07.480 - Executing Application Upgrades: 05.02.01 Success
00:00:07.490 - Executing Application Upgrades: 05.02.02 Success
00:00:07.490 - Executing Application Upgrades: 05.02.03 Success
00:00:07.490 - Executing Application Upgrades: 05.03.00 Error!
00:00:07.871 - Executing Application Upgrades: 05.03.01 Success
00:00:07.871 - Executing Application Upgrades: 05.04.00 Error!
00:00:08.672 - Executing Application Upgrades: 05.04.01 Success
00:00:08.672 - Executing Application Upgrades: 05.04.02 Success
00:00:08.672 - Executing Application Upgrades: 05.04.03 Success
00:00:08.682 - Executing Application Upgrades: 05.04.04 Success
00:00:08.682 - Executing Application Upgrades: 05.05.00 Success
00:00:09.393 - Cleaning Up Files: 05.02.00 Success
00:00:09.393 - Cleaning Up Files: 05.02.01 Success
00:00:09.393 - Cleaning Up Files: 05.02.02 Success
00:00:09.393 - Cleaning Up Files: 05.02.03 Success
00:00:09.393 - Cleaning Up Files: 05.03.00 Success
00:00:09.393 - Cleaning Up Files: 05.03.01 Success
00:00:09.393 - Cleaning Up Files: 05.04.00 Success
00:00:09.393 - Cleaning Up Files: 05.04.01 Success
00:00:09.393 - Cleaning Up Files: 05.04.02 Success
00:00:09.393 - Cleaning Up Files: 05.04.03 Success
00:00:09.393 - Cleaning Up Files: 05.04.04 Success
00:00:09.393 - Cleaning Up Files: 05.05.00 Success
00:00:09.393 - Updating Config Files: 05.02.00 Success
00:00:09.403 - Updating Config Files: 05.02.01 Success
00:00:09.433 - Updating Config Files: 05.02.02 Success
00:00:09.433 - Updating Config Files: 05.02.03 Success
00:00:09.433 - Updating Config Files: 05.03.00 Success
00:00:09.433 - Updating Config Files: 05.03.01 Success
00:00:09.433 - Updating Config Files: 05.04.00 Success
00:00:09.433 - Updating Config Files: 05.04.01 Success
00:00:09.433 - Updating Config Files: 05.04.02 Success
00:00:09.433 - Updating Config Files: 05.04.03 Success
00:00:09.433 - Updating Config Files: 05.04.04 Success
00:00:09.433 - Updating Config Files: 05.05.00 Success
00:00:09.443 - Performing General Upgrades
--------------------------------------------------------------------------------
Server Error in '/' Application.
--------------------------------------------------------------------------------
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:
1. Add a "Debug=true" directive at the top of the file that generated the error. Example:
or:
2) Add the following section to the configuration file of your application:
Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.
Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication() +54
DotNetNuke.Services.Upgrade.Upgrade.UpgradeDNN(String strProviderPath, Version dataBaseVersion) +807
DotNetNuke.Services.Install.Install.UpgradeApplication() +950
DotNetNuke.Services.Install.Install.Page_Load(Object sender, EventArgs e) +272
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
The Log file shows the following:
System.Data.SqlClient.SqlException: Line 6: Incorrect syntax near ';'.
'ROW_NUMBER' is not a recognized function name.
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.nuke_PurgeEventLog
AS
;WITH logcounts AS
(
SELECT
LogEventID,
LogConfigID,
ROW_NUMBER() OVER(PARTITION BY LogConfigID ORDER BY LogCreateDate DESC) AS logEventSequence
FROM dbo.nuke_EventLog
)
DELETE dbo.nuke_EventLog
FROM dbo.nuke_EventLog el
JOIN logcounts lc ON el.LogEventID = lc.LogEventID
INNER JOIN dbo.nuke_EventLogConfig elc ON elc.ID = lc.LogConfigID
WHERE elc.KeepMostRecent <> -1
AND lc.logEventSequence > elc.KeepMostRecent
System.Data.SqlClient.SqlException: Line 6: Incorrect syntax near 'max'.
Line 7: Incorrect syntax near 'max'.
Must declare the variable '@header'.
Must declare the variable '@Header'.
Must declare the variable '@header'.
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)
/* migrate module values to tabmodules */
declare @moduleID int
declare @moduleTitle [nvarchar](256)
declare @header nvarchar(max)
declare @footer nvarchar(max)
--Iterate through each module
DECLARE Module_Cursor CURSOR FOR
SELECT moduleID,ModuleTitle, Header, Footer from dbo.nuke_Modules
OPEN Module_Cursor
--get first
FETCH NEXT FROM Module_Cursor
into @moduleID,@moduleTitle,@header,@footer
WHILE @@FETCH_STATUS = 0
BEGIN
update dbo.nuke_tabmodules set ModuleTitle=@moduleTitle,Header=@Head... where moduleID=@moduleID
FETCH NEXT FROM Module_Cursor
into @moduleID,@moduleTitle,@header,@footer
END
CLOSE Module_Cursor;
DEALLOCATE Module_Cursor;