Events and FAQ modules no longer work after uninstalling Telerik components

Overview

Telerik components were deprecated and fully removed as of DNN Evoq 9.2. If you manually removed those components from your site, you may have also manually removed the Telerik assembly DLLs. This leads to an error when trying to use Telerik assembly modules such as the Events and FAQ module:

Could not load file or assembly 'Telerik.Web.UI' or one of its dependencies.

 

Environment

  • Evoq 9.2+

To fix this problem, you will need:

  • SQL Server access
  • DNN root folder access for your install
  • Access to a SuperUser account

 

Solution

The solution stages should be followed in order. Each may solve the problem, so functionality should be tested after each stage is complete.

 

Stage 1: Re-adding necessary .dll files

The Telerik assembly requires three .dll files to be placed in your <site root>\bin folder. They are:

  • DotNetNuke.Web.Deprecated.dll
  • Telerik.Web.UI.dll
  • Telerik.Web.UI.Skins.dll

You will find copies of these attached to this article. Place these articles in the <site root>\bin folder, then clear your server cache and restart the application.

 

Stage 2: Reinstalling the extensions

If the Stage 1 steps don't fix the problem, or if the .dll files are already present, you can attempt to reinstall the extensions. Note that reinstalling an extension will delete all data from that extension and remove all instances of it from your site(s). The latest versions of the Events and FAQ modules can be found on the releases pages on GitHub. The article Finding the latest versions of pre-installed DNN Evoq modules provides instructions on how to reinstall the modules. It also has instructions on finding, downloading, and reinstalling the correct version of other pre-installed modules for your version of Evoq.

 

Stage 3: Manual SQL removal of tables

In some cases, manual reinstalling of the Events module has run into issues when attempting to recreate the SQL tables and stored procedures used by the module. This happens when the module removal process is aborted or fails before completion. In these cases, the module is not present in the module list because it has been uninstalled. Attempts to reinstall it run into the error:

Failure SQL Execution resulted in following Exceptions: 
System.Data.SqlClient.SqlException (0x80131904):
There is already an object named 'EventsRecurMaster' in the database.

The name of the table or process may be different, but it will always begin with "Events".

NOTE: Create a full SQL backup of your site before attempting these steps. This process will manually remove all data for your Events module.

  1. Ensure that the Events module is absent from PersonaBar > Settings > Extensions > Modules
  2. From SSMS, run the script in the attached file DropEventsTablesAndSPs.sql
  3. There may be errors in the script due to a partial or aborted previous uninstall. These can be ignored.
  4. Reinstall the module using the steps in Stage 2 above.

 

Testing

After each of these fixes, it can be best to clear your server cache and restart the application before testing. If the fix is successful, the Events and FAQ modules should be installable and should not display errors when used on a page.

 

Attachments

Comments

0 comments

Please sign in to leave a comment.