Skip to content

Home

Jump to bottom
Sebastian Leupold edited this page Nov 4, 2017 · 5 revisions

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 any TurboDNN base script)

Data Correction

  • Adjust Content Items - Make sure, necessary content items are created and orphaned items are deleted (will be included in TurboDNN 1.0+) )
  • Adjust Eventlog Types - make sure all types are declared and properly named (will be included in TurboDNN 1.0+)
  • Adjust HostSettings - validates values of system settings to be of appropriate type and in allowed range or value list (will be included in TurboDNN 1.0+)
  • Adjust PortalSettings - validates values of website settings to be of appropriate type and in allowed range or value list (will be 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 (will be included in TurboDNN 1.0+)
  • Adjust Roles - corrects role data and makes sure administrators and registered users roles are properly linked (will be 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 any TurboDNN.sql base script)
  • Fix Duplicate TabUrls - make sure, there are no duplicate URLs for different pages (included in in any TurboDNN.sql base script)
  • Fix PortalSettings - Corrects an upgrade issue with duplicate site settings in DNN 7.3.2 - 7.3.4 (in any TurboDNN.sql base script)
Clone this wiki locally