Page 1 of 1
Update from RC to RC2
Posted: 18 Feb 2011, 15:08
by dawn_192
Is it possible tu update from RC to RC2 (for example just by installing RC2 over an existing RC) without losing all data or is it possible in general?
I didn't find this anywhere and I'd like to know this before installing it =)
Keep on that great work!
(And I really look forward to the download button plugin)
Re: Update from RC to RC2
Posted: 18 Feb 2011, 15:18
by Benno
Hi,
Is it possible tu update from RC to RC2 (for example just by installing RC2 over an existing RC) without losing all data or is it possible in general?
I didn't find this anywhere and I'd like to know this before installing it =)
Yes, this is possible. Choose the Upgrade Button during the installation process.
If you want to use the new features like e.g. Display File Rating (No, Category View, File View, Category and File View)
you have to create two new tables in your database e.g. with help of phpMyAdmin
Code: Select all
CREATE TABLE `jos_phocadownload_file_votes` (
`id` int(11) NOT NULL auto_increment,
`fileid` int(11) NOT NULL Default 0,
`userid` int(11) NOT NULL Default 0,
`date` datetime NOT NULL Default '0000-00-00 00:00:00',
`rating` 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;
Code: Select all
CREATE TABLE `jos_phocadownload_file_votes_statistics` (
`id` int(11) NOT NULL auto_increment,
`fileid` int(11) NOT NULL Default 0,
`count` int(11) NOT NULL Default '0',
`average` float(8,6) NOT NULL Default '0',
`language` char(7) NOT NULL Default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM Default CHARSET=utf8;
Kind regards,
Benno
Re: Update from RC to RC2
Posted: 19 Feb 2011, 01:12
by Jan
And run these sql scripts too:
Code: Select all
ALTER TABLE `jos_phocadownload` ADD `mirror1link` varchar(255) NOT NULL default '' AFTER `params` ;
ALTER TABLE `jos_phocadownload` ADD `mirror1title` varchar(255) NOT NULL default '' AFTER `params` ;
ALTER TABLE `jos_phocadownload` ADD `mirror1target` varchar(10) NOT NULL default '' AFTER `params` ;
ALTER TABLE `jos_phocadownload` ADD `mirror2link` varchar(255) NOT NULL default '' AFTER `params` ;
ALTER TABLE `jos_phocadownload` ADD `mirror2title` varchar(255) NOT NULL default '' AFTER `params` ;
ALTER TABLE `jos_phocadownload` ADD `mirror2target` varchar(10) NOT NULL default '' AFTER `params` ;
The upgrade function is not fully supported between test versions. It will work full since stable and next versions.
Jan
Re: Update from RC to RC2
Posted: 22 Feb 2011, 13:03
by dawn_192
Thanks, I will try these steps =)