Phoca Forum

Dear,
On migration of our site to joomla 3.x I had to migrate the items database and followed this guide: https://www.phoca.cz/documents/50-phoca/ ... o-joomla-3 after installation of phoca guestbook 3.0.2.
During the final queries to order the items there was some kind of hickup, not a very clear error but it looked like query wasn't executed properly. But all items seem to be on date order, so no worries there.
Here is the true issue:
one of the imported items is unpublished(published=0 in database) and is listed accordingly in the admin component message window. But surprise, surprise, it is still visible on the front-end page. Any idea on how this can be fixed?
What I've tried: toggeling published status in the backend and in the database, both only affecting the back-end. Checked admin inlog state for front-end, no difference between logged in or logged out.
Edit1: Same applies for new created items after validation by admin occured. Before first validation message is not published according status on front end, after item status has been changed to published item remains visible on front-end regardless published status.
Just on a side note, what is the meaning of the parent-id, lft, rgt and level columns?
Thanks for any help.

Hi, hmmm, really no idea what can be wrong.

Testing now, getting no such problem - there is just easy check - in database there is published 0|1 and frontend displays only items with published=1

Do you use some template which override components? Maybe something override the component output on your site?

parent_id, lft and rgt are specific rules for building the tree (tree traversal system) When building a tree of categories - you can use recursive function or tree traversal system (and of course other methods) - so parent_id, lft and rgt are just fields which support the tree traversal system which is now used in Joomla! categories system. With help of this columns the tree is build.

Jan