Migration from Joomla 1.5 to 2.5

[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

[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

[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

[Jan]

Hi, in case the new database include other columns, they will be not filled while the migration.

Jan

[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

[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

[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)