Phoca Forum

Support for Phoca Extensions
https://www.phoca.cz/forum/

Joomla! 2.5 to 3.x upgrade with Phoca Extensions

https://www.phoca.cz/forum/viewtopic.php?t=25731

Page 3 of 5

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

Posted: 23 Jul 2014, 15:25
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

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

Posted: 23 Jul 2014, 15:37
by woodyf4u
Yes Eddie.
That's correct for Phoca Gallery.

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

Posted: 17 Sep 2014, 18:30
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!

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

Posted: 17 Sep 2014, 22:19
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:

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

Posted: 25 Sep 2014, 10:34
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

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

Posted: 25 Sep 2014, 12:24
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
);

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

Posted: 25 Sep 2014, 16:25
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, '*')

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

Posted: 26 Sep 2014, 00:18
by Jan
Hi, thank you for the guide.

Jan

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

Posted: 03 Oct 2014, 17:22
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:

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

Posted: 13 Oct 2014, 02:35
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]
All times are UTC+02:00
Page 3 of 5

Powered by phpBB® Forum Software © phpBB Limited