Error FAQ Module Failed to Load

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

I recently updated my FAQ module using version 04.04.00. However following this the module failed to load. Looking on the DotNetNuke website this module version is shown as compatible with DNN 3.3.5 and greater. However, posts on the forum associated with the module are to the effect that this version is for DNN4 only. To recover the FAQ module I did the following:

1. Get the ID of the module (SQL page under host.
   select * from desktopmodules
2. Change the version number to 3.1.1
   update desktopmodules set version = '03.01.01' where desktopmoduleid = 22
   amend the value of 22 above according to the value from 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 zp file.
   I copied and applied each of the stored procedures in turn.
5. There are a number of changes made to the table structure. These are:
   1. add the fields CategoryId, DateModified, ViewCount
   2. add the constraints PK_FAQs and FK_FAQs_Modules
   3. add new table FAQsCategory

Following the above I tested the existing instance of the module by:

• updateing an existing FAQ
• adding new FAQ
• deleting the FAQ i had just added.

No errors were observed in the above. I have chosen to run with the existing database mods. I'll tackle the errors when the version of DNN is updated and the FAQs module is updated.

NAT August 2007