By Sean Carney on Sunday, 20 November 2016
Posted in General
Replies 3
Likes 0
Views 180
Votes 0
Which Database tables do you store the html of the EasyBlog posts in?

The reason I ask is because my host provides a find and replace tool for the database and I have some strings to change now that I have removed K2 and imported everything into EasyBlog. It is taking FOREVER trying to open the blogs one at a time and find and fix the links that are now broken.

So, I am hoping to be able to do some global replacements, one at a time as I come across the urls.

K2 Component URLs:
Here is an example of a K2 Component URL that I have to change: /component/k2/item/509-dr-carney-speaking-for-plantpure-summit-2016
It needed to be changed to: events/entry/dr-carney-speaking-for-plantpure-summit-2016

Inaccurate strings:
Here is an example of a currently broken URL: /topics/item/321-the-scoop-on-poop
It needs to be changed to: articles/entry/the-scoop-on-poop

Here is another example of a currently broken URL: /topics/item/266-using-diet-to-prevent-colon-polyps
It needs to be changed to articles/entry/using-diet-to-prevent-colon-polyps

However, when I searched for a string in the table drca_easyblog_post I only found two results. I know there are more than that in the database. So, I am figuring there must be some other table?

Thanks for any answers you can give me on this.

Sean Carney
Hello Sean,

I am really sorry for the delay of this reply as it is a weekend for us here. Rather than changing the links, I would strongly suggest that you create a 301 redirect since these are known paths. This is just a sample idea but your web host should have a better idea of how to achieve this.

RedirectMatch 301 ^\/component\/k2\/item\/[0-9]+\-(.*)$ /events/entry/$1
·
Sunday, 20 November 2016 15:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Wow Great idea. Thanks for it. I will present that to them. Although I would also really like to make sure that Google learns all the new paths. Maybe that would just happen over time. But, I also don't like the idea of my EasyBlog posts containing paths to urls that no longer exist. :-)

Regardless, I am going to present your idea to my host and ask for their assistance to know the best way to do that.

And, no need for apologies for slow responding. When I post over the weekend I realize that I might not get an answer for a couple days and that is OK. :-)

Sean
·
Monday, 21 November 2016 11:35
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for understand Sean
·
Tuesday, 22 November 2016 00:52
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post