Hi,
I upgraded my Joomla from 2.5 to 3.0
My Phocaguestbook was version 2.0.5 Dutch translation
In the new Joomla 3.0 I upgraded the Phocaguestbook with com_phocaguestbook_v3.0.0_beta.zip
Now when I try to reach in the backand the messages, the following error
500 Unknown column 'a.rgt' in 'order clause'
SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,c.title AS category_title, c.title AS guestbook_title, c.id AS guestbook_id FROM `jos_phocaguestbook_items` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_categories AS c ON c.id = a.catid WHERE a.id > 1 AND (a.published IN (0, 1)) ORDER BY a.rgt desc Unknown column 'a.rgt' in 'order clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,c.title AS category_title, c.title AS guestbook_title, c.id AS guestbook_id FROM `jos_phocaguestbook_items` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_categories AS c ON c.id = a.catid WHERE a.id > 1 AND (a.published IN (0, 1)) ORDER BY a.rgt desc LIMIT 0, 100 Unknown column 'a.rgt' in 'order clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,c.title AS category_title, c.title AS guestbook_title, c.id AS guestbook_id FROM `jos_phocaguestbook_items` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_categories AS c ON c.id = a.catid WHERE a.id > 1 AND (a.published IN (0, 1)) ORDER BY a.rgt desc
It looks like I miss a column in a table ?
Can you help me with this?
Thanks for the answer
Greetings from Holland
Theo
Phoca Guestbook upgrade to v3.0.0_beta Error
-
- Phoca Newbie
- Posts: 4
- Joined: 01 Apr 2013, 19:08
- Jan
- Phoca Hero
- Posts: 48227
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Phoca Guestbook upgrade to v3.0.0_beta Error
Hi, unfortunatelly I didn't do a migration from 2.5 to 3.0 so cannot give any clue advices.
Phoca Guestbook 3 now uses the cateogries from Joomla! core, not own table - so this needs to be taken into account.
For the moving of the guestbooks there needs to be special script to migrate guestbooks to Joomla! categories.![Idea :idea:](./images/smilies/icon_idea.gif)
Jan
Phoca Guestbook 3 now uses the cateogries from Joomla! core, not own table - so this needs to be taken into account.
For the moving of the guestbooks there needs to be special script to migrate guestbooks to Joomla! categories.
![Idea :idea:](./images/smilies/icon_idea.gif)
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Newbie
- Posts: 7
- Joined: 29 Aug 2014, 17:34
Re: Phoca Guestbook upgrade to v3.0.0_beta Error
Hi,
i've updated from 2.0.5 to 3.0.2.
The menu-link is now broken because there is no guestbook choosen!?
When i'm going to backend to "guestbook", my guestbook is not there (my only one).
when i create the same guestbook there is on frontend (and also in backend at guestbook-items) a new error because there is missing an column:
j25_phocaguestbook_items has no "parent_id", "lft", "rgt", "level" and "path" but "sid" and "ordering".
How can i repair it?
And why did not changed the update-script the tables?
Best regards,
Stefan
i've updated from 2.0.5 to 3.0.2.
The menu-link is now broken because there is no guestbook choosen!?
When i'm going to backend to "guestbook", my guestbook is not there (my only one).
when i create the same guestbook there is on frontend (and also in backend at guestbook-items) a new error because there is missing an column:
Code: Select all
Unknown column 'a.rgt' in 'order clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,c.title AS category_title, c.title AS guestbook_title, c.id AS guestbook_id FROM `j25_phocaguestbook_items` AS a LEFT JOIN `j25_languages` AS l ON l.lang_code = a.language LEFT JOIN j25_users AS uc ON uc.id=a.checked_out LEFT JOIN j25_categories AS c ON c.id = a.catid WHERE a.id > 1 AND (a.published IN (0, 1)) ORDER BY a.rgt desc LIMIT 0, 20
How can i repair it?
And why did not changed the update-script the tables?
Best regards,
Stefan
- Jan
- Phoca Hero
- Posts: 48227
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Phoca Guestbook upgrade to v3.0.0_beta Error
Hi, see similar posts in this forum.
The udpate script does not work between large Joomla! version like Joomla! 2.5 and 3 is. There the migrate must be done.
See:
viewtopic.php?f=2&t=25723
Jan
The udpate script does not work between large Joomla! version like Joomla! 2.5 and 3 is. There the migrate must be done.
See:
viewtopic.php?f=2&t=25723
Jan
If you find Phoca extensions useful, please support the project
- beptumunchen
- Phoca Newbie
- Posts: 1
- Joined: 27 Apr 2017, 05:22
Re: Phoca Guestbook upgrade to v3.0.0_beta Error
Thank you for sharing