Hello, I recently ran an update script that changed the author of a lot of generic content, and it caused some funny behavior. Now when I go into the Sitefinity administrative section, I see the new author (IMG-Import-Wave1-Locked) on the main screen, but when I click edit, I see the old author (IMG-Import). This is for the same content item. I went in the database and verified that this content item only has one row for Author in the sf_GCMetaData table.
Is there somewhere else this value needs to be changed besides sf_GCMetaData?
The update script I ran is below.
--Update the author where the current author is 'IMG-Import' and the category is 'Purchase'
SET ShortText = 'IMG-Import-Wave1-Locked' --New Author value.
WHERE keyvalue = 'Author'
AND ShortText = 'IMG-Import' --Old Author value.
AND (SELECT TOP 1 1 FROM dbo.sf_GCMetaData G
WHERE G.ContentID = dbo.sf_GCMetaData.ContentID
AND KeyValue = 'Category'
AND ShortText = 'Purchase') = 1 --Category