Update from RC to RC2

[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)

[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

[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

[dawn_192]

Thanks, I will try these steps =)