It appears that only the 05.01.00.SqlDataProvider script creates or alters the foreign key relationship betweeen the HtmlTextLog and HtmlText tables. The way the script is constructed, rerunning it will not re-create the FK relationship if the HtmlTextLog table already exists.

I would take a look at the database to see if

1. HtmlTextLog table exists. If not, you may want to try rerunning the scripts.
2. There is a FK relationship between HtmlText table (primary key table) and HtmlTextLog table (foreign key table) on the ItemID field with on cascade delete enabled. If not, I would rerun the portion of the 05.01.00.SqlDataProvider script that creates this FK relationship:


ALTER TABLE {databaseOwner}{objectQualifier}HtmlTextLog WITH NOCHECK ADD CONSTRAINT
      FK_{objectQualifier}HtmlTextLog_{objectQualifier}HtmlText FOREIGN KEY
      (
       ItemID) REFERENCES {databaseOwner}{objectQualifier}HtmlText
      (
       ItemID) ON UPDATE NO ACTION
                     ON DELETE CASCADE
                     NOT FOR REPLICATION

I would, however, also be concerned that the two other statements which set up the FK relationships between HtmlTextLog and WorkflowStates tables and between the HtmlTextUsers and HtmlText tables might not have run as they are in the same GO block.

Regarding the issue occuring in a new module instance on the 6th and following version revisions, the module retains a default of 5 maximum versions. It would not be until the 6th and following revisions that an attempt would be made to delete the oldest version each time a new version is created. Although the module code can retrieve it's maximum number of versions to retain from the portal settings, it does not appear that there is any user interface for setting a different value - hence the defaut of 5 is always used.

It also appears that the FK constraint error is preventing any version from being deleted from the HtmlText and HtmlTextLog tables as the module instance first having problems contains 18 versions.

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner