Other Sections

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.

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