Editing web part data in the database

Ryan Anthoney asked on October 2, 2019 11:42

Hi there,

For reasons too long to explain I need to update, or rather, replace some content in the database. Specifically, update a series of URL's on a LinkButton web part across a series of pages.

I can update in SQL, the DocumentWebParts of the relevant Document in the CMS.Documents table. This works for the content on the page. However, if I then investigate the page WITHIN the CMS. The old data remains, meaning the changes get overwritten again when the page is published.

I suspect there is something possibly to do with the VersionHistory table but is there any where else this data is retrieved from?

Thanks in advance, Luke

Correct Answer

Dmitry Bastron answered on October 2, 2019 13:10

Yes, I think these might be the steps:

Disable the workflow and publish to the latest version of the page
Ppdate it via SQL
Restart the website
Check and enable workflow again

0 votesVote for this answer Unmark Correct answer

Recent Answers

Dmitry Bastron answered on October 2, 2019 12:36

Hi Ryan,

Do you have workflow enabled somewhere? If no, just updating CMS_Document table should be enough.

Also, did you restart the website after performing update in SQL? I experienced the same due to Kentico cache and restart of the website helped in this case.

0 votesVote for this answer Mark as a Correct answer

Ryan Anthoney answered on October 2, 2019 12:47

Hi Dmitry,

Yes we do have workflow enabled, would you recommend disabling this for the update perhaps? I figured it might be cache related, but I cleared the cache and restarted to application which didn't seem to work.

I hadn't thought about workflow though so I'll look in to this.

Thanks,

Luke

0 votesVote for this answer Mark as a Correct answer

charles wales answered on October 3, 2019 07:37

i read something that may help you

https://digitalworldcopy.blogspot.com/2019/07/easy-diy-web-design-tips.html

0 votesVote for this answer Mark as a Correct answer

Dmitry Bastron answered on October 3, 2019 09:58

Also, there is another thing to check. Are you changing Widgets (Page tab) or Web Parts (Design tab)? If it is design, it's all stored in CMS_PageTemplate table instead, column PageTemplateWebParts. So, that should be modified then.

0 votesVote for this answer Mark as a Correct answer

Ryan Anthoney answered on October 3, 2019 10:54

Thanks Dmitry,

It's widgets within the page tab so think that should be fine.

Thanks again for your help,

Luke

0 votesVote for this answer Mark as a Correct answer