Increasing the maximum number of saved page versions

Overview

Currently, DNN limits the number of previous page versions a user can choose to save in their version history to 20. Some users may require more page versions than this to be saved in their database, for example for compliance and auditing reasons. As a workaround, superusers/hosts can run queries so that more versions will be stored, although this will interfere with the functionality of viewing page versions through the UI.

Step-by-Step Guide

Attention: increasing the version count past 20 will not allow you to access newer versions from the version history UI. The versions can be created and will work fine, but you will not be able to manage them through the UI.

1. Log in to your DNN site as a SuperUser/host
   • In versions prior to 9.x, navigate to Host > Advanced Settings > SQL
   • In versions 9.x and above, navigate to Persona Bar > Settings > SQL Console
2. Run one of the following queries:
   • To perform the change for all portals, run the following query. Replace 20 with the number of versions you want to keep.
UPDATE PortalSettings set SettingValue = 20 WHERE SettingName = 'TabVersionsMaxNumber'
   • To change this value for only a single portal, run the following query instead:
     UPDATE PortalSettings set SettingValue = 20 WHERE SettingName = 'TabVersionsMaxNumber' AND PortalID = x
     • Note: Replace X with the actual PortalID, which can be found by running this query:
       SELECT PortalID, PortalName FROM PortalLocalization
     • Note: Replace 20 with the number of versions you want to keep.
3. Clear the cache so that the changes take effect.
   • In versions prior to 9.x, navigate to Tools > Clear Cache
   • In versions 9.x and above, navigate to Persona Bar > Servers > Clear Cache
4. To test whether the solution was successful, generate additional versions of a page until there are more than 20.
5. Navigate to Page History to confirm the solution (see View Page Versions for details). The additional versions should be present in the table on this page.