Phoca Forum

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

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

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

Hi, thank you for the info.

Jan

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

Jeroen

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

Harry