Phoca Forum

Hello,

I have a joomla 2.5.28 installation with phocoa guestbook 2.0.7. When I upgrade joomla to 3.6 and then install phocoguestbook 3.0.2 I see a message that my guestbook has been updated. Sounds great.
However if I then try to access the guestbook I only get an error message about a missing SQL table:

phocaguestbook_logging


The existing tables are:

phocoaguestbook_books
phocoaguestbook_items


The complete error message is:
Table 'db330138459.j25be_phocaguestbook_logging' doesn't exist SQL=SELECT COUNT(*) FROM `j25be_phocaguestbook_logging` AS a LEFT JOIN j25be_categories AS c ON c.id = a.catid LEFT JOIN j25be_phocaguestbook_items AS p ON p.id = a.postid Table 'db330138459.j25be_phocaguestbook_logging' doesn't exist SQL=SELECT a.*,c.title AS category_title, c.title AS guestbook_title, c.id AS guestbook_id,p.title, p.username, p.id AS post_id FROM `j25be_phocaguestbook_logging` AS a LEFT JOIN j25be_categories AS c ON c.id = a.catid LEFT JOIN j25be_phocaguestbook_items AS p ON p.id = a.postid ORDER BY id desc LIMIT 0, 20 Table 'db330138459.j25be_phocaguestbook_logging' doesn't exist SQL=SELECT COUNT(*) FROM `j25be_phocaguestbook_logging` AS a LEFT JOIN j25be_categories AS c ON c.id = a.catid LEFT JOIN j25be_phocaguestbook_items AS p ON p.id = a.postid

When I uninstall phocoaguestbook and then reinstall it everything seems to be ok but of course I lost all my guestbook entries.

Any way out?

Hi,

Any way out?

Yes, follow this guide: Phoca Guestbook Migration https://www.phoca.cz/documents/50-phoca/ ... o-joomla-3

Kind regards,
Benno

Thank you very much Benno.

It worked fine.

Rainer