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.
|