Hi

upgraded to DNN 4.8 without issues. However, when I decided to install the Announcement module 4.00 I get the following error message :

Thanks in advance for your help

Leif

StartJob

Début de traitement de script Sql : 04.00.00.SqlDataProvider

Failure

Erreur pendant la génération SQL : System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to operation. 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.dnnAnnouncements_Get @ItemId int, @ModuleId int as select dbo.Announcements.ItemId, dbo.Announcements.ModuleId, dbo.Announcements.CreatedByUser, dbo.Announcements.CreatedDate, dbo.Announcements.Title, dbo.Announcements.ImageSource, dbo.Announcements.URL, dbo.Announcements.Description, dbo.Announcements.ViewOrder, dbo.Announcements.PublishDate, dbo.Announcements.ExpireDate, dbo.UrlTracking.TrackClicks, dbo.UrlTracking.NewWindow from dbo.Announcements left outer join dbo.UrlTracking on dbo.Announcements.URL = dbo.UrlTracking.Url and dbo.UrlTracking.ModuleId = @ModuleID where dbo.Announcements.ItemId = @ItemId and dbo.Announcements.ModuleId = @ModuleId System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to operation. 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.dnnAnnouncements_GetCurrent @ModuleId int, @StartDate datetime as select dbo.Announcements.ItemId, dbo.Announcements.ModuleId, dbo.Announcements.CreatedByUser, dbo.Announcements.CreatedDate, dbo.Announcements.Title, dbo.Announcements.ImageSource, dbo.Announcements.URL, dbo.Announcements.Description, dbo.Announcements.ViewOrder, dbo.Announcements.PublishDate, dbo.Announcements.ExpireDate, dbo.UrlTracking.TrackClicks, dbo.UrlTracking.NewWindow from dbo.Announcements left outer join dbo.UrlTracking on dbo.Announcements.URL = dbo.UrlTracking.Url and dbo.UrlTracking.ModuleId = @ModuleID where dbo.Announcements.ModuleId = @ModuleId and ( ((dbo.Announcements.PublishDate >= @StartDate) or @StartDate is null) and (dbo.Announcements.PublishDate <= GETDATE()) ) and ( (dbo.Announcements.ExpireDate > getDate()) or (dbo.Announcements.ExpireDate is null) ) order by dbo.Announcements.ViewOrder asc, dbo.Announcements.PublishDate desc System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to operation. 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.dnnAnnouncements_GetExpired @ModuleId int as select dbo.Announcements.ItemId, dbo.Announcements.ModuleId, dbo.Announcements.CreatedByUser, dbo.Announcements.CreatedDate, dbo.Announcements.Title, dbo.Announcements.ImageSource, dbo.Announcements.URL, dbo.Announcements.Description, dbo.Announcements.ViewOrder, dbo.Announcements.PublishDate, dbo.Announcements.ExpireDate, dbo.UrlTracking.TrackClicks, dbo.UrlTracking.NewWindow from dbo.Announcements left outer join dbo.UrlTracking on dbo.Announcements.URL = dbo.UrlTracking.Url and dbo.UrlTracking.ModuleId = @ModuleID where dbo.Announcements.ModuleId = @ModuleId and dbo.Announcements.ExpireDate <= getDate() order by dbo.Announcements.ViewOrder asc, dbo.Announcements.PublishDate desc System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to operation. 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.dnnAnnouncements_GetAll @ModuleId int, @StartDate datetime, @EndDate datetime as select dbo.Announcements.ItemId, dbo.Announcements.ModuleId, dbo.Announcements.CreatedByUser, dbo.Announcements.CreatedDate, dbo.Announcements.Title, dbo.Announcements.ImageSource, dbo.Announcements.URL, dbo.Announcements.Description, dbo.Announcements.ViewOrder, dbo.Announcements.PublishDate, dbo.Announcements.ExpireDate, dbo.UrlTracking.TrackClicks, dbo.UrlTracking.NewWindow from dbo.Announcements left outer join dbo.UrlTracking on dbo.Announcements.URL = dbo.UrlTracking.Url and dbo.UrlTracking.ModuleId = @ModuleID where dbo.Announcements.ModuleId = @ModuleId and ( ((dbo.Announcements.PublishDate >= @StartDate) or @StartDate is null) and ((dbo.Announcements.PublishDate <= @EndDate) or @EndDate is null) ) order by dbo.Announcements.ViewOrder asc, dbo.Announcements.PublishDate desc

Although Mitch is correct in theory, this is not a know issue of the Announcement module, and has never been. The announcement module supports all collations that are supported by DNN (in general, DNN does not support case sensitive collations

The issue here is probably just the other way around. Did you by any change migrate your DNN database from another server? If so, chances are that the collation of that other server where different than the collation of your current server. One of the features of SQL Server is that it keeps the original collation for existing objects in the database, but will apply the new server default collation to newly created objects. This error will show itself upon installation of new modules (you would probably have the same issue with a lot of other modules as well). So yes, Mitch was right that this is a know issue..

I wrote a blog about that a long time ago, please read it here: http://www.apollo-software.nl/Blog/tabid/169/EntryID/2/language/en-US/Default.aspx

Leif, the only way you can get this error is collations do not match. The announcement module does not force collations in the scripts, and will use the database default as a result. Hence, the only option is that the collation of the field in the table that is used in the join of the sprocs that error is different than the database default. One option is that you imported the database from another server, the other option is that something or someone changed the database default collation.. or that something or something changed the collation of the fields that are used in the announcements sprocs that are erroring out.

So you need to check a few things.

• check the database default collation. You can see that in the DB properties in management studio, or execute this command on the db:

  SELECT

  DATABASEPROPERTYEX('DotNetNuke', 'Collation');  -- Replace DotNetNuke with the actual name of your database
• From SQL Management Studio, open the Announcements table in design view, and verify that all text fields have the database default collation. Especially check the URL field
• the table causing the troubles is UrlTracking. Verify that the collation of field Url is also set to database default

It is hard to say how collation conflicts like this come about. They are not easy to solve, as you will have to set collation of all fields to the database default. In my blog, i pointed to an article that shows how you can do that with an sql script. That script will set collation of all text fields in your db to the db default. This is the link to that article: http://www.databasejournal.com/scripts/article.php/3494951