Troubleshooting: Page Remains in Draft Mode

DNN Version: 09.02.00

12/08/2019 • 1 minute to read

Contributors

12/08/2019 • 1 minute to read • Contributors

Symptom

While editing the page, the page remains in draft mode, due to a conflict in changes made by two users.

Possible Cause

Another user made a change that conflicts with your changes.

Solution

Back up the site and the database.
Log into the site as a host/superuser.

Publish the page through SQL.

Go to Persona Bar > Settings > SQL Console.

Run the following SQL script:


DECLARE @PageName VARCHAR(250);

SET @PageName = 'Home';

UPDATE TabVersions
SET IsPublished = 1
WHERE TabID = (
		SELECT TabID
		FROM Tabs
		WHERE TabName LIKE @PageName
		)
	AND IsPublished = 0;

where @PageName is the name of the page you are editing; e.g., 'Home'.

Clear the server cache.
Recycle the application pool to allow the changes to take effect.