Hi there,

I am trying ti install DNN 5.6.2 but having some problems.

I gave all read and write permissions to the folder, choose collation Latin1_General_CI_AS and my database is not case sensitive...

The error message that I got and the log file is below.

ERROR:
Installing Database - Version 05.00.00...Success
Upgrading Database to Version 05.00.01...Success
Upgrading Database to Version 05.01.00...FAILURE ERROR: (see 05.01.00.log for more information)


LOG:
System.Data.SqlClient.SqlException: Must declare the scalar variable "@id".
Must declare the scalar variable "@id".
Must declare the scalar variable "@id".
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (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.[AddSearchItemWord]
   @SearchItemID  INT,
   @SearchWordsID INT,
   @Occurrences   INT
AS
  DECLARE  @ID INT
  SELECT @id = SearchItemWordId
  FROM   dbo.SearchItemWord
  WHERE  SearchItemId = @SearchItemID
         AND SearchWordsId = @SearchWordsID
  IF @ID IS NULL
    BEGIN
      INSERT INTO dbo.SearchItemWord
                 ([SearchItemId],
                  [SearchWordsId],
                  [Occurrences])
      VALUES     (@SearchItemID,
                  @SearchWordsID,
                  @Occurrences)
      SELECT Scope_identity()
    END
  ELSE
    BEGIN
      UPDATE dbo.SearchItemWord
      SET    Occurrences = @Occurrences
      WHERE  SearchItemWordId = @id
             AND Occurrences <> @Occurrences
      SELECT @id
    END


Any suggestions?