Upgrade Joomla 1.5.23 with Phoca Gallery 2.8.0

[Yxos]

I am running newest Joomla version 1.5.23 with Phoca Gallary 2.8.0.

I would like to upgrade to Joomla 1.6, and then 1.7, but I am unsure how to do it, because PG 2.8.0 only runs with J1.5.
For 1.6 and 1.7, PG 3.0.2 is provided by Phoca.

So in what sequence must I do it?
I assume first upgrade from J1.5.23 to J1.6. But then what happens to my gallery with more than 1.500 pictures in it?
It will still "contain" PG 2.8.0, which will probably not run on J1.6. Do I then just upgrade it to PG 3.0.2? Will my pictures be safe then?

Somebody must have tried this before... Or maybe Jan can provide some guidelines ?

[lodestone]

I can shed a bit of light on this, perhaps. I just did something similar to what you are contemplating. I upgraded (migrated, really) from Joomla 1.5.23 to 1.7 directly using an extension called JUpgrade. (You can check it out in the Joomla extensions.) Don't worry; your old site will still be intact. The new 1.7 version is installed automatically in another folder on your site. (This is adjustable in the Parameters.) Your installed extensions don't always survive the process, however; case in point: my Phoca Gallery component (v2.7.5).

I then installed the latest PG 3.0.2.

JUpgrade also keeps all the old database tables when migrating your site. The new tables have a J17_ prefix. (This is also adjustable in the Parameters.) The old ones typically have a jos_ prefix.

Here is where I'm having difficulty, however. Like you, I've a bunch of pics, categories, et al. in the (old) database tables that PG currently can't see. So how do I tell the new Phoca gallery that they are there w/o having to recreate it all from scratch? Perhaps there is an import-type process that isn't too messy. (He suggests, hopefully.)

Hope that helps at least a mite.

--Allen

[Yxos]

Than you for the input Allen...
I am so far in my migration that I backed up my site (of course!); downloaded jUpgrade and plan to go for 1.7 directly like you. Then I would upgrade PG from 2.8.0 to 3.0.2 unless somebody in here would give me a better advice.
Now I am not sure what to do. I can probably, like you, proceed untill I have a 1.7 site with PG 3.0.2 - with no pictures in it...

So, I am also hoping for somebody to help in here. Somebody who actualy managed to upgrade an existing gallery.

[lodestone]

The screwball thing I've recently run into is that if I go to Images > Multiple Add there is a list of my images in their folders from the previous version. However, except for moving around in the folders, I can't do a thing with them, not even view the pics; there appears to be no way to bring them over. So I tried to (re)create some of the categories to see if I needed to do that to make this work. I ran into another problem: I can't even create categories. I get an error: "Save failed with the following error: Category must have title." I addressed this in another forum post but have heard nothing. So I'm stuck with a useless Phoca Gallery 3.0.2.

--Allen

[dnappa]

Hi,
i solved the problem for my installation, before follow my steps please backup phocagallery db table (tipical jos_phocagallery*) and image directory

I install joomla 1.5.23 whit jos_ table prefix and upgrade to joomla 1.7 with j17_ table prefix, these steps work on my configuration if your is different change the table prefix

1) upgrade joomla with JUpdater (I upgrade from 1.5.23 to 1.7)
2) install a fresh copy of phocagallery 3.0.2 (no upgrade)
3) delete all new table of phocagallery 3.0.2 (j17_phocagallery*) except for j17_phocagallery_fb_users
4) run this sql script

Code: Select all

ALTER TABLE `jos_phocagallery`  ADD COLUMN `metadata` TEXT NULL AFTER `metadesc`,  ADD COLUMN `exttype` TINYINT(1) NOT NULL DEFAULT '0' AFTER `extid`,  ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `exth`;
ALTER TABLE `jos_phocagallery_categories` ADD COLUMN `extfbuid` int(11) NOT NULL default '0' AFTER `extauth`,
ADD COLUMN `extfbcatid` varchar(255) NOT NULL default '' AFTER `extfbuid`,
ADD COLUMN `metadata` TEXT NULL AFTER `metadesc`,
ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `metadata`;
ALTER TABLE `jos_phocagallery_comments` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `params`;
ALTER TABLE `jos_phocagallery_img_comments` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `params`;
ALTER TABLE `jos_phocagallery_img_votes` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `params`;
ALTER TABLE `jos_phocagallery_img_votes_statistics` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `average`;
ALTER TABLE `jos_phocagallery_user` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `params`;
ALTER TABLE `jos_phocagallery_votes` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `params`;
ALTER TABLE `jos_phocagallery_votes_statistics` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `average`;

