New posts order after migration

[corpus]

Hello, thank for your usefull extensions and sorry for my english
i updated my website to joomla 3 from 2.5
i followed this article
https://www.phoca.cz/phocadownload/50-jo ... o-joomla-3
to migrate phoca guestbook posts
all went ok but when i add a new post is shows it at the end
the order direction option at menu itam is at DESC
i tested it twice

i took a closer look to the database

the first row is the post i added after migration
the second is the post before migration
i think that the lft and rgt should be 693 and 694
but they took the values 2 and 3 from another post!!!
thank you

[Jan]

Hi, did you follow the guide which is set directly for Phoca Guestbook?

When you change it manually in the phpMyAdmin to 693, 694, does it changes anything?

Jan

[corpus]

Jan thanks for your time
i think i fixed it
i' ll try to describe what i did
first of all i deleted all the posts from the j25_phocaguestbook_items table
and then i posted some messages to the guestbook to see how the extension writes them to database

so what i see is tha the rgt value of the ROOT is one plus the rgt value of my last post
i did the migration again and when it finishes the ROOT values was 1 for lft and 2 for rgt for some reason, the same was when i finished all the previous migrations
i Descending ordered the id's of the posts in phpmyadmin and look down the last's post rgt, was 692
i edited the ROOT value and added 693 in rgt
ALL WORKS FINE
i tested it, i added more posts, delete them all fine
if someone can check it and if it is nessesary modify the sql querys

[Jan]

Hi, thank you for the info.

Jan

[jeroenh]

Corpus, thanks for sharing your solution.
I had the same problem.

Jeroen

[Harry352]

Hi Corpus!
Thanks for sharing your solution.
I had the same problem.

Harry