Re: [Quexs-discuss] Migrating from 0.9.6v to 1.0.0v

[Saulius <zi...@ce...>]

Thank you Adam. I will let you know how I'm getting on with migration later.

Regards,
Saulius


Nuo:  "Adam Zammit" 
Siųsta:  2010 03 11   04:57
Tema:  Re: Migrating from 0.9.6v to 1.0.0v


Dear Saulius,First, of course, backup your queXS database.There is a change to the database tables, but it can be updated in place.Here is the SQL to update the database:INSERT INTO `outcome` VALUES(32, '4.80', 'Quota filled', 0, 4, 0, 1,0, 0, 0, '');CREATE TABLE IF NOT EXISTS `questionnaire_sample_quota_row_exclude` (  `questionnaire_sample_quota_row_id` bigint(20) NOT NULL,  `questionnaire_id` bigint(20) NOT NULL,  `sample_id` bigint(20) NOT NULL,  PRIMARY KEY  (`questionnaire_sample_quota_row_id`,`questionnaire_id`,`sample_id`),  KEY `questionnaire_id` (`questionnaire_id`),  KEY `sample_id` (`sample_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;ALTER TABLE `operator`
ADD COLUMN `voip` tinyint(1) NOT NULL default '1';ALTER TABLE `questionnaire_sample_quota_row` ADD COLUMN `description`text collate utf8_unicode_ci NOT NULL;ALTER TABLE `questionnaire` MODIFY `rs_intro` text collateutf8_unicode_ci NOT NULL;ALTER TABLE `questionnaire` MODIFY `rs_project_intro` text collateutf8_unicode_ci NOT NULL;ALTER TABLE `questionnaire` MODIFY `rs_project_end` text collateutf8_unicode_ci NOT NULL;ALTER TABLE `questionnaire` MODIFY `rs_callback` text collateutf8_unicode_ci NOT NULL;ALTER TABLE `questionnaire` MODIFY `rs_answeringmachine` text collateutf8_unicode_ci NOT NULL;Then I would create a new installation directory for queXS 1.0.0,pointing to the existing
database.Then create the config.inc.local.php with settings from your existingqueXS install.Then browse to:quexs/include/limesurvey/admin/install/index.phpto update the limesurvey databaseThis should do it.Please let me know how you go.Regards,Adam ZammitOn 26 February 2010 09:37, Saulius  wrote:> Hello,>> We have done one project using Quexs 0.9.6 version and now are considering migrating it to version 1.0.0. I would like to know  whether you have any suggestions how  to migrate the project in a best controlled way .>> I have checked the database table structure and it seems that it stayed the same comparing 0.9.6 version to 1.0.0. I think the biggest challenge will be moving LimeSurvey
questionnaire onto a new version.>> I would appreciate for any insight.>> Regards,> Saulius>>>>>>>