Turbo Scripts 0.9.9 for DNN 7.1.2 - 9.1.1

Rating:        Based on 6 ratings
Reviewed:  5 reviews
Downloads: 2142
Released: Nov 13, 2017
Updated: Nov 13, 2017 by leupold
Dev status: Stable Help Icon

Recommended Download

Application TurboDNN099z2.zip
application, 202K, uploaded Nov 13 - 2142 downloads

Release Notes

Due to Codeplex shutting down, dnnTurbo scripts are forced moving to Github. Latest version should be available here. We apologize for any inconvenience.

  • Incorporate new procedures for adding and moving pages (tabs), which are more reliable regarding TabOrder
  • Support for DNN 7.4.2 (meanwhile up to DNN 8.0.3)
  • Handle falsely passed -1 instead of Null for Users.AffiliateId and Journal.ContentItemId
  • Fix an issue in Function UserProfileGranted, affecting Membership directory in user profile (friends list) //2015-08-31

*Note: Code has been added for compatibility with DNN 8, however it has not been tested yet. Please do not apply TurboDNN to production sites running DNN 8 or upgrade your sites using TurboDNN to DNN 8, before tests have been finished (2016-01-15).

  • 2015-09-05 Rev. a
    • Fix Stored Procedure GetDuplicateEmailCount
  • 2015-09-07 Rev. b
    • AzureSQL Compatibility (Azure SQL V12 or later)
    • AdjustDNNEventLogTypes script added
    • Backported and optimized fix DNN-7405 for procedure GetTabPaths
    • Backported and optimized fix DNN-7410 for procedure GetSchedule
  • 2015-09-25 Rev. c
    • Optimized GetSchedule and GetNextMessageForDispatch (DNN 7.1.x only)
    • Added and Improved Query Hints for most select statements
  • 2015-10-08 Rev. d
    • Ensure, all constraints are enabled (just in case)
    • fixed GetVendor procedure
    • improve view vw_Users
  • 2015-10-09 Rev. e
    • fix a typo in GetVendor procedure
  • 2015-10-11 Rev. f
    • improve procedure SearchProfilePropertyValues
  • 2015-10-15 Rev. g
    • Fixed an issue in view vw_UserProfileLookup (TurboDNN and TurboUnSchema)
    • Fixed an issue in GetFoldersByPermissions, preventing non-Admins to upload to granted folders
    • Added Package validation/completion for Dashboard Controls
  • 2015-10-21 Rev. h
    • Fix an issue in AddTabAtPos when appending new top level pages
    • Ensure, each required virtual Role is created
    • Drop a disabled constraint from Active Forums
    • Improved AdjustDNNPortalSettings742.sql
    • Added package validation/completion for Skins, Containers and Skin Controls
  • 2015-10-22 Rev. i
    • Added support for host menu pages to AddTab.. and MoveTab .. procedures
  • 2015-10-26 Rev. k
    • Fixed an issue of procedure AddTabAtPos
    • Added UpdateTab procedure, supporting cross-portal moves
    • Make sure, sp_msforeachtable is executed only, if not running on MS Azure
    • Optimized UpdateUser procedure
  • 2015-10-26 Rev. l
    • Improve indexes on Packages table
  • 2015-10-27 Rev. m
    • fixed a typo in check for a FK of ActiveForums module
  • 2015-12-21 Rev. o
    • improved and fixed procedure GetDuplicateEmailCount
    • Include HasChildTab for DNN 7.1.x
  • 2016-01-11 Rev. p
    • Fix an issue in CoreMessaging_SaveMessage procedure
    • Add support for host pages in GetModules procedure
    • Improve Journal_UpdateContentItemId to prevent errors
    • Fix a permission issue in Journal_Get
    • Included Function JournalUserPermissions, because EasyDNN uses it, bypassing DNN API
    • Optimize procedure GetSchedule using new indexed view vwScheduleNextStart (TurboSchema only)
    • Optimize procedure CoreMessagingGetToasts using new indexed view vwCoreMessaging_ToastMessages (TurboSchema only)
    • Optimized CoreMessaging indexed views and procedures for performance
    • Initial Support for DNN 8.0.0
  • 2016-01-16 Rev. q
    • fixed name prefix issues
  • 2016-02-10 Rev. r
    • Fix issue with CoreMessaging_SubscriptionTypes index
    • Improve Indexes on OutputCache Table (DNN 8.0.0)
    • CoreMessaging_CreateMessageRecipientsForRole prevents duplicates and takes outdated role membership into account
    • Support TabVersions in GetModulePackagesInUse and GetTabsByPackageID (for DNN 7.4.0 and above)
    • Fix a bug in PurgeScheduleHistory procedure
    • Tune procedure CoreMessaging_CountNotifications (TurboSchema only)
    • Tune procedures CoreMessagingGetNextMessagesForDigestDispatch and CoreMessagingGetNextMessagesForInstantDispatch
    • Tune performance of procedures GetSharedModulesByPortal and GetSharedModulesWithPortal (TurboSchema only)
    • Tune ModulePermission and TabPermission views and procedures using it
    • Note: Member count for roles does not check for expiry date (for performance reasons)
  • 2016-02-10 Rev. s
    • fix an issue with module permission view
  • 2016-02-29 Rev. t
    • Improved sys_CreateForeignKey
    • Fix issues with CoreMessagingEmailFrequency, CoreMessagingSaveMessageRecipient
    • Improve GetUsersByRoleName to return actively assigned members only
  • 2016-03-18 Rev, u
    • Support DNN 8.0.1
    • Include Host pages in GetTabModuleSettingsByName, GetTabModuleIdsBySettingNameAndValue
    • Improve Performance of function Journal_PermittedJournalIDs (by removing a nested subquery)
  • 2016-04-17 Rev. v
    • Improve procedure DeletePortalAlias
    • Fix an issue in Function FitsExtendedPropertyPermission
    • Improve Journal_save procedure to support updates
  • 2016-05-04 Rev. w
    • Support for DNN 8.0.2
    • Improved support for former core modules
    • Improved Journal_save to support YAF.Net
  • 2016-05-31 Rev. x
    • Support for DNN 8.0.3
    • Improve PurgeEventLog to include all events of disabled log types
    • Fix a Schemabinding issue in TurboUnschema
    • Fix missing DbO and OQ (2016-06-26 reuploaded)
