Phoca Forum

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

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

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

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

Thank you for sharing