Page 1 of 1

Phoca Guestbook upgrade to v3.0.0_beta Error

Posted: 01 Apr 2013, 19:19
by TheovH
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

Re: Phoca Guestbook upgrade to v3.0.0_beta Error

Posted: 05 Apr 2013, 00:54
by Jan
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:

Jan

Re: Phoca Guestbook upgrade to v3.0.0_beta Error

Posted: 30 Aug 2014, 11:35
by StBk
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:

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 
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

Re: Phoca Guestbook upgrade to v3.0.0_beta Error

Posted: 31 Aug 2014, 22:40
by Jan
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

Re: Phoca Guestbook upgrade to v3.0.0_beta Error

Posted: 27 Apr 2017, 05:24
by beptumunchen
Thank you for sharing