*2016-07-18 Rev. y
  • Improved integrity checks and correction
  • disabled Media module support due to issues with earlier versions of the module
*2016-08-26 Rev. z
  • support for DNN Platform 8.0.4
  • Remove duplicate entries in Files table (FolderID & FileName)
  • Fix a Journal issue showing up in YAF.Net for DNN module
  • Fix User Count of site users (excluding superusers) and multiple listed superusers, if they possess userprofile records
  • Fix an issue with renamed class names for Dashboard module controls
  • Remove duplicate userprofile records
  • Check for optionally installed admin modules (vendors & banners, Sitelog)
  • Profile filter (used in Member directory with advanced filter/search) now uses an exact match for string instead of any value starting with the sequence (use % or * as wildcard)
2017-11-13 Rev. z2
  • Added Support for DNN 9.1.1
  • Improve join in vw_users
  • Drop duplicate index users_LowerEmail and unused calculated column users.LowerEmail
  • added filtered index PasswordResetToken on users table
  • Fixed issses with non-default db owner (SQL schema)

Reviews for this release

Once again, I executed the scripts withOUT a single error, and another super boost to the performance of my DNN portal UPDATE: All the issues that were raised, have been solved with TurboDNN099h UPDATE2: I tried TurboDNN099s on DNN CE ver 8.0.0 and it was executed without a single error! UPDATE3: I executed the script on DNN CE 08.00.01 version it was flawless! Many thanks!
by salem on Mar 17, 2016 at 7:04 AM
After applying scripts on the site. YAF module was in trouble. The problem appears when I enter a post on the YAF forum. How do we solve this problem? Error Msg: Message:The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Journal_Security_Journal". The conflict occurred in database "Portal_DB", table "dbo.Journal", column 'JournalId'. The MERGE statement conflicted with the FOREIGN KEY constraint "FK_Journal_Data_Journal". The conflict occurred in database "Portal_DB", table "dbo.Journal", column 'JournalId'. The statement has been terminated. The statement has been terminated.
by soheil_kheiri on May 3, 2016 at 7:29 AM
Please use issues or discussions page for problems with the script. in this case, there seem to be a problem of the YAF.net module not using the journal procedures properly. I provided you with a workaround, which will be included in next version of TurboDNN. PS: I worked together with Ingo and we solved the issue with Yaf.Net in latest version of my script. Please download latest version and try again. Thank you.
Reply by leupold (N/A) on Oct 16, 2016 at 6:09 PM
It cleared all my x-hundreds event logs. Very fine. However, I noticed that I could have done that also with my Backup Module (Evotiva DNNBackup), which has the possibility to truncate Event Log and Site Log files. Turbo Script was running well and fast, however, now I have the problem that my Extension Link has disappeared and I get a very large error message: AbsoluteURL:/Default.aspx DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke ExceptionGUID:c11e2b23-33d4-4d70-b805-b7da6b5fe023 AssemblyVersion:7.4.2 PortalId:0 UserId:1 TabId:45 RawUrl:/de-ch/admin/extensions.aspx Referrer:http://localhost:35353/de-ch/admin.aspx UserAgent:Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko ExceptionHash:AFXvguN5DOKbmyHr/G/Y5A== Message:Ungültiger Objektname 'TabVersions'. StackTrace: InnerMessage:Ungültiger Objektname 'TabVersions'. InnerStackTrace: bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) bei System.Data.SqlClient.TdsPa
by rblanc on Apr 8, 2016 at 4:21 PM
Please check your database for the existence of table "TabVersions". if the table is missing, the upgrade to DNN 7.4.0 did you apply correctly. please check upgrade log files in /providers/dataproviders/sqldataprovider folder.
Reply by leupold (N/A) on Apr 10, 2016 at 10:23 PM
Flawless. Thanks for the script.
by tmahmud on Jan 21, 2016 at 8:14 PM
hi I run all scripts TurboDNN099m but my Extensions page dos not Work!! please Help. ===================================== RawUrl:/Host/Extensions/portalid/0 Referrer:http://localhost:2000/Default.aspx?tabid=36&error=A+severe+error+occurred+on+the+current+command.++The+results%2c+if+any%2c+should+be+discarded.%0d%0aA+severe+error+occurred+on+the+current+command.++The+results%2c+if+any%2c+should+be+discarded.&content=0 UserAgent:Mozilla/5.0 (Windows NT 6.1; rv:40.0) Gecko/20100101 Firefox/40.0 ExceptionHash:0QPc+KQufQfSOeqFo5uPVA== Message:A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded. StackTrace: InnerMessage:A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded. InnerStackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at
by mansourn on Jan 3, 2016 at 7:09 PM
We haven been able to identify this being an issue of the installation, not related to TurboDNN. Maybe you want to revise your rating?
Reply by leupold (N/A) on Jan 10, 2016 at 1:33 PM