Lft and rgt columns/ importing vis mysql
By philip on Monday, 12 October 2015
Posted in General Issues
Replies 6
Likes 0
Views 681
Votes 0
Hi,

I'm trying to convert Vbulletin Blog to EasyBlog using MYSQL Queries. I've successfully imported the blogs and comments, but I notice the comments are misaligned.

Fyrther investigation show that the misaligned comments are due to the lft and rgt columns in the database, as I had set them up as null.

Question is how can we eliminate hierachies (There are no hierarchies in vb blog comments) or iis there a systematic way to keep the the flat structure?
Hey Philip,

Even though there is no hierarchies, the lft and rgt needs to be set correctly. If you can run a php script to render through each of the comment, you could call the method @updateOrdering from the class /administrator/components/com_easyblog/tables/comment.php

Example code:



$comment = EB::table('Comment');

$comment->load($commentId);



$comment->updateOrdering();
Mark
·
Monday, 12 October 2015 23:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Mark,

Thanks for your quick response. Unfortunately I have little/no knowledge of PHP scripting (otherwise I wont be writing laborious mysql queries to migrate vb Blog), so may I please request a bit of handholding here?

ps - This is the first of many migrations . need to move vbulletin forum to easydiscuss, jomsocial to easy social and disqus to kommento.
philip
·
Tuesday, 13 October 2015 02:46
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Philip,

If you can provide us with the back end and FTP access, I can just write a simple script to update all the comments on the site.
Mark
·
Wednesday, 14 October 2015 14:23
·
0 Likes
·
0 Votes
·
0 Comments
·
hi Philip .. would you be willing to share the sql queries that you used to import the VB blogs into EasyBlog? I am facing similar challenge.
AC
·
Sunday, 11 September 2016 13:35
·
0 Likes
·
0 Votes
·
0 Comments
·
It was a series of manual line by line queries. if you find a cleaner solution, let me know.
philip
·
Monday, 12 September 2016 04:11
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for heading up on this Philip.
Arlex Wong
·
Tuesday, 13 September 2016 10:03
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post