Change is not published to a shared module

Problem

The user changed a link on a shared module that is displayed as an HTML Pro extension within a page, but the change doesn't seem to be saved as the page still shows the previous content. However, when clicking "Edit page" and hovering over the link, link looks correct.

Diagnostic

By looking at the Change History, it looks like two different users had made changes to the Module by the same time, which created two different versions with the same ID - and the latest version of the module is not appearing as being published.

Solution

In this case, a fix needs to be made directly at the database level.

1. The following query can be used to locate the versions of the module:

SELECT * FROM tabversiondetails WHERE moduleid = <id>

2. This query gathers the module version, against the HTMLText table versions:

SELECT TOP 1 ItemID, ModuleID, [Version], IsPublished 
FROM htmltext WHERE moduleid = ,id> ORDER BY [Version] DESC

3. It finds an unpublished version that should be updated to be published:

UPDATE htmltext SET ispublished = 1 WHERE moduleid = <id> AND version = <version-id>

4. To check that problem is fixed:

• go to Tools > Clear Cache & Recycled the Application Domain
• refresh the page and when the site comes back up, we can see the issue was resolved

Product: DNN HTML Editor 8.2.0