ALTER TABLE `jos_phocagallery` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `exth`;
ALTER TABLE `jos_phocagallery_categories` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `metadata`;
ALTER TABLE `jos_phocagallery_comments` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `params`;
ALTER TABLE `jos_phocagallery_img_comments` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `params`;
ALTER TABLE `jos_phocagallery_img_votes` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `params`;
ALTER TABLE `jos_phocagallery_img_votes_statistics` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `average`;  
ALTER TABLE `jos_phocagallery_user` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `params`;
ALTER TABLE `jos_phocagallery_votes` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `params`;
ALTER TABLE `jos_phocagallery_votes_statistics` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `average`; 

ALTER TABLE `jos_phocagallery`  RENAME TO `j17_phocagallery`;
ALTER TABLE `jos_phocagallery_categories`  RENAME TO `j17_phocagallery_categories`;
ALTER TABLE `jos_phocagallery_comments` RENAME TO `j17_phocagallery_comments` ;
ALTER TABLE `jos_phocagallery_img_comments` RENAME TO `j17_phocagallery_img_comments` ;
ALTER TABLE `jos_phocagallery_img_votes`  RENAME TO `j17_phocagallery_img_votes`;
ALTER TABLE `jos_phocagallery_img_votes_statistics`  RENAME TO `j17_phocagallery_img_votes_statistics`;
ALTER TABLE `jos_phocagallery_user`  RENAME TO `j17_phocagallery_user`;
ALTER TABLE `jos_phocagallery_votes`  RENAME TO `j17_phocagallery_votes`;
ALTER TABLE `jos_phocagallery_votes_statistics`  RENAME TO `j17_phocagallery_votes_statistics`;

Regards
DN

[lodestone]

Greetings,

Thanks for your response.

Because I need to keep my jos_ phocagallery tables at least until I'm ready to move the production site from 1.5 to 1.7, I modified your MySQL code by putting in statements at the top to copy the jos_ tables to new j17_ tables (mine didn't have any to erase so I dropped the RENAME statements) and populate them with the jos_ tables' data. Below is my attempt at the coding:

