Troubleshooting: Page Remains in Draft Mode

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.