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
Post orders and only registered users
- Jan
- Phoca Hero
- Posts: 48403
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Post orders and only registered users
If you find Phoca extensions useful, please support the project
-
- Phoca Enthusiast
- Posts: 69
- Joined: 16 Apr 2011, 22:21
Re: Post orders and only registered users
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?
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?
- Jan
- Phoca Hero
- Posts: 48403
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Post orders and only registered users
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
Jna
If you find Phoca extensions useful, please support the project
-
- Phoca Newbie
- Posts: 3
- Joined: 19 Nov 2015, 09:27
Re: Post orders and only registered users
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.
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.
- Jan
- Phoca Hero
- Posts: 48403
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Post orders and only registered users
Hi, which error message user gets?
If you find Phoca extensions useful, please support the project