We have a situation where we would like to have a custom Visual Studio AddOn we created to be able to add a new entry into an HTML Module on a specified page. We wrote the SQL code to identify the module and such. But every attempt to either add a new entry, or even to modify the content of the last (current) entry...results in the changes not being in "published" mode. The changes are visible when editing the page, but in view mode they are not visible. We have to edit the page, then edit the HTML module (like adding and removing a space) just so that a change is registered. Only then will a "Publish" button appear, then we click publish to make the changes appear on the page publicly.

We want to avoid all those extra steps. There must be other records somewhere that we are unaware of that completes the "publish" process on another table somewhere, but we cannot find it. Can anyone shed some light on this?

We have tried two different methods:

1. Adding a new entry using the DNN stored procedure AddHtmlText
2. Modifying the currently published entry directly within the table: HtmlText

Both methods result in "unpublished" content, regardless of the published state of the records added/modified.

Thank you for any assistance.

-Ben

I thought about that, and I did in one of my iterations also use the stored procedure AddHtmlTextLog, but that didn't effect the process. This module is "Direct to Publish", so I am not sure if workflow affects it at all.

The strange thing is that if I edit the existing (currently published) record directly...meaning I only update the Content field, not touching any other fields such as published or created date or last modified date, one would expect that the changes would be immediately visible. But that is not the case, even doing a Cache flush doesn't fix it. The only thing that fixes it is editing the modules content, making a change, then clicking publish. The publish button doesn't even appear at first because DNN doesn't register that any changes were made. That's why we have to edit the module's content, like adding and removing a single space, so that it triggers the "change" and the publish button appears.