Move comments from EB to Joomla Articles
By Mist on Tuesday, 03 March 2015
Posted in General Issues
Replies 5
Likes 0
Views 1K
Votes 0
Hi guys, i need a little help from you for the following ...

1. I have migrated all the EasyBlog post over to core Joomla articles system.
2. The item ID is identical (migrated articles have the same ID as in EasyBlog post table)

How can i "switch" the component inside Komento ? Basically i want all the comments to show-up now for Joomla articles instead of EasyBlog. (same articles, same articles id, same title ,,, same everything, just different component)


It's just a matter of "switching" the component in the database ?

Within _komento_comments table , switch the "component" column data from "com_easyblog" to "com_content" ? That's it ?

If yes, can you help me out with a quick phpmyadmin query that will perform this task ?

Thanks in advance !
Hi Mist,

From what I understand, you already have migrated all EasyBlog post into Joomla article. These article has the same/identical ids as in the EasyBlog. Here I give you a sql query to change the component of the comment from com_easyblog to com_content.
Before running this sql code, please make sure you have backup your database if anything goes wrong.



UPDATE `#_komento_comments` 

SET `component` = 'com_content' 

WHERE `component` = 'com_easyblog';


Hope this helps and please update us back.
Yasser Ibrahim
·
Tuesday, 03 March 2015 19:42
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes, all the EasyBlog posts were migrated to Joomla Articles by preserving identical article data (ID, Title .. and so on)

Your sql query Mohd worked flawless ! Thanks a lot !
Mist
·
Tuesday, 03 March 2015 23:55
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for updating Mist, glad that your issues are resolved now
Mark
·
Wednesday, 04 March 2015 00:59
·
0 Likes
·
0 Votes
·
0 Comments
·
hi Mist,

how do you migrated to native Joomla articles from EasyBlog Blogs?
n00bster
·
Wednesday, 04 March 2015 02:29
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello noobster,

I believe what he does is manually migrate the easyblog post from #_easyblog_post into #_content table using the database query
Ezrul Fazwan
·
Wednesday, 04 March 2015 10:39
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post