DotNetNuke_Community_05.05.01_Install error

Discussion in 'Third-party applications' started by Jimforreg, Nov 10, 2010.

  1. Hi,

    During setting up DotNetNuke_Community_05.05.01_Install there are errors:

    00:00:00.094 - Installing Version: 05.00.00
    00:00:00.099 - Executing Script: DotNetNuke.Schema.SqlDataProvider Success
    00:00:03.938 - Executing Script: DotNetNuke.Data.SqlDataProvider Success
    00:00:06.689 - Installing MemberRole Provider:
    00:00:06.691 - Executing Script: InstallCommon
    00:00:06.926 - Executing Script: InstallMembership
    00:00:07.411 - Executing Script: InstallProfile
    00:00:07.676 - Executing Script: InstallRoles
    00:00:08.050 - Upgrading to Version: 05.05.01
    00:00:08.063 - Executing Script: 05.00.01.SqlDataProvider Success
    00:00:08.458 - Executing Script: 05.01.00.SqlDataProvider Success
    00:00:10.962 - Executing Script: 05.01.01.SqlDataProvider Success
    00:00:11.352 - Executing Script: 05.01.02.SqlDataProvider Success
    00:00:11.476 - Executing Script: 05.01.03.SqlDataProvider Success
    00:00:11.574 - Executing Script: 05.01.04.SqlDataProvider Success
    00:00:11.624 - Executing Script: 05.02.00.SqlDataProvider Error! (see 05.02.00.log.resources for more information)
    00:00:12.269 - Executing Script: 05.02.01.SqlDataProvider Error! (see 05.02.01.log.resources for more information)
    00:00:12.758 - Executing Script: 05.02.02.SqlDataProvider Error! (see 05.02.02.log.resources for more information)


    here are the log.files:

    05.02.00.log.resources:

    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.ExecuteAD
    System.Data.SqlClient.SqlException: Syntax error converting the varchar value 'True' to a column of data type bit.
    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)
    OScript(String SQL)
    at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)


    05.02.01.log.resources

    System.Data.SqlClient.SqlException: Syntax error converting the varchar value 'True' to a column of data type bit.
    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)

    05.02.02.log.resources

    System.Data.SqlClient.SqlException: Syntax error converting the varchar value 'True' to a column of data type bit.
    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)


    I use winXP, MS VS 2008, SQL 2005

    Thanks for help.
     
  2. Solved. Current SQL version is 2000. Need to upgrade to 2005/2008
     
  3. Cool, glad you got it worked out.
     

Share This Page