Page 3 of 4
Re: Upgrade Joomla 1.5.23 with Phoca Gallery 2.8.0
Posted: 21 Sep 2011, 09:02
by pjdevries
Or unstable Euro's in my case.
Re: Upgrade Joomla 1.5.23 with Phoca Gallery 2.8.0
Posted: 21 Sep 2011, 17:09
by 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
Re: Upgrade Joomla 1.5.23 with Phoca Gallery 2.8.0
Posted: 21 Sep 2011, 20:22
by 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
Re: Upgrade Joomla 1.5.23 with Phoca Gallery 2.8.0
Posted: 24 Sep 2011, 17:18
by 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 !!!
Re: Upgrade Joomla 1.5.23 with Phoca Gallery 2.8.0
Posted: 25 Sep 2011, 12:24
by 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.
Re: Upgrade Joomla 1.5.23 with Phoca Gallery 2.8.0
Posted: 25 Sep 2011, 20:41
by valdez79
dnappa wrote: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`;
Re: Upgrade Joomla 1.5.23 with Phoca Gallery 2.8.0
Posted: 25 Sep 2011, 21:01
by 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.
Re: Upgrade Joomla 1.5.23 with Phoca Gallery 2.8.0
Posted: 25 Sep 2011, 21:42
by Yxos
dnappes wrote:
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 ?
Re: Upgrade Joomla 1.5.23 with Phoca Gallery 2.8.0
Posted: 30 Sep 2011, 01:52
by valdez79
The SQL query works but If you still need help with migration please send me an PM.
Re: Upgrade Joomla 1.5.23 with Phoca Gallery 2.8.0
Posted: 22 Oct 2011, 00:29
by Jan