Code: Select all

    CREATE TABLE `j17_phocagallery` LIKE `jos_phocagallery`;
    create TABLE `j17_phocagallery_categories` LIKE `jos_phocagallery_categories`;
    CREATE TABLE `j17_phocagallery_comments` LIKE `jos_phocagallery_comments`;
    CREATE TABLE `j17_phocagallery_img_comments` LIKE `jos_phocagallery_img_comments`;
    CREATE TABLE `j17_phocagallery_img_votes` LIKE `jos_phocagallery_img_votes`;
    CREATE TABLE `j17_phocagallery_img_votes_statistics` LIKE `jos_phocagallery_img_votes_statistics`;
    CREATE TABLE `j17_phocagallery_user` LIKE `jos_phocagallery_user`;
    CREATE TABLE `j17_phocagallery_votes` LIKE `jos_phocagallery_votes`;
    CREATE TABLE `j17_phocagallery_votes_statistics` LIKE `jos_phocagallery_votes_statistics`;
    CREATE TABLE `j17_phocagallery_fb_users` LIKE `jos_phocagallery_fb_users`;

    INSERT INTO `j17_phocagallery` SELECT * FROM `jos_phocagallery`;
    INSERT INTO `j17_phocagallery_categories`SELECT * FROM `jos_phocagallery_categories`;
    INSERT INTO `j17_phocagallery_comments` SELECT * FROM `jos_phocagallery_comments`;
    INSERT INTO `j17_phocagallery_img_comments` SELECT * FROM `jos_phocagallery_img_comments`;
    INSERT INTO `j17_phocagallery_img_votes` SELECT * FROM `jos_phocagallery_img_votes`;
    INSERT INTO `j17_phocagallery_img_votes_statistics` SELECT * FROM `jos_phocagallery_img_votes_statistics`;
    INSERT INTO `j17_phocagallery_user` SELECT * FROM `jos_phocagallery_user`;
    INSERT INTO `j17_phocagallery_votes` SELECT * FROM `jos_phocagallery_votes`;
    INSERT INTO `j17_phocagallery_votes_statistics` SELECT * FROM `jos_phocagallery_votes_statistics`;
    INSERT INTO `j17_phocagallery_fb_users` SELECT * FROM `jos_phocagallery_fb_users`;

    ALTER TABLE `j17_phocagallery`  ADD COLUMN `metadata` TEXT NULL AFTER `metadesc`,  ADD COLUMN `exttype` TINYINT(1) NOT NULL DEFAULT `0` AFTER `extid`,  ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT `*` AFTER `exth`;
    ALTER TABLE `j17_phocagallery_categories` ADD COLUMN `extfbuid` int(11) NOT NULL default `0` AFTER `extauth`,
    ADD COLUMN `extfbcatid` varchar(255) NOT NULL default `` AFTER `extfbuid`,
    ADD COLUMN `metadata` TEXT NULL AFTER `metadesc`,
    ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT `*` AFTER `metadata`;
    ALTER TABLE `j17_phocagallery_comments` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT `*` AFTER `params`;
    ALTER TABLE `j17_phocagallery_img_comments` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT `*` AFTER `params`;
    ALTER TABLE `j17_phocagallery_img_votes` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT `*` AFTER `params`;
    ALTER TABLE `j17_phocagallery_img_votes_statistics` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT `*` AFTER `average`;
    ALTER TABLE `j17_phocagallery_user` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT `*` AFTER `params`;
    ALTER TABLE `j17_phocagallery_votes` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT `*` AFTER `params`;
    ALTER TABLE `j17_phocagallery_votes_statistics` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT `*` AFTER `average`;

    ALTER TABLE `j17_phocagallery` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT `` AFTER `exth`;
    ALTER TABLE `j17_phocagallery_categories` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT `` AFTER `metadata`;
    ALTER TABLE `j17_phocagallery_comments` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT `` AFTER `params`;
    ALTER TABLE `j17_phocagallery_img_comments` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT `` AFTER `params`;
    ALTER TABLE `j17_phocagallery_img_votes` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT `` AFTER `params`;
    ALTER TABLE `j17_phocagallery_img_votes_statistics` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT `` AFTER `average`; 
    ALTER TABLE `j17_phocagallery_user` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT `` AFTER `params`;
    ALTER TABLE `j17_phocagallery_votes` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT `` AFTER `params`;
    ALTER TABLE `j17_phocagallery_votes_statistics` CHANGE COLUMN `language` `language` CHAR(7) NOT NULL DEFAULT `` AFTER `average`;

However, one of your code lines that I changed from jos_ to j17_ returned the following error:

SQL query:

ALTER TABLE `j17_phocagallery` ADD COLUMN `metadata` TEXT NULL AFTER `metadesc` ,
ADD COLUMN `exttype` TINYINT( 1 ) NOT NULL DEFAULT `0` AFTER `extid` ,
ADD COLUMN `language` CHAR( 7 ) NOT NULL DEFAULT `*` AFTER `exth` ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0` AFTER `extid`, ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT `*` AFTER `ex' at line 1

I know just enough about MySQL to make me very dangerous so I haven't a clue what is wrong. Perhaps you can shed some light on it. I'm running MySQL version 5.1.56.

Thanks,

--Allen

[Yxos]

I am surprized that this kind of amendment is necessary. Doesn't it mean that the Phoca upgrade routine has flaws, and should be corrected?

[lodestone]

I am surprized that this kind of amendment is necessary. Doesn't it mean that the Phoca upgrade routine has flaws, and should be corrected?

Perhaps. Or it could reflect oddities in the manner in which various servers are configured.

Speaking of oddities, for whatever unknown reason, applying the SQL queries that I did--error and all--resulted in my 1.7 install of Phoca Gallery working correctly. Unfortunately, it also resulted in my 1.5 Phoca install breaking. Not what I was after.

C'est la vie.

--Allen

[dnappa]

I am surprized that this kind of amendment is necessary. Doesn't it mean that the Phoca upgrade routine has flaws, and should be corrected?

Hi Yxos,
I think that upgrade routines work only from a 1.6/1.7 joomla compatible previous version and not for 2.8.0

Regards
DN

[Yxos]

I am surprized that this kind of amendment is necessary. Doesn't it mean that the Phoca upgrade routine has flaws, and should be corrected?

Hi Yxos,
I think that upgrade routines work only from a 1.6/1.7 joomla compatible previous version and not for 2.8.0

Regards
DN

If you are correct, then that is the same as to say that no upgrade is provided for sites, upgrading from 1.5.23 with PG 2.8.0.
It would really be nice if Jan could confirm this...