Troubleshooting: Page Remains in Draft Mode

DNN Version: 09.02.00

• 1 minute to read

 • 1 minute to read

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

1. Back up the site and the database.

2. Log into the site as a host/superuser.

3. Publish the page through SQL.

   1. Go to Persona Bar > Settings > SQL Console.

   2. 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'.

4. Clear the server cache.

5. Recycle the application pool to allow the changes to take effect.