Joomla! 2.5 to 3.x upgrade with Phoca Extensions

Phoca Documentation - creating documentation in Joomla! CMS
eddie_konczal
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 23 Jul 2014, 15:17

Re: Joomla! 2.5 to 3.x upgrade with Phoca Extensions

Post by 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
User avatar
woodyf4u
Phoca Enthusiast
Phoca Enthusiast
Posts: 69
Joined: 10 Jan 2009, 22:20
Location: The Netherlands
Contact:

Re: Joomla! 2.5 to 3.x upgrade with Phoca Extensions

Post by woodyf4u »

Yes Eddie.
That's correct for Phoca Gallery.
nemmar
Phoca Enthusiast
Phoca Enthusiast
Posts: 63
Joined: 13 Mar 2014, 18:55

Re: Joomla! 2.5 to 3.x upgrade with Phoca Extensions

Post by 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!
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47794
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Joomla! 2.5 to 3.x upgrade with Phoca Extensions

Post by 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 :idea:
If you find Phoca extensions useful, please support the project
MAG4
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 17 Jun 2010, 11:17

Re: Joomla! 2.5 to 3.x upgrade with Phoca Extensions

Post by 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
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 17 Jun 2010, 11:17

Re: Joomla! 2.5 to 3.x upgrade with Phoca Extensions

Post by 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
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 17 Jun 2010, 11:17

Re: Joomla! 2.5 to 3.x upgrade with Phoca Extensions

Post by 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, '*')
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47794
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Joomla! 2.5 to 3.x upgrade with Phoca Extensions

Post by Jan »

Hi, thank you for the guide.

Jan
If you find Phoca extensions useful, please support the project
Dimi2014
Phoca Member
Phoca Member
Posts: 20
Joined: 03 Oct 2014, 14:09

Re: Joomla! 2.5 to 3.x upgrade with Phoca Extensions

Post by Dimi2014 »

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

[quote="Jan"]Hi, in phpMyAdmin, just add the whole table into your database:
phidias81
Phoca Enthusiast
Phoca Enthusiast
Posts: 70
Joined: 05 Jan 2012, 01:20
Contact:

Re: Joomla! 2.5 to 3.x upgrade with Phoca Extensions

Post by 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]
Post Reply