Page 2 of 2

Re: How to migrate Phoca Guestbook v2.0.7 to v3.0.1

Posted: 12 May 2014, 17:12
by Jan
Hi, thank you very much for the guide.

Jan

Re: How to migrate Phoca Guestbook v2.0.7 to v3.0.1

Posted: 02 Dec 2014, 23:01
by Jan
Hi, thank you again for the guide, I have used it here:
https://www.phoca.cz/documents/50-phoca/ ... o-joomla-3

Thank you, Jan

Re: How to migrate Phoca Guestbook v2.0.7 to v3.0.1

Posted: 11 Dec 2014, 17:33
by carsten888
@was_nun?
thank you very much. You saved me.

This sort of script could be integrated in the install.script.php of the component.

Re: How to migrate Phoca Guestbook v2.0.7 to v3.0.1

Posted: 12 Dec 2014, 09:50
by carsten888
This script needs one more query.

The root-post in the items table should have catid 0, else when you first post, an update script is triggered to insert the row and fatally fails because it already has the same id. guestbook model function checkReference.

So

Code: Select all

UPDATE `YOURPREFIX-VERSION3_phocaguestbook_items` SET `catid` = '0' WHERE `id`=`1`;

Re: How to migrate Phoca Guestbook v2.0.7 to v3.0.1

Posted: 12 Dec 2014, 13:45
by Jan
Hi, yes, you right, thank you very much for this info, the first entry is done by installation of Phoca Guestbook 3 and will be overwritten by migration when setting new catid. So it needs to be set back to zero.

Thank you, I have updated it here:
https://www.phoca.cz/documents/50-phoca/ ... o-joomla-3

Jan