View Single Post
  #2 (permalink)  
Old December 19th, 2010, 06:16 AM
taxivantha taxivantha is offline
Registered User
 
Join Date: Dec 2010
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to taxivantha Send a message via Skype™ to taxivantha
Default

In the DotNetNuke forums, I learned from Sebastian Leupold that this is due to a modification, introduced in DNN 05.4

Anyone trying the instructions from your book on DNN 05.4+ will hit this problem. The work-around is easy.

After you unzip the files from the source code in your DesktopModules\WROX.Suggestion\ folder, edit the file 02.00.00.SqlDataProvider file in the wrox folder with a simple text editor.

The last two instructions in the file look like this:
CREATE PROCEDURE {databaseOwner}{objectQualifier}WROX_GetSuggestion ModulesAllTabs

as

declare @SuggestionModuleDefID int
set @SuggestionModuleDefID = (select ModuleDefID from {databaseOwner}{objectQualifier}ModuleDefinitions where FriendlyName='WROX.Suggestion')
select m.ModuleID,
'ModuleTitle' = m.ModuleTitle + ' (' + t.TabName + ')'
from {databaseOwner}{objectQualifier}Modules m inner join
{databaseOwner}{objectQualifier}TabModules tm on m.ModuleID = tm.ModuleID inner join
{databaseOwner}{objectQualifier}Tabs t on tm.TabID=t.TabID
where m.ModuleDefID = @SuggestionModuleDefID
and t.IsDeleted = 0
order by t.TabID, m.ModuleTitle

GO

and the next one:

CREATE PROCEDURE {databaseOwner}{objectQualifier}WROX_GetSuggestion ModulesThisTab

@TabID int

as

declare @SuggestionModuleDefID int
set @SuggestionModuleDefID = (select ModuleDefID from {databaseOwner}{objectQualifier}ModuleDefinitions where FriendlyName='WROX.Suggestion')
select m.ModuleID,
m.ModuleTitle
from {databaseOwner}{objectQualifier}Modules m Inner Join
{databaseOwner}{objectQualifier}TabModules tm on m.ModuleID = tm.ModuleID
where m.ModuleDefID = @SuggestionModuleDefID
and tm.TabID = @TabID
order by ModuleTitle

GO

This code is no longer compatible with DNN 05.4+ and should be replaced with the following code:

CREATE PROCEDURE {databaseOwner}{objectQualifier}WROX_GetSuggestion ModulesAllTabs

as

declare @SuggestionModuleDefID int
set @SuggestionModuleDefID = (select ModuleDefID from {databaseOwner}{objectQualifier}ModuleDefinitions where FriendlyName='WROX.Suggestion')
select m.ModuleID,
'ModuleTitle' = tm.ModuleTitle + ' (' + t.TabName + ')'
from {databaseOwner}{objectQualifier}Modules m inner join
{databaseOwner}{objectQualifier}TabModules tm on m.ModuleID = tm.ModuleID inner join
{databaseOwner}{objectQualifier}Tabs t on tm.TabID=t.TabID
where m.ModuleDefID = @SuggestionModuleDefID
and t.IsDeleted = 0
order by t.TabID, tm.ModuleTitle

GO


CREATE PROCEDURE {databaseOwner}{objectQualifier}WROX_GetSuggestion ModulesThisTab

@TabID int

as

declare @SuggestionModuleDefID int
set @SuggestionModuleDefID = (select ModuleDefID from {databaseOwner}{objectQualifier}ModuleDefinitions where FriendlyName='WROX.Suggestion')
select m.ModuleID,
tm.ModuleTitle
from {databaseOwner}{objectQualifier}Modules m Inner Join
{databaseOwner}{objectQualifier}TabModules tm on m.ModuleID = tm.ModuleID
where m.ModuleDefID = @SuggestionModuleDefID
and tm.TabID = @TabID
order by ModuleTitle

GO

Save the file and continue with the instructions. WROX.Suggestions will from there on work like the book says it should.
Reply With Quote