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: 48428
- 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.
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.
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: 48428
- 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