Re: [Quexs-discuss] Migrating from 0.9.6v to 1.0.0v
Web based system for Computer Assisted Telephone Interviewing (CATI)
Brought to you by:
azammitdcarf
|
From: Saulius <zi...@ce...> - 2010-03-13 23:51:56
|
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>>>>>>> |