Upgrade 7.7.x -> 8.1 ( Windows Server version )

[tobi]

Hi !
Today I received mail that your new version 8.1 has been released. Is it possible to update my 7.7 installation on Windows Server 2012 R2 or do I have to do a reinstall ?
Can you also please let me know when the new Editors release 3.0 will be available for self hosted windows installation ?

Thank you !

[Dean]

Please note, that the 8.1 version lacks some functionality, including:

• Text editors;
  Two-factor authentication;
  Single Sign-on;
  Public portal;
  Audit Trail
  Backup
  LDAP Settings
  Micro Talk
  Mail Server Administation

To upgrade 7.7.1 you need to install the 8.1 over the existing version.

To upgrade from 7.7.0 you need first to execute the following script:

Code: Select all

CREATE TABLE IF NOT EXISTS `res_cultures` (
  `title` varchar(120) NOT NULL,
  `value` varchar(120) NOT NULL,
  `available` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `res_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fileid` int(11) NOT NULL,
  `title` varchar(120) NOT NULL,
  `cultureTitle` varchar(20) NOT NULL,
  `textValue` text,
  `description` text,
  `timeChanges` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `resourceType` varchar(20) DEFAULT NULL,
  `flag` int(11) NOT NULL DEFAULT '0',
  `link` varchar(120) DEFAULT NULL,
  `authorLogin` varchar(50) NOT NULL DEFAULT 'Console',
  PRIMARY KEY (`fileid`,`title`,`cultureTitle`),
  UNIQUE KEY `id` (`id`),
  KEY `dateIndex` (`timeChanges`),
  KEY `resources_FK2` (`cultureTitle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `res_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `projectName` varchar(50) NOT NULL,
  `moduleName` varchar(50) NOT NULL,
  `resName` varchar(50) NOT NULL,
  `isLock` tinyint(1) NOT NULL DEFAULT '0',
  `lastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index1` (`resName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

And then install the next version.

[Paladin]

That's a lot of deleted functionality. Is there any reason to want to upgrade?

[tobi]

Hi Dean,
thank you for the information. Is a complete release planned including the missing parts you wrote as well as the new Online Editors 3.0 in the (near) future ?

[Dean]

That's a lot of deleted functionality. Is there any reason to want to upgrade?

Yes, if you had any problems with the previous versions and if the deleted functionality is not necessary for you. If you prefer to wait for the editors and other functionality, we will do our best to nclude it in the following version.

Hi Dean,
Is a complete release planned including the missing parts you wrote as well as the new Online Editors 3.0 in the (near) future ?

Yes, both for Windows and Linux. We hope to release it in the begginning of the following year.