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