Overview

dnnScript contains a number of SQL Scripts for DNN Platform (formerly known as DotNetNuke).

Please select appropriate script from the download list on the right hand side of the download page.

TurboDNN Scripts

TurboDNN is a set of scripts, to optimize the database for improved performance and stability. Please read instructions carefully and make sure, to apply the appropriate version only.

Maintenance Scripts

There are a few maintenance tasks, which cannot be (easily) performed from UI. The following scripts are currently provided:

  • Remove all Deleted Users - removes soft-deleted users from the DNN platform, please read here for details.
  • Delete all Register Notifications - deletes all pending admin notifications about new user registrations
  • Take Over Password - installs a stored procedure to take over password from a different user
  • Truncate Eventlog - truncates eventlog, if scheduler cleanup job and UI delete options fail (automatic maintenance for EventLog and Exceptions tables included in TurboDNN)

Data Correction

  • Adjust Content Items - Make sure, necessary content items are created and orphaned items are deleted (included in TurboDNN 1.0)
  • Adjust Eventlog Types - make sure all types are declared and properly named (included in TurboDNN 1.0)
  • Adjust HostSettings - validates values of system settings to be of appropriate type and in allowed range or value list (included in TurboDNN 1.0)
  • Adjust PortalSettings - validates values of website settings to be of appropriate type and in allowed range or value list (included in TurboDNN 1.0)
  • Adjust Tab Settings  - validates values of page settings to be of appropriate type and in allowed range or value list (included in TurboDNN 1.0)
  • Adjust Roles - corrects role data and makes sure administrators and registered users roles are properly linked (included in TurboDNN 1.0)
  • Adjust Permissions - make sure, necessary page, module and folder permissions are granted and unnecessary or dangerous permissions are removed (included in TurboDNN)
  • Fix Duplicate TabUrls - make sure, there are no duplicate URLs for different pages (included in TurboDNN)
  • Fix PortalSettings - Corrects an upgrade issue with duplicate site settings in DNN 7.3.2 - 7.3.4 (included in TurboDNN)

Last edited Oct 4, 2015 at 1:33 PM by leupold, version 22