Hi,
I am using Umbraco 7.2.0 and I need to perform a bulk update on a large number of content items. There is an external URL hard-coded in html content across hundreds of pages (nodes) and this URL needs to be replaced with an alternative.
I have written a SQL script to perform the changes to the database and applied the change to the cmsContentXml table with success. I deleted the App_Data/umbraco.config file, then I restarted the App Pool for the website and reloaded the site. The umbraco.config file was regenerated and the database changes were applied to the config file.
If I load a webpage of where the changes were applied, the change is visible on the front-end, therefore the change has worked and is visible on the website.
However when I login to the backoffice, the changes have not been applied there. The content is the same in the backoffice as it was before the changes. I have also tried clearing out my browser cache but nothing changes.
Therefore if a content editor publishes a page, the changes I made to the database and the umbraco.config file are overridden with the content from the backoffice, putting me back where I started.
Is there an ‘in-memory’ cache that needs to be cleared? If so, how can I do this?
Note that this is happening in the Richtext editor. Is this a TinyMCE caching problem?
Where am I going wrong here?
With thanks,
Nathan
This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/71633-bulk-content-updates-not-appearing-in-backoffice