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

[Adam Z. <ada...@ac...>]

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 collate
utf8_unicode_ci NOT NULL;
ALTER TABLE `questionnaire` MODIFY `rs_project_intro` text collate
utf8_unicode_ci NOT NULL;
ALTER TABLE `questionnaire` MODIFY `rs_project_end` text collate
utf8_unicode_ci NOT NULL;
ALTER TABLE `questionnaire` MODIFY `rs_callback` text collate
utf8_unicode_ci NOT NULL;
ALTER TABLE `questionnaire` MODIFY `rs_answeringmachine` text collate
utf8_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 existing
queXS install.

Then browse to:

quexs/include/limesurvey/admin/install/index.php

to update the limesurvey database

This should do it.

Please let me know how you go.

Regards,
Adam Zammit




On 26 February 2010 09:37, Saulius <zi...@ce...> 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
>
>
>
>
>
>
>