Can't change content via mysql
By Mark Sevi on Sunday, 19 March 2017
Posted in General
Likes 0
Views 121
Votes 0
I'm missing something or I'm nuts. Either or both are possible.

I go into the db using PHPMyadmin. Change some content in the easyblog_post table. All good. That change does not show up on the website.

I change content via the Easyblog interface. Save. That content shows up in the table.

Why can't I change content directly in the db and have it show up on the site? What am I missing????

I am POSITIVE I am accessing the proper table, the correct post...if I do a search in PHPMyAdmin there's only one article that shows up with that content. No matter what I do to change it in the db it doesn't shw up on the site.

Cleared every cache I can think of multiple times. Talked to my hosting company to make sure they are not delaying the mysql writes in some way or caching anything. The site itself has no caching.

HELP!
Mark
The reason why we stored this in separate table is because every time you save the same post, it will generate a record for your current blog content and stored in this revision table, if we put into the same table, it will not look very clean.

BTW, I looked in the revisions table and couldn't find the correct post. How can I tell which revision is the correct one? None of the dates are close to the one where I modified anything on the post itself.

If you would like to check what is your current revision id for your current blog post, you have to check your #__easyblog_post table under this `revision_id` column, once you know the revision id, then you have to check on #__easyblog_revisions table, all the blog content will stored as JSON string in this `content` column.

Hope this will help.
Arlex Wong
·
Monday, 20 March 2017 11:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Mark,

Which table are you modifying? EasyBlog stores the real content in the revisions table because of the revision history functionality. You can take a look at the table #__easyblog_revisions table. In EasyBlog 5.1, we have simplified this altogether.

By the way, why do you need to modify the contents from the database eh?
Mark
·
Sunday, 19 March 2017 12:46
·
0 Likes
·
0 Votes
·
0 Comments
·
I am intending on changing all the http: to https: and then making them (eventually) relative links. EasyBlog was the only place that gave me an issue. The links need to be changed in the images and doing it post by post is insane. So I installed a plugin called DB Replacer and tried to do it that way. When that worked (but didn't because of EasyBlog's oddness) I looked to see if the db was actually being changed and it was - but the front end didn't reflect those changes.

BTW, I looked in the revisions table and couldn't find the correct post. How can I tell which revision is the correct one? None of the dates are close to the one where I modified anything on the post itself.

What in the world is the reason for having content linked in two table????

Mark

P.S. The credentials I gave you are wrong. If, for some reason, you are going to visit the site as a SuperUser, I need to update those.
Mark Sevi
·
Monday, 20 March 2017 01:50
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you. Now that I understand the situation I can deal with the changes I need to make. Hopefully.

Regards,
Mark
Mark Sevi
·
Monday, 20 March 2017 11:05
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.
Arlex Wong
·
Monday, 20 March 2017 11:18
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post