Hi

Having problems using the module, as it says 'dbo.DnnForge_PrivateMessages_GetMessageListByRecipient'  is missing.

Tried to install manually, but there seems to be a collation issue. My DB default is SQL_latin1_general_CP1_CI_AS

Any help would be fine

Kenneth

Hmm, a few questions.

Was it an upgrade or a fresh install?

Are you using an ObjectQualifier?

Is your account a dbo, I am just removing this out of the scripts, btw.

It was an upgrade ( but same problem on fresh install )

No ObjectQualifier

Account is dbo.

Everything else is installed, it only seems to be this one stored procedure.

Maybe I need to change the pms-tables according to my dnn locale (nb-NO)?

Kenneth

I'm just about to post a new release where I went back and fixed some of the earlier scripts so they didn't do checks like,

if exists( select * from dbo.object where etc...

Once posted I'll get you to reinstall and test, can you verify when you uninstall that all objects are deleted, the 3 tables, and the stored procs. They will all be together in DnnForge_PrivateMessages_

It uninstalled fine, but installing your 01.01.01 release, gives same error on install

....@SortDirection = 'DESC' THEN CASE @SortField WHEN 'SenderName' THEN Sender.UserName WHEN 'Subject' THEN dbo.DnnForge_PrivateMessages_Message.Subject WHEN 'DateCreated' THEN convert(varchar,DateCreated, 120) ELSE '' END ELSE null END DESC System.Data.SqlClient.SqlException: Cannot resolve collation conflict for column 14 in SELECT statement. at System.Data.SqlClient.SqlCommand.ExecuteN......

Kenneth

OK - we're getting somewhere now, a collation conflict.

I'll have to do some research and get back to you

Looks like I might need to specify the collation as part of the table creation or query, or maybe it's just the joins of strings.

I'm taking it you don't experience problems with any other modules ?

I always tryout new modules on a demo installation of dnn before deploying it to my other installations.

I must have tried out at least 30 thirdparty modules, and this has not been an issue before.

Kenneth

Hmm, it must be something to do with the following query, I think thats the only one causing problems. I think it's got something to do with the "order by" section.

But you had this working correctly before right? On the same DB?

If the "order by" section is causing problems, I might talk with you via email, and maybe remove that section as a test. (my email is smcculloch@iinet.net.au)

CREATE PROCEDURE {databaseOwner}{objectQualifier}DnnForge_PrivateMessages_GetMessageListByRecipient 
  
 	@PortalId       int,  
 	@UserId		int, 
 	@SortField	nvarchar(50), 
 	@SortDirection	nvarchar(4) 
  
 AS 
  
 SELECT      
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.MessageId,  
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.PortalId,  
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.SenderId,  
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.RecipientId,  
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.Subject,  
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.Message,  
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.MessageRead,  
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.DisableHtmlFormat,  
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.DisableEmoticons,  
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.OriginalMessageId,  
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.DateCreated, 
 	Sender.UserName as SenderName, 
 	Recipient.UserName as RecipientName 
  
 FROM          
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message, {databaseOwner}{objectQualifier}Users Sender, {databaseOwner}{objectQualifier}Users Recipient 
  
 WHERE 
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.SenderId = Sender.UserId 
 	AND 
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.RecipientId = Recipient.UserId 
 	AND	 
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.RecipientId = @UserId 
 	AND 
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.PortalId = @PortalId  
 	AND 
 	{databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.OriginalMessageId is null 
  
 ORDER BY 
 	CASE WHEN ISNULL(@SortDirection, 'ASC') = 'ASC' THEN   
   		CASE @SortField  
 			WHEN 'SenderName' THEN Sender.UserName 
     			WHEN 'Subject' THEN {databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.Subject 
      			WHEN 'DateCreated' THEN convert(varchar,DateCreated, 120) 
      			ELSE '' 
     		END 
 	ELSE null END, 
        	CASE WHEN @SortDirection = 'DESC' THEN  
 		CASE @SortField  
 			WHEN 'SenderName' THEN Sender.UserName 
     			WHEN 'Subject' THEN {databaseOwner}{objectQualifier}DnnForge_PrivateMessages_Message.Subject 
      			WHEN 'DateCreated' THEN convert(varchar,DateCreated, 120) 
      			ELSE '' 
     		END 
 	ELSE null END DESC 
 GO