Phoca Forum

Hi, this could be some deleted posts, but this should be right. In the guide, there is an sql query which should correct the values.

Jan

These queries?

CREATE TABLE migrate AS
SELECT id,
@rowid:=@rowid+2 AS rowid,
@rowid - 1 AS lftnew,
@rowid AS rgtnew FROM jos_phocaguestbook_items,
(SELECT @rowid:=0) AS init
ORDER BY id;

UPDATE jos_phocaguestbook_items SET lft=(SELECT lftnew FROM migrate WHERE migrate.id = jos_phocaguestbook_items.id);
UPDATE jos_phocaguestbook_items SET rgt=(SELECT rgtnew FROM migrate WHERE migrate.id = jos_phocaguestbook_items.id);


i apply them, but i can apply them again.

Do you mean that i cannot delete any item from the phocaguestbook?

Hi, not sure if I understand correctly? What you mean with "i cannot delete any item" - you can do this in database or in administration :Idea:

Jna

I have the (same) problem.
That is: Registered users can not Post.
Not-registered users (guest) can.
I have a plain install (so no conversions from older releases, just started with 3.4.x).
I run on Joomla 3.4.8
All is updated.

Thanks.

Hi, which error message user gets?