Post orders and only registered users

Phoca Guestbook - creating guestbooks in Joomla! CMS
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48403
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Post orders and only registered users

Post by Jan »

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
If you find Phoca extensions useful, please support the project
borja
Phoca Enthusiast
Phoca Enthusiast
Posts: 69
Joined: 16 Apr 2011, 22:21

Re: Post orders and only registered users

Post by borja »

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?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48403
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Post orders and only registered users

Post by Jan »

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
If you find Phoca extensions useful, please support the project
PeterBoll
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 19 Nov 2015, 09:27

Re: Post orders and only registered users

Post by PeterBoll »

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.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48403
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Post orders and only registered users

Post by Jan »

Hi, which error message user gets?
If you find Phoca extensions useful, please support the project
Post Reply