View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
05904 | Bug reports | Installation | public | 2012-03-13 16:16 | 2012-04-05 19:15 |
Reporter | Assigned To | c_schmitz | |||
Priority | urgent | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.92+ | ||||
Fixed in Version | 2.00b1 | ||||
Summary | 05904: Database upgrade fails with errors | ||||
Description | Upgrading from 1.90 to 1.92 with a postgresql database as backend fails with the errors below : La base de données de LimeSurvey est en train d'être mise à jour (2012-03-13 15:33:58) .Veuillez patienter ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Commande SQL en échec : CREATE TABLE lime_participant_attribute_names_lang ( id integer NOT NULL AUTO_INCREMENT, attribute_id integer NOT NULL, attribute_name VARCHAR( 30 ) NOT NULL, lang CHAR( 20 ) NOT NULL, PRIMARY KEY (lang,attribute_id) ) Raison : ERROR: syntax error at or near "AUTO_INCREMENT" LINE 2: id integer NOT NULL AUTO_INCREMENT, ^ Commande SQL en échec : CREATE TABLE lime_participant_attribute_values ( attribute_id integer NOT NULL, value_id integer NOT NULL AUTO_INCREMENT, value VARCHAR( 20 ) NOT NULL, PRIMARY KEY (value_id) ) Raison : ERROR: syntax error at or near "AUTO_INCREMENT" LINE 3: value_id integer NOT NULL AUTO_INCREMENT, ^ Commande SQL en échec : CREATE TABLE lime_participant_shares ( participant_id VARCHAR( 50 ) NOT NULL, shared_uid integer NOT NULL, date_added date NOT NULL, can_edit VARCHAR( 5 ) NOT NULL, PRIMARY KEY (lang,attribute_id) ) Raison : ERROR: column "lang" named in key does not exist LINE 6: PRIMARY KEY (lang,attribute_id) ^ Mise à jour de la base de données terminée (2012-03-13 15:34:18) La base de données a été mise à jour avec succès vers la version 155 | ||||
Steps To Reproduce | Upgrade from 1.90 to 1.92. | ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 120311 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox | ||||
Database type & version | Postgresql 9.1.2 | ||||
Server OS (if known) | Debian GNU/Linux 6.0 64bits | ||||
Webserver software & version (if known) | Apache 2.2.9 | ||||
PHP Version | 5.2.6 | ||||
Fix committed to master branch. |
|
Fix committed to Yii branch with changeset ID 7958 |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=7987 |
|
The probleme is that the database seems to be upgraded : DBVersion = 155. How can I re-roll the upgrade ? |
|
Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8090 |
|
Released 2.00b1 |
|
LimeSurvey: master 549e7e9a 2012-03-14 16:45:03 Details Diff |
Fixed issue 05904: Database upgrade fails with errors on Postgres |
Affected Issues 05904 |
|
mod - admin/install/create-mysql.sql | Diff File | ||
mod - admin/install/create-postgres.sql | Diff File | ||
mod - admin/update/upgrade-mysql.php | Diff File | ||
mod - admin/update/upgrade-postgres.php | Diff File | ||
LimeSurvey: Yii 1b8a08d5 2012-03-14 16:53:54 Details Diff |
Fixed issue 05904: Database upgrade fails with errors on Postgres Fixed issue: Missing tables and fields on upgrade |
Affected Issues 05904 |
|
rm - application/helpers/update/upgrade-mssqlnative_helper.php | Diff File | ||
mod - application/config/version.php | Diff File | ||
mod - application/helpers/update/upgrade-all_helper.php | Diff File | ||
mod - application/helpers/update/upgrade-mssql_helper.php | Diff File | ||
mod - application/helpers/update/upgrade-mysql_helper.php | Diff File | ||
mod - application/helpers/update/upgrade-postgres_helper.php | Diff File | ||
mod - installer/sql/create-mssql.sql | Diff File | ||
mod - installer/sql/create-mssqlnative.sql | Diff File | ||
mod - installer/sql/create-mysql.sql | Diff File | ||
mod - installer/sql/create-pgsql.sql | Diff File | ||
LimeSurvey: master 56a4843b 2012-03-19 09:10:45 Details Diff |
Fixed issue 05904: Database upgrade fails with errors on Postgres |
Affected Issues 05904 |
|
mod - admin/update/upgrade-postgres.php | Diff File | ||
LimeSurvey: Yii b76c97f0 2012-04-04 02:37:42 Details Diff |
Fixed issue 05904: Database upgrade fails with errors on Postgres |
Affected Issues 05904 |
|
mod - application/helpers/update/upgrade-postgres_helper.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2012-03-13 16:16 |
|
New Issue | |
2012-03-15 00:31 | c_schmitz | Assigned To | => c_schmitz |
2012-03-15 00:31 | c_schmitz | Status | new => assigned |
2012-03-15 00:46 | c_schmitz | Changeset attached | => LimeSurvey master 549e7e9a |
2012-03-15 00:46 | c_schmitz | Note Added: 17933 | |
2012-03-15 00:46 | c_schmitz | Status | assigned => resolved |
2012-03-15 00:46 | c_schmitz | Resolution | open => fixed |
2012-03-15 00:51 | c_schmitz | Fixed in Version | => 2.00b1 |
2012-03-15 15:46 | c_schmitz | Changeset attached | => LimeSurvey Yii 1b8a08d5 |
2012-03-15 15:46 | c_schmitz | Note Added: 17938 | |
2012-03-19 17:10 | c_schmitz | Changeset attached | => LimeSurvey master 56a4843b |
2012-03-19 17:10 | c_schmitz | Note Added: 17991 | |
2012-03-20 09:13 |
|
Note Added: 18002 | |
2012-04-04 11:51 | c_schmitz | Changeset attached | => LimeSurvey Yii b76c97f0 |
2012-04-04 11:51 | c_schmitz | Note Added: 18192 | |
2012-04-05 19:15 | c_schmitz | Note Added: 18212 | |
2012-04-05 19:15 | c_schmitz | Status | resolved => closed |