Where in the database is post HTML stored?

Support
#1

I use a broken link monitor that monitors the post_content column in the WP posts table. However, when browsing that column, it seems that Cornerstone stores content in that column without HTML (for example, a broken link was stored as “View our student catalog here”). If the HTML is not stored in this table, where is it stored?

#2

Interestingly, when creating this post, it appears that it is showing as markup. When I paste the content copied from the database into a code editor or other sites, it is shown as “View our student catalog here”. However, when I paste it into this form, it’s shown as " View our student catalog [here] (https://example.com/wp-content/uploads/2021/12/student-catalog.pdf)". (I added a space between the text and the link to break the markup for this post.)

I guess my question now becomes: how does Cornerstone save content to that column?

#3

Hello Andy,

Thanks for writing in! Cornerstone saves the element contents, styling and other attributes as a post meta or the cornerstone data. When you edit a page/post in the Cornerstone Builder, it will look for the cornerstone data. Once this is corrupt or can’t be found, the builder will display a blank slate. Any editing outside of Cornerstone will not be saved into the Cornerstone data and this is why we only advise to edit your page/post in the builder.

Best Regards.

#4

Hello,

Thank you for the response, but I’d like to clarify: I’m not attempting to edit anything outside of cornerstone, and am not having corruption issues. I am using a link monitor tool that scans the HTML in the post_content column, looks for links, and then monitors if those links are broken or not. However, it seems that it is not finding my site’s links, and I’m working with them and you to find out why. In my research, it seems that it is not storing to this column as HTML, but it might be saving it as markdown.

A) When you say that it saves it as Cornerstone data, how is that saved? Are you referring to the tags in the post_content column, or somewhere else?
B) My understanding is that Cornerstone is saving links to the post_content column in a markdown format. Can you confirm if this is correct, or if it is saving it some other way?

#5

Hi Andy,

Here the Cornerstone data is refer to the content that consists of the shortcode and the content. The Cornerstone data is related to the structure and the attributes stored in the post_meta table too. But the URL is not stored directly to the post_content.

Hope it helps.
Thanks

#6

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.