Register   Login
     
  Latest Posts  
Resouce Files
by IMISOFT on 3/17/2010 5:59 PM
RE: BUG So many 404's with rssbutton.gif
by smcculloch on 3/17/2010 4:30 PM
BUG So many 404's with rssbutton.gif
by greenflash on 3/17/2010 2:45 PM
RE: thumbnails and W3C validation
by greenflash on 3/17/2010 2:38 PM
RE: Dual PA modues on site for different levels of access?
by robax on 3/17/2010 1:38 PM
RE: Where is the NA Latest Article Module setting stored?
by ray-isc on 3/17/2010 1:10 PM
RE: Where is the NA Latest Article Module setting stored?
by Declic Video on 3/17/2010 12:46 PM
RE: News Article Detail and Lightbox
by ray-isc on 3/17/2010 10:57 AM
News Article Detail and Lightbox
by spirit on 3/17/2010 10:09 AM
Gallery Upload control not showing
by rward on 3/17/2010 10:07 AM
  Forums  
Subject: SQL-Script: Does not install....
Prev Next
You are not authorized to post a reply.

Author Messages
Kenneth WilliamsUser is Offline
Registered Users
Ventrian Active Member
Ventrian Active Member
Posts:28

4/25/2005 2:02 AM  

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

Scott McCullochUser is Offline
Administrators
Ventrian Master
Ventrian Master
Posts:17192


4/25/2005 2:17 AM  

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.


Scott McCulloch
Site Administrator
Kenneth WilliamsUser is Offline
Registered Users
Ventrian Active Member
Ventrian Active Member
Posts:28

4/25/2005 2:32 AM  

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

Scott McCullochUser is Offline
Administrators
Ventrian Master
Ventrian Master
Posts:17192


4/25/2005 2:46 AM  

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_


 


Scott McCulloch
Site Administrator
Scott McCullochUser is Offline
Administrators
Ventrian Master
Ventrian Master
Posts:17192


4/25/2005 3:05 AM  
ok - try with the latest release

Scott McCulloch
Site Administrator
Kenneth WilliamsUser is Offline
Registered Users
Ventrian Active Member
Ventrian Active Member
Posts:28

4/25/2005 4:20 AM  

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

Scott McCullochUser is Offline
Administrators
Ventrian Master
Ventrian Master
Posts:17192


4/25/2005 4:26 AM  

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


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


Scott McCulloch
Site Administrator
Scott McCullochUser is Offline
Administrators
Ventrian Master
Ventrian Master
Posts:17192


4/25/2005 4:32 AM  

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 ?


Scott McCulloch
Site Administrator
Kenneth WilliamsUser is Offline
Registered Users
Ventrian Active Member
Ventrian Active Member
Posts:28

4/25/2005 4:37 AM  

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

Scott McCullochUser is Offline
Administrators
Ventrian Master
Ventrian Master
Posts:17192


4/25/2005 4:49 AM  

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

Scott McCulloch
Site Administrator
You are not authorized to post a reply.
Forums > Modules > Private Messages > SQL-Script: Does not install....



ActiveForums 3.7