Where does EasyBlog store it's Post Content?
By bitstormweb on Wednesday, 22 July 2015
Posted in General
Replies 6
Likes 0
Views 1.2K
Votes 0
After migrating from Wordpress to EasyBlog, I'm attempting to go in and fix all the old URL links for images, etc... I have written a mySQL query to do the trick, however, I can not seem to find where EasyBlog is storing the content of it's posts. I thought it would be in _easyblog_post, and I see the content stored in there under a field called "intro", but changing this does not affect the live site.

I'm assuming the content is being stored elsewhere?

Charles
Hey bitstormweb,

Yes, correct. The post content will store in #__easyblog_post table under `content` column, but if you got use "read more" in blog post, it will store in `intro` column and `content` columns.
Arlex Wong
·
Thursday, 23 July 2015 00:26
·
0 Likes
·
0 Votes
·
0 Comments
·
Arlex, that is what I would have thought, however, when I check my content field, it's empty.
These posts were automatically brought over by using the Wordpress import, so I'm pretty confused as to where it's actually storing the posts.

Charles
bitstormweb
·
Thursday, 23 July 2015 01:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

Ah, sorry for the confusions. I passed the wrong information to Arlex. If your post contains a "read more", both the "intro" and "content" column would be populated with data.

If your post doesn't contain a read more, only the "intro" column would be populated.
Mark
·
Thursday, 23 July 2015 02:19
·
0 Likes
·
0 Votes
·
0 Comments
·
Ok, yes, it does appear that the "intro" field is working, however, what is strange is that inside Joomla (editing a post) I see different information than what is represented in the database. Is there some sort of cache that needs to be cleared?
bitstormweb
·
Thursday, 23 July 2015 03:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Ah... it's because it's loading out of the "revisions" table
Is there a way to purge all the revisions, or will I also need to do my search/replace there?
bitstormweb
·
Thursday, 23 July 2015 03:45
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

I am sorry for the late reply.

Currently there is no available option to purge the revisions. By the way, I am a little bit lost. Can you please help me understand why you want to purge the revision of the blogpost?

Please update us back on this.
Yasser Ibrahim
·
Thursday, 23 July 2015 10:48
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post