MVC Admin Pages Module Doesn't Recognize Database Change

kentico guy asked on May 11, 2023 17:11

MVC Kentico 13 - Admin Control Panel I had to run a SQL query to update an entire column of a page type that had a change. The change is working in terms of pulling the correct value but oddly the content tab of the pages module for that page type still shows the old value. It's weird because when I run the live site, it's pulling the value from the database, but the field on the content tab still shows the old value.

I remember this used to happen in K12 portal engine but with K12 I was able to fix it by restarting the application. Now, it seems like that value is cached somewhere and I'm not sure where. How can I force Kentico pages module to pull the actual value from the database?

mvc kentico13 admin

Recent Answers

Brenden Kehren answered on May 11, 2023 21:43

This is most likely due to Workflow and/or Versioning being enabled. When you have either of those enabled, directly updating page data with a SQL statement will not update the version, only the page type data.

Your best bet is to create custom code (scheduled task) to execute this and use workflow and versioning to check the pages in and out and publish them. The second option is to take all those pages in workflow and remove them from workflow, then manually run the update, then add them all back in workflow again.

1 votesVote for this answer Mark as a Correct answer