When the rector wants a page hit counter on the home page, he will get his hit counter. I think a hit counter is amateuristic and has no other function than to boost the ego of the owner. But the rector pays for the thing, so a page counter is what he will get.

I started out by going through the WROX.Suggestions module, but I ran in some problem there: The module did not install: there was a problem with the installation of the database.  I then continued installing the database manually with the script found in 02.00.00.SqlDataProvider. This failed as well. Executing the script step by step,I located two stored procedures that ran into an error: WROX_GetSuggestionModulesAllTabs and WROX_GetSuggestionModulesThisTab.

Having a closer look at those stored procedures showed me this:
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

This suggests that ModuleTitle is a field in the table m (dbo.Modules). This table does not have such a field. In fact, the field ModuleTitle belongs to the table tm (dbo.TabModules). The same error occurs in the WROX_GetSuggestionModulesThisTab procedure.

Changing m.ModuleTitle into tm.ModuleTitle in 3 occurrences in the last two procedures makes the module install and run perfectly.

I've done a search through this forum for WROX.Suggestion. It seems I'm not the first one to use this module to learn module creation but no posting mentions this error. Which makes me wonder. Would this error be there with a purpose? It is a good excercise in debugging.

Today, I'm going to test the StarterKit for module creation.

---

____________________________________
The one-eyed in the land of the blind.

For anyone following the same book to learn module development after me on DNN 05.4+, here is the answer.

After downloading the source files and extracting them (from 438701 code-final.zip) on their proper locations, go through the 02.00.00.SqlDataProvider file in the DesktopModules\WROX.Suggestion\ folder with a text editor and apply the modifications in my original posting, i.e. replace 3 times 'm' with 'tm'.

Then follow the instructions from the book.

---

____________________________________
The one-eyed in the land of the blind.