Phoca Guestbook upgrade to v3.0.0_beta Error

TheovH
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 01 Apr 2013, 19:08

Phoca Guestbook upgrade to v3.0.0_beta Error

Post 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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47794
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Phoca Guestbook upgrade to v3.0.0_beta Error

Post 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
If you find Phoca extensions useful, please support the project
StBk
Phoca Newbie
Phoca Newbie
Posts: 7
Joined: 29 Aug 2014, 17:34

Re: Phoca Guestbook upgrade to v3.0.0_beta Error

Post 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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47794
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Phoca Guestbook upgrade to v3.0.0_beta Error

Post 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
If you find Phoca extensions useful, please support the project
User avatar
beptumunchen
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 27 Apr 2017, 05:22

Re: Phoca Guestbook upgrade to v3.0.0_beta Error

Post by beptumunchen »

Thank you for sharing
Post Reply