Joomla! 2.5 to 3.x upgrade with Phoca Extensions

[eddie_konczal]

woodyf4u, thanks for posting these directions. I am preparing to upgrade Phoca Gallery on a site I will be upgrading from Joomla! 2.5 to 3.x.

Just to clarify, in your post above from 09 May 2014, 11:36 , is it correct to say the URL in your directions should actually be:

https://www.phoca.cz/documents/2-phoca-g ... em-solving

Thanks,
Eddie

[woodyf4u]

Yes Eddie.
That's correct for Phoca Gallery.

[nemmar]

Hi,

I just upgraded from J2.5x to J3.3.3.
I followed the instructions in this post to upgrade my Phoca Gallery with the following ZIP files:
com_phocagallery_v4.1.1.zip
com_pi_pg3.zip
mod_phocagallery_image_v4.0.0.zip
mod_phocagallery_menu_v4.1.0.zip
mod_phocagallery_tree_v4.0.2.zip

I had to use PHPMyAdmin to add one missing table: x_phocagallery_styles

1) I'm not sure how to check to make sure all the correct/new columns are added to all the database tables. Do I need to check ALL my _phocagallery_ tables in the site database to determine if they have all the columns needed after the upgrade? If yes, then what's the best way to do that (is there a list of the columns)?



Thanks!

[Jan]

Hi, in phpMyAdmin, just add the whole table into your database:

Code: Select all

CREATE TABLE IF NOT EXISTS `#__phocagallery_styles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `filename` varchar(255) NOT NULL DEFAULT '',
  `menulink` text,
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `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',
  `params` text,
  `language` char(7) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 ;

INSERT INTO `#__phocagallery_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
(1, 'Phocagallery', 'phocagallery', 'phocagallery.css', '', 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(2, 'Rating', '', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
(3, 'Default', '', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 3, NULL, '*'),
(4, 'Bootstrap', '', 'bootstrap.min.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 4, NULL, '*');

But this should be added by installation of Phoca Gallery 4

[MAG4]

Hi, we have just migrated from Joomla 2.5.24 to 3.3.3. We have also successfully migrated Phoca Download from 2.1.9 to 3.0.5 and Phoca Gallery from 3.2.8 to 4.1.1 following this steps:
- disabled all Phoca extensions (components, modules, plugins) before Joomla migration
- migrated all Phoca extensions (components, modules, plugins) after Joomla migration
- executed the SQL attached in the next messages in phpMyAdmin to migrate Phoca Download tables:
- executed the SQL attached in the next messages in phpMyAdmin to migrate Phoca Gallery tables:
- disabled Bootstrap style in Phoca Download and Gallery (because the template is already loading Bootstrap CSS)
- enabled all Phoca extensions (components, modules, plugins)
Hoping that will be useful for others ...
Regards!

Guido

[MAG4]

To migrate Phoca Download tables from 2.1.9 to 3.0.5 (first part):

Code: Select all

ALTER TABLE `jm4_phocadownload` CHANGE `approved` `approved` TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `jm4_phocadownload` ADD `token` CHAR( 64 ) NULL DEFAULT NULL AFTER `unaccessible_file`;
ALTER TABLE `jm4_phocadownload` ADD `tokenhits` INT( 11 ) NOT NULL DEFAULT '0' AFTER `token`;
INSERT INTO `jm4_phocadownload_layout` (
`id` ,
`categories` ,
`category` ,
`file` ,
`checked_out` ,
`checked_out_time` ,
`params`
)
VALUES (
NULL , '<div class="pd-categoriesbox">
<div class="pd-title">{pdtitle}</div>
{pdsubcategories}
{pdclear}
</div>',
'<div class="pd-filebox">
{pdfiledesctop}
{pdfile}
<div class="pd-buttons">{pdbuttondownload}</div>
<div class="pd-buttons">{pdbuttondetails}</div>
<div class="pd-buttons">{pdbuttonpreview}</div>
<div class="pd-buttons">{pdbuttonplay}</div>
<div class="pd-mirrors">{pdmirrorlink2} {pdmirrorlink1}</div>
<div class="pd-rating">{pdrating}</div>
<div class="pd-tags">{pdtags}</div>
{pdfiledescbottom}
<div class="pd-cb"></div>
</div>'
, '<div class="pd-filebox">
{pdimage}
{pdfile}
{pdfilesize}
{pdversion}
{pdlicense}
{pdauthor}
{pdauthoremail}
{pdfiledate}
{pddownloads}
{pddescription}
{pdfeatures}
{pdchangelog}
{pdnotes}
<div class="pd-mirrors">{pdmirrorlink2} {pdmirrorlink1}</div>
<div class="pd-report">{pdreportlink}</div>
<div class="pd-rating">{pdrating}</div>
<div class="pd-tags">{pdtags}</div>
<div class="pd-cb"></div>
</div>' , '0', '0000-00-00 00:00:00', NULL
);

[MAG4]

To migrate Phoca Download tables from 2.1.9 to 3.0.5 (second part):

Code: Select all

CREATE TABLE IF NOT EXISTS `jm4_phocadownload_logging` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `fileid` int(11) NOT NULL default '0',
  `catid` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `ip` varchar(20) NOT NULL default '',
  `page` varchar(255) NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `jm4_phocadownload_styles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `filename` varchar(255) NOT NULL DEFAULT '',
  `menulink` text,
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `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',
  `params` text,
  `language` char(7) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `jm4_phocadownload_tags` CHANGE `link_cat` `link_cat` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `jm4_phocadownload_tags_ref` DROP INDEX `id`

To migrate Phoca Gallery tables from 3.2.8 to 4.1.1:

Code: Select all

ALTER TABLE `jm4_phocagallery` ADD `format` TINYINT( 1 ) NULL DEFAULT '0' AFTER `filename`;
CREATE TABLE IF NOT EXISTS `jm4_phocagallery_styles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `filename` varchar(255) NOT NULL DEFAULT '',
  `menulink` text,
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `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',
  `params` text,
  `language` char(7) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
INSERT INTO `jm4_phocagallery_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
(1, 'Phocagallery', 'phocagallery', 'phocagallery.css', '', 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(2, 'Rating', '', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
(3, 'Default', '', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 3, NULL, '*'),
(4, 'Bootstrap', '', 'bootstrap.min.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 4, NULL, '*')

[Jan]

Hi, thank you for the guide.

Jan

[Dimi2014]

This was the issue for me too. Once I did this, voila.

[quote="Jan"]Hi, in phpMyAdmin, just add the whole table into your database:

[phidias81]

It worked for me. For newbie with database like me, just log in in Phpmyadmin, copy this text in a text editor, replace all the table prefix (jm4) with yours, copy the text, go on phpmyadmin, click on "SQL", paste the text on the field and click "go". Done.

To migrate Phoca Gallery tables from 3.2.8 to 4.1.1:

Code: Select all

ALTER TABLE `jm4_phocagallery` ADD `format` TINYINT( 1 ) NULL DEFAULT '0' AFTER `filename`;
CREATE TABLE IF NOT EXISTS `jm4_phocagallery_styles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `filename` varchar(255) NOT NULL DEFAULT '',
  `menulink` text,
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `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',
  `params` text,
  `language` char(7) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
INSERT INTO `jm4_phocagallery_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
(1, 'Phocagallery', 'phocagallery', 'phocagallery.css', '', 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(2, 'Rating', '', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
(3, 'Default', '', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 3, NULL, '*'),
(4, 'Bootstrap', '', 'bootstrap.min.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 4, NULL, '*')

[/quote]