Upgrade 1.5 to 2.5 Joomla

Phoca Gallery - image gallery extension
diego.matos
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 22 Aug 2012, 21:15

Upgrade 1.5 to 2.5 Joomla

Post by diego.matos »

Hello.

I did upgrade joomla 1.5.26 to 2.5 and installed Phoca Gallery Component 3.2.1, but in version 1.5.26 I had the Phoca Gallery installed with many galleries, after upgrade and the installation the version 3.2.1, my galleries disappeared.
How can I import my galleries from joomla 1.5.26 to 2.5?
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9974
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Upgrade 1.5 to 2.5 Joomla

Post by Benno »

dpottier
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 28 Jun 2011, 07:33

Re: Upgrade 1.5 to 2.5 Joomla

Post by dpottier »

Exported tables from 1.5
Imported to 2.5 dBase
Installed Phocagallery v3.2.2 then UPGRADE

ERROR 1:
Phoca Gallery not successfully upgraded:
Error while updating Fanpageid column in Phoca Gallery FB Users table
ERROR 2: received after above steps
When injecting - UPDATE `j25_phocagallery` SET `language` = '*'; etc
Returns
#1054 - Unknown column 'language' in 'field list'
Accessing USERS returns
Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,
FACEBOOK, COMMENTS and other selections return similar errors

Suggestions?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49150
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Upgrade 1.5 to 2.5 Joomla

Post by Jan »

Hi, see the install.sql.bak file and compare it to your database.

The language column needs to be set in phocagallery table
and the fanpageid into phocagallery_fb_users

Jan
If you find Phoca extensions useful, please support the project
Post Reply