Hello Justin,

The lft and rgt, first comment should be 1 and 2 first post, 2 and 3 second post, and goes on. If the first comments is 1 and 4 and the second comments is 2 and 3 then the second is taken as child. Can you please provide us with the Joomla back end access as well as the FTP access so that I can check on the issues on your site? We actually need these information so that we can debug on your issues quickly.

Thanks:)

There is nothing wrong with the backend or file system so you don't need login info. As I said, I did this via PHPmyadmin manually.

I have changed each comment within that post to follow your order ie.
1 & 2,
2 & 3,
3 & 4,
4 & 5,
5 & 6,
6 & 7

However, the first comment is showing as a parent with ALL comments aligned as first level children of that post. So ordering them the way you said didn't work. Please advise. ALL comments again are supposed to be at the root level.

Hello Justin,

I am not too sure what is going on there but it does seem like all of the comments are made to reply to the first comment. Can you please provide us with the back end and phpmyadmin access so that I can take a look at the data?

Here ya go

Hi Justin,

Regarding the lft and rgt value for the comments in EasyBlog, I am so sorry for the confusion. The correct value for lft and rgt column should be as below:

1 & 2 -> parent comment A,

3 & 4 -> parent comment B,

5 & 6 -> parent comment C,

7 & 8 -> parent comment D,

and goes on.

If say you have comments replied ( child comment ) to a comment ( parent comment ), then the lft and rgt should be as follow:

1 & 6      - parent comment A

   2 & 3, - child comment to A

   4 & 5, - child comment to A

7 & 8, - parent comment B

9 & 10 - parent comment C

and goes on.

Anyway, I tried to access to your phpmyadmin but it required the access to your cpanel. Do you think you can send me your cpanel access?
Please advise.

Hope this help and have a nice day

Ok so I got the first one done with this system. So to clarify any parent comment must have a number range wide enough in it to encompass all the number ranges of the children within it? That makes it REALLY hard to manage if a single parent has 80 child comments under it and some of those are parents as well.

I don't understand why you guys don't just use the parent_ID column to sort comments. Just associate an <UL><LI> for each comment that has a parent_ID associated with it. That makes things tab over for each new child without needing to mess with a number system...

Hello Justin,

Using a parent_id will cause lots of performance issues especially when there are nested level of comments. Considering that the comments supports n-level of nested comments, it's going to use a nasty nested loop that would drain out CPU cycles. In short, this nested set model is more optimized than having a conventional adjency parent column. In fact, Joomla uses the same nested model too.