Page 1 of 1
Migrate From 1.5.3 to 2.0.4
Posted: 09 Jan 2012, 14:33
by 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
Re: Migrate From 1.5.3 to 2.0.4
Posted: 11 Jan 2012, 21:01
by Jan
Re: Migrate From 1.5.3 to 2.0.4
Posted: 11 Jan 2012, 23:45
by 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.
Re: Migrate From 1.5.3 to 2.0.4
Posted: 16 Jan 2012, 18:13
by Jan
Hi, in text editor (e.g. notepad++, see notepad++ documentation how to work with find replace function)
Jan
Re: Migrate From 1.5.3 to 2.0.4
Posted: 01 Feb 2012, 20:00
by robkeulers
Thanks for that!
Re: Migrate From 1.5.3 to 2.0.4
Posted: 03 Feb 2012, 14:14
by 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` = '*';
Re: Migrate From 1.5.3 to 2.0.4
Posted: 04 Feb 2012, 21:39
by Jan
Re: Migrate From 1.5.3 to 2.0.4
Posted: 04 Apr 2012, 15:00
by 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
Re: Migrate From 1.5.3 to 2.0.4
Posted: 05 Apr 2012, 12:04
by 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