Hi all,
I get an error when trying to upgrade a DDN v4.8.0 to v4.9.2. Initialy i tried to upgrade to v5.0.1 but got to different errors, so im upgrading it in to steps to minimize confusion.
Upgrade Status Report:
....
00:00:01.382 - Executing Script: 04.09.01.SqlDataProvider Error! (see 04.09.01.log for more information)
....
04.09.01.log:
System.Data.SqlClient.SqlException: Invalid column name 'LastActivityDate'.
Invalid column name 'LastActivityDate'.
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.dnn_UpdateServer
@ServerName nvarchar(50),
@CreatedDate datetime,
@LastActivityDate datetime
AS
DECLARE @ServerID int
SET @ServerID = (SELECT ServerID FROM dbo.dnn_Servers WHERE ServerName = @ServerName)
IF @ServerID IS NULL
BEGIN
-- Insert
INSERT INTO dbo.dnn_Servers (
ServerName,
CreatedDate,
LastActivityDate
)
VALUES (
@ServerName,
@CreatedDate,
@LastActivityDate
)
END
ELSE
BEGIN
-- Update
UPDATE dbo.dnn_Servers
SET LastActivityDate = @LastActivityDate
WHERE ServerName = @ServerName
END
What am i doing wrong? :-)
Thanks in advance.