Page 1 of 1
Migration from Joomla 1.5 to 2.5
Posted: 27 Jun 2012, 13:20
by motorama
Hi there,
I have a Joomla 1.5 with Phoca Gallery 2.8.1 running.
I migrated Joomla to 2.5.
Now I want to migrate Phoca Gallery also. Therefore I Installed a fresh 3.2.0
Version within the new Joomla 2.5 Installation.
After that I dumped the P. Gallery Files in Joomla 1.5 (only Data) mysql and tried to import
it to my new database. Unfortunately the import fails thus there are new fields.
(F.E. 'extfbcatid' or 'extauth' in phocagallery_categories) in the fresh installation.
Is there a migration script which I can run before my dump to fix this missing fields in my old installtion?
Thanks for help,
toni
Re: Migration from Joomla 1.5 to 2.5
Posted: 27 Jun 2012, 17:33
by Benno
Hi,
Is there a migration script which I can run before my dump to fix this missing fields in my old installtion?
No, but you can use this guide for migration:
https://www.phoca.cz/documents/50-phoca/ ... -joomla-25
Kind regards,
Benno
Re: Migration from Joomla 1.5 to 2.5
Posted: 27 Jun 2012, 18:08
by motorama
Hi Benno,
thanks for your reply.
I tried this docu. Same problem. I can ´t import the data of the old Phoca galery because
as written the numbers of fields do not match. The new Version uses fields (extauth, ...)
which the old database structure don´t has.
regards,
toni
Re: Migration from Joomla 1.5 to 2.5
Posted: 27 Jun 2012, 19:53
by Jan
Hi, in case the new database include other columns, they will be not filled while the migration.
Jan
Re: Migration from Joomla 1.5 to 2.5
Posted: 02 Jul 2012, 11:25
by motorama
Hi Jan & Benno,
thanks for your help. Took some days of this is why my return is a bit delayed.
Jan, unfortunately this is not working for me. Because the new Phoca Galery tables
have more Columns as the old version. The import fails with following mysql error:
Code: Select all
SQL-Befehl:
--
-- Datenbank: 'test'
--
--
-- Daten für Tabelle 'jos_phocagallery'
--
INSERT INTO jos_phocagallery
VALUES ( 114, 1, 0, 'IMG_1997', 'img1997', '2009-test/IMG_1997.jpg', NULL , '2010-08-16 14:51:21', 174, '', '', 0, '', NULL , 0, 91612, 1, 1, 0, '0000-00-00 00:00:00', 57, NULL , NULL , NULL , NULL , NULL , '', '', '', '', '', '', '' ) ;
MySQL meldet:
#1136 - Column count doesn't match value count at row 1
It´s working if I alter the old tables with the missing colums but this is a really laborious job.
f.e.
Code: Select all
ALTER TABLE `jos_phocagallery`
ADD `userid` int(11) NOT NULL DEFAULT '0'
AFTER `geotitle`
thankful for any tip.
regards,
Toni
Re: Migration from Joomla 1.5 to 2.5
Posted: 02 Dec 2012, 12:16
by jstratos
Right! I'm having the same exact issues and as far as I can see, the only way is to add the missing tables and that's laborious? Does anyone have a better soluton?
Code: Select all
-- Dumping data for table `j25_phocagallery`
--
INSERT INTO `j25_phocagallery`
VALUES ( 1, 1, 0, 'After The Race', 'after-the-race', 'memorial_day_race/p1000812.jpg', '<p>People smiling together after the race!<br mce_bogus="1"></p>', '2010-12-21 05:28:03', 764, '', '', 0, '', 0, '', 0, 49175, 1, 1, 0, '0000-00-00 00:00:00', 1, NULL , '', '', '', '', '', '', '', '', '', '', '' ) ;
MySQL said:
#1136 - Column count doesn't match value count at row 1
Jim
Re: Migration from Joomla 1.5 to 2.5
Posted: 08 Dec 2012, 00:13
by Jan
Hi, just read the guide, there is no column less in new version, this means, you just import the data (there will be no problem becasue old data includes less columns than in new version and it cannot happen that column will not match)