It's been a while since I've asked for help on the DNN forums... Quite refreshing, really. :)
I am trying to upgrade a site from DNN 7.0.2 to any version of DNN 7.1.x. Each gives me the same error. The SqlDataProvider file throws errors, and subsequently, none of the other following upgrade tasks will complete successfully.
The error I am getting is:
[ERROR] DotNetNuke.Services.Upgrade.Upgrade System.Data.SqlClient.SqlException (0x80131904): Column, parameter, or variable #22: Cannot find data type date.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
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.ExecuteScriptInternal(String connectionString, String script)
The SQL that errors out is:
IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'{objectQualifier}Files' AND COLUMN_NAME = 'StartDate')
ALTER TABLE {databaseOwner}[{objectQualifier}Files]
ADD [StartDate] date NULL DEFAULT GETDATE()
GO
This is odd, because it doesn't look like it's wrong... Anyone have any idea how to get around this error?