Forum  Discussions  Page Last Updat...  Issue with object qualifiers
Previous Previous
 
Next Disabled
New Post 7/19/2011 11:03 AM
User is offline chris lively
3 posts
No Ranking


Issue with object qualifiers 

I see in the other post that you have something that fixes the problem with object qualifiers.

One of my clients, Kappa Dallas Alumni, recently purchased your module and I installed it into their DNN 5.2 installation.  Of course, we, like a lot of people, use the dnn_ qualifier.

We're getting an error.  Do you have a real fix for this or can you provide the hotfix for the assembly? 

 

Thanks,

 
New Post 7/19/2011 11:09 AM
User is offline chris lively
3 posts
No Ranking


Re: Issue with object qualifiers 

Alternatively, if you let me know the table names you are going after I can create some views in the database.

 
New Post 7/19/2011 11:33 AM
User is offline chris lively
3 posts
No Ranking


Re: Issue with object qualifiers 

Never mind.  I went ahead and monitored the queries coming in and added some views to handle this.

The ones I added are:


CREATE VIEW [dbo].[Links]
AS
SELECT     CreatedDate, ModuleID
FROM         dbo.dnn_Links

GO

CREATE VIEW [dbo].[HtmlText]
AS
SELECT     ModuleID, ItemID, [Content], Version, StateID, IsPublished, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate
FROM         dbo.dnn_HtmlText

GO

CREATE VIEW [dbo].[Modules]
AS
SELECT     ModuleID, IsDeleted
FROM         dbo.dnn_Modules

GO

CREATE VIEW [dbo].[TabModules]
AS
SELECT     ModuleID, TabID
FROM         dbo.dnn_TabModules

GO
 

 
Previous Previous
 
Next Disabled
  Forum  Discussions  Page Last Updat...  Issue with object qualifiers
Terms Of Use|Copyright 2006 by Digital Snap Inc. |Privacy Statement