By DeeEmm on Wednesday, 05 June 2019
Posted in General
Likes 0
Views 539
Votes 0
Hi I am updating a customers site with the Post Blog App and need to change existing blog posts to include the correct page / author attribution.

I would prefer to do this via SQL query directly in database as there are many hundreds of posts to change.

I have already identified the source_id & source_type in the _easyblog_post table, and so can get the posts to display on the correct page, however I cannot find where the page attribution information is stored in the database.

This results in the blog posts not being displayed under the page banner, but instead under the authors banner when viewed

Please advise.
Are you referring add those existing blog post to your Easysocial Pages?

If yes, you have to manually update these 2 table from your database :

- #__easyblog_post (source_id and source_type columns)
You have to refer one of the sample data which post associated with Easysocial page.

- #__easyblog_revisions (content column)
You also need to update this revision table as well.
If you edit this revision data content value, inside is included that blog post information like source_id and source_type as well.


By the way, it looks like your subscription has expired and in order for you to continue requesting for support, you will need an active subscription. If you have already renewed, please let us know so that we can correct this for your account.

Thank you for understanding.
·
Wednesday, 05 June 2019 09:06
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Arlex.
·
Wednesday, 05 June 2019 09:09
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome.

Just for your information, I have locked and marked this thread as resolved to avoid confusions in the future. Please start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiries.

Thanks for understanding.
·
Wednesday, 05 June 2019 09:12
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post