The only way that your posts_default_body could get overwritten with the posts_body (converted to HTML) is if you ran the following chunk of code:
WARNING, do NOT execute the below code, it will make all of your posts HTMLUPDATE ubbt_POSTS
SET POST_DEFAULT_BODY = replace(POST_BODY,'http://EXAMPLE.com','https://EXAMPLE.com')
WARNING, the above MySQL Query is purposfully incorrect as an example, do not EVER execute the above query. While attempting to run:
WARNING, managing the UBB.threads database is not only not recommended, it is not supportedUPDATE ubbt_POSTS
SET POST_DEFAULT_BODY = replace(POST_DEFAULT_BODY,'http://EXAMPLE.com','https://EXAMPLE.com')
WARNING, if you are prepared to manage your database directly, despite warnings, please ensure that you create a backup before executing any queries.
You SHOULD be able to just use the Active Text (text replace) feature in the control panel to change data coming from the database to the browser (such as URLs, linking to affiliate products, etc).