Error FAQ Module Failed to Load

Updating the DotNetNuke FAQ module to version 04.04.00 the module failed to load, reporting the error

 Error: FAQs is currently unavailable. The full reported error is given below: Error: FAQs is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Could not load type 'DotNetNuke.Modules.FAQs.FAQs'. ---> System.Web.HttpParseException: Could not load type 'DotNetNuke.Modules.FAQs.FAQs'. ---> System.Exception: Could not load type 'DotNetNuke.Modules.FAQs.FAQs'. ---> System.Exception: Could not load type 'DotNetNuke.Modules.FAQs.FAQs'. ---> System.Web.HttpException: Could not load type 'DotNetNuke.Modules.FAQs.FAQs'. at System.Web.UI.TemplateParser.GetType(String typeName, Boolean ignoreCase, Boolean throwOnError) at...

Originally shown as compatible with DotNetNuke version 3.3.5 and greater. Posts on the forum associated with the module reveal that the module is for DNN 4 only.

To recover the FAQ module the version of the module is changed and the SQL code from the module zip package re-applied.

  1. Get the ID of the module
    On the Host/SQL page enter the following and click on Run Script, ensure that Run as Script: is unchecked.
    select desktopmoduleid, friendlyname from desktopmodules where friendlyname = ‘FAQs’ desktopmoduleid friendlyname version 85 FAQs 03.01.00
  2. On the same SQL page change the version number of the module to 3.1.1
    update desktopmodules set version = ‘03.01.01’ where desktopmoduleid = 85
    In the above amend the value of 85 according to the value derived in step 1 above.
  3. Install the FAQs_3.1_Install.zip version of the module
  4. Re-apply the SQL code from the file 03.01.00.SqlDataProvider in the zip file. I prefer to appy each of the stored procedures in turn. Taking them one by one from the SQL file. this lets me assess the results for each one.
  5. The table structure has been changed. changes made are:
    1. The fields CategoryId, DateModified, ViewCount added
    2. Addition of the constraints PK_FAQs and FK_FAQs_Modules
    3. Addition of the table FAQsCategory

To check that the changes made to the FAQs module have been applied correctly test the module by:

  • add a new FAQ
  • delete the FAQ just added
  • update an existing FAQ