DNN : ver. 4.9.4
Database : SqlServer 2000

Upgrade DnnEvents module from 4.00.02 to 5.00.02 RC1

Message :

Etape en cours : Début de traitement SQL
Info  Traitement en cours :04.01.00.SqlDataProvider
Etape en cours : Début de traitement de script Sql : 04.01.00.SqlDataProvider 
Erreur pendant la génération SQL : System.Data.SqlClient.SqlException: Line 12: Incorrect syntax near 'max'. 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) /************************************************************/ /************************************************************/ /***** *****/ /***** Correct Invalid data *****/ /***** *****/ /************************************************************/ /************************************************************/ /* Change EventName to nVarchar since it should be and isn't from old versions */ ALTER TABLE dbo.[Events] ALTER COLUMN [EventName] NVARCHAR (max) 

I have tidied this up, and fixed for the next release of 5.0.2.

Roger

Hi Barry,

Just had a look through, and whilst I thought this would have made it in to the version in the release process, it didn't. It will be in the 5.0.3 release.

This bug is caused by a correction to the 4.1.0 update script, and in the vast majority of situations can be ignored. You can check whether it matters by checking to see if the EventName column in the Events table is of type nVarchar(100). If it is, there is no problem for you.

Cheers
Roger