Upgrade Joomla 1.5.23 with Phoca Gallery 2.8.0

[pjdevries]

Or unstable Euro's in my case.

[ralaoups]

hi
I try to do a migration between Joomla 1.5 to 1.7 and here is my fast dirty script :
1) do a fresh install with Phoca gallery (com_phocagallery_v3.0.2 )
2 ) delete j17_phocagallery and j17_phocagallery_categories in phpmyadmin
2) execute this code

Code: Select all

CREATE TABLE `j17_phocagallery` LIKE `jos_phocagallery`;
create TABLE `j17_phocagallery_categories` LIKE `jos_phocagallery_categories`;
INSERT INTO `j17_phocagallery` SELECT * FROM `jos_phocagallery`;
 INSERT INTO `j17_phocagallery_categories`SELECT * FROM `jos_phocagallery_categories`;

ALTER TABLE `j17_phocagallery`  ADD COLUMN `metadata` TEXT NULL AFTER `metadesc`;
ALTER TABLE `j17_phocagallery`  ADD COLUMN `userid` int(11) NOT NULL default '0' AFTER `geotitle`;
ALTER TABLE `j17_phocagallery`  ADD COLUMN `exttype` TINYINT(1) NOT NULL DEFAULT '0' AFTER `extid`;
ALTER TABLE `j17_phocagallery` 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`;
ALTER TABLE `j17_phocagallery_categories` ADD COLUMN `extfbcatid` varchar(255) NOT NULL default '' AFTER `extfbuid`;
ALTER TABLE `j17_phocagallery_categories` ADD COLUMN `metadata` TEXT NULL AFTER `metadesc`;
ALTER TABLE `j17_phocagallery_categories`  ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `metadata`;
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`;

I didn't try to migrate comments and other stuff atm but my gallery is ok

[Yxos]

Descriptions are important to me. I put a lot of effort in adding texts to a lot of my around 1.500 pictures.
Apparently you have compared the 2.8.0 gallery to the equivalent 3.0.2 gallery, and then invented the ALTER commands on the fly.
Hopefully Jan will be able to nick your steps in his to-be script, and also add some more, to make a complete migration script including descriptions, comments and stuff

[Yxos]

In order to put a gentle presure on you Jan, I just donated the promised 10$ - in advance
Of course I am aware that you haven't promised to do the script, but maybe my (and other?) donations will encourage you.
Have a nice day !!!

[pjdevries]

I'm prepared to donate even more. Unfortunately, Jan says money is not the issue but time is. So Jan, if we can buy some of your time, please let us know how much it costs. Send me a private message if needed.

[valdez79]

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

Thank you DN,
It works for me, but in the admin page:
phoca gallery -> images

I can't see the thumbnails. I just see the warning message:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/moga/public_html/jupgrade/libraries/joomla/database/database/mysql.php on line 282

everything else is working fine.

Do you have an explanation for the warning above?


i run the sql script (similar to yours)

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`;
    
	
 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`;
   	


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`; 

[ralaoups]

try this code, it's based on the same script, and it fully work now :

Code: Select all

	CREATE TABLE `j17_phocagallery` LIKE `jos_phocagallery`;
	create TABLE `j17_phocagallery_categories` LIKE `jos_phocagallery_categories`;
	INSERT INTO `j17_phocagallery` SELECT * FROM `jos_phocagallery`;
	INSERT INTO `j17_phocagallery_categories`SELECT * FROM `jos_phocagallery_categories`;

	ALTER TABLE `j17_phocagallery`  ADD COLUMN `metadata` TEXT NULL AFTER `metadesc`;
	ALTER TABLE `j17_phocagallery`  ADD COLUMN `userid` int(11) NOT NULL default '0' AFTER `geotitle`;
	ALTER TABLE `j17_phocagallery`  ADD COLUMN `exttype` TINYINT(1) NOT NULL DEFAULT '0' AFTER `extid`;
	ALTER TABLE `j17_phocagallery` 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`;
  	ALTER TABLE `j17_phocagallery_categories` ADD COLUMN `extfbcatid` varchar(255) NOT NULL default '' AFTER `extfbuid`;
	ALTER TABLE `j17_phocagallery_categories` ADD COLUMN `metadata` TEXT NULL AFTER `metadesc`;
	ALTER TABLE `j17_phocagallery_categories`  ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*' AFTER `metadata`;

  	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`;

    
   
        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`;
      
DROP TABLE IF EXISTS `j17_phocagallery_fb_users`;
CREATE TABLE `j17_phocagallery_fb_users` (
  `id` int(11) NOT NULL auto_increment,
  `appid` varchar(255) NOT NULL Default '',
  `appsid` varchar(255) NOT NULL Default '',
  `uid` varchar(255) NOT NULL Default '',
  `name` varchar(255) NOT NULL Default '',
  `link` varchar(255) NOT NULL Default '',
  `secret` varchar(255) NOT NULL Default '',
  `base_domain` varchar(255) NOT NULL Default '',
  `expires` varchar(100) NOT NULL Default '',
  `session_key` text,
  `access_token` text,
  `sig` text,
  `published` tinyint(1) NOT NULL Default '0',
  `checked_out` int(11) unsigned NOT NULL Default '0',
  `checked_out_time` datetime NOT NULL Default '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL Default '0',
  `comments` text,
  `params` text,
  `language` char(7) NOT NULL Default '',
  PRIMARY KEY  (`id`)
) DEFAULT CHARSET=utf8;
;


        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`;
        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_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`;
   

I added this : ALTER TABLE `j17_phocagallery` ADD COLUMN `userid` int(11) NOT NULL default '0' AFTER `geotitle`; to avoid this error.

[Yxos]

3) delete all new table of phocagallery 3.0.2 (j17_phocagallery*) except for j17_phocagallery_fb_users

Would it be possible to include this in your script as well ?

[valdez79]

The SQL query works but If you still need help with migration please send me an PM.

[Jan]

https://www.phoca.cz/documents/50-phoca/ ... -joomla-17

Jan