Hi Brandon,

Yes, this is a result of the path id's not being correct yet in the database in an older version of DMX 4. The easiest way to repair is to run the following script:

DISABLE TRIGGER {databaseOwner}{objectQualifier}DMX_EntryUpdatePath ON {databaseOwner}{objectQualifier}DMX_Entries;
UPDATE {objectQualifier}DMX_Entries
SET Path = NULL
WHERE NOT Path LIKE '0;%';
ENABLE TRIGGER {databaseOwner}{objectQualifier}DMX_EntryUpdatePath ON {databaseOwner}{objectQualifier}DMX_Entries;
GO

EXEC {databaseOwner}{objectQualifier}DMX_UpdatePaths @PortalId
GO

(Where @PortalID is the ID of the portal you're updating)

Peter

So if my portal id is 0 then I would run as Script under HOST/SQL:

DISABLE TRIGGER {databaseOwner}{objectQualifier}DMX_EntryUpdatePath ON {databaseOwner}{objectQualifier}DMX_Entries;
UPDATE {objectQualifier}DMX_Entries
SET Path = NULL
WHERE NOT Path LIKE '0;%';
ENABLE TRIGGER {databaseOwner}{objectQualifier}DMX_EntryUpdatePath ON {databaseOwner}{objectQualifier}DMX_Entries;
GO

EXEC {databaseOwner}{objectQualifier}DMX_UpdatePaths @PortalId = 0
GO

???

Hi Brandon,

Does the 'definition of object 'DMX_EntryUpdatePath' has changed since it was compiled' error persist after a reset of your system? I have seen it once before but it went away.

Peter

Hi Brandon,

I am not sure where the error is produced. I'd have to be able to replicate this. Please contact me by email to continue this.

Peter

OK, I worked on this today and I have found out that the last command (EXEC {databaseOwner}{objectQualifier}DMX_UpdatePaths @PortalId) is what is causing the problem here. For those with faulty breadcrumbs you can do the following:

1. Run the following:

DISABLE TRIGGER {databaseOwner}{objectQualifier}DMX_EntryUpdatePath ON {databaseOwner}{objectQualifier}DMX_Entries;
UPDATE {objectQualifier}DMX_Entries
SET Path = NULL
WHERE NOT Path LIKE '0;%';
ENABLE TRIGGER {databaseOwner}{objectQualifier}DMX_EntryUpdatePath ON {databaseOwner}{objectQualifier}DMX_Entries;
GO

2. Check in the DMX_Entries table in the field Path you only see either NULL or something beginning with '0;'.

3. Edit an entry in your portal OR in SQL, while you have the DMX_Entries table open, edit a record. This should repair all Path fields in the Portal. You can verify this by querying your database on the DMX_Entries table.

4. Verify the reappearance of breadcrumbs.

5. Repeat for all portals in the installation if necessary (check the database)

In the meantime I'll see if I can find a permanent fix to this. It only concerns people with data from older DMX 4 installations. New installs should not experience this problem.

Peter

I have breadcrumbs now.