Migrate From 1.5.3 to 2.0.4

[c a g a t a y]

Is there a way to migrate guestbook 1.5.3 items to 2.0.4
I mean I have upgrated my joomla site from 1.5 to 1.7

Regards

[Jan]

Hi, try to see:
https://www.phoca.cz/documents/50-phoca/ ... -joomla-17

Jan

[robkeulers]

Hi Jan, thanks for your great work, what a fantastic piece of software you made, I use it since years!

But now I have a question, I am also updating to 1.7 and now I am following your steps but now I read this:

---You need to set your own database prefix, in examples the jos_ is used but you should use your own database prefix (be aware, it can be different for both sites, in such case you need to overwrite prefix from backed up old site to prefix used on your new site).
Example:
Joomla! 1.5 used jos_ prefix
Joomla! 1.7 (1.6) will use notjos_ prefix
After backuping and before importing sql queries you need to replace all jos_ strings to notjos_ strings in stored backup file. Just open the phocagallery.sql or phocadownload.sql file and replace the prefix by the table names.--

How kan I change these prefix by the table names, I do not not how to open the sql file..

Thanks you.

[Jan]

Hi, in text editor (e.g. notepad++, see notepad++ documentation how to work with find replace function)

Jan

[robkeulers]

Thanks for that!

[minosk]

Hi Jan

There is a mistake in yout migration instructions:

Phoca Guestbook Migration
See guide above, the database tables to export are:
jos_phocaguestbook_books
jos_phocaguestbook_items
There are no files and folders to export/import.

These sql queries should be run after database data import:

UPDATE `jos_phocadownload_books` SET `language` = '*';
UPDATE `jos_phocadownload_items` SET `language` = '*';

It should be jos_phocaguestbook_books and jos_phocaguestbook_items instead:

UPDATE `jos_phocaguestbook_books` SET `language` = '*';
UPDATE `jos_phocaguestbook_items` SET `language` = '*';

[Jan]

Hi, thank you for the info, fixed.

https://www.phoca.cz/documents/50-phoca/ ... -joomla-25

Jan

[carsten888]

I just did this migration of guestbook
https://www.phoca.cz/documents/50-phoca/ ... -joomla-17
(there is no link from the documentation or faqs).

Code: Select all

UPDATE `jos_phocaguestbook_books` SET `language` = '*';
UPDATE `jos_phocaguestbook_items` SET `language` = '*';

but in the 1.5.3-version there is no column 'language'.

so first do

Code: Select all

ALTER TABLE  `sxgp_phocaguestbook_books` ADD  `language` VARCHAR( 7 ) NOT NULL

and

Code: Select all

ALTER TABLE  `sxgp_phocaguestbook_items` ADD  `language` VARCHAR( 7 ) NOT NULL

where sxgp is the prefix of the new version

[carsten888]

and also this:

Code: Select all

ALTER TABLE  `sxgp_phocaguestbook_items` ADD  `alias` VARCHAR( 255 ) NOT NULL

where 'sxgp' is your database pre-fix.

see this post viewtopic.php?f=2&t=19105#p74159