View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
10036Bug reportsInstallationpublic2015-12-04 15:13
Reportergplattner Assigned Toc_schmitz  
PriorityhighSeveritycrash 
Status closedResolutionfixed 
Product Version2.06+ 
Fixed in Version2.06+ 
Summary10036: I tried to upgrade vom 2.00+ to 2.06+ (current version) and had an error (crash).
Description

See Issue 9794

I tried the Workaround but the update process terminates with the message:

Ein Fehler trat während des Datenbankupdates auf. Fehlerinformation:
CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "lime_plugins" already exists

After droping the table, I got again the message

Ein Fehler trat während des Datenbankupdates auf. Fehlerinformation:
CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: boolean = integer LINE 1: SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=1 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)151109
I will donate to the project if issue is resolvedNo
Browser
Database type & versionpsql (PostgreSQL) 9.1.19
Server OS (if known)ubuntu 14.04
Webserver software & version (if known)apache 2.4
PHP Version5.5.9+dfsg-1ubuntu4.14

Users monitoring this issue

There are no users monitoring this issue.

Activities

gplattner

gplattner

2015-11-15 18:15

reporter   ~33569

my update URL: index.php/admin/databaseupdate/sa/db

gplattner

gplattner

2015-11-28 11:53

reporter   ~33633

With the following steps I solved the problem for me:

  • installing the limesurvey version 2.05+ (from download archive)
  • run the database upgrade
  • installing the limesurvey version 2.06+
  • run the database upgrade

everything works fine!

c_schmitz

c_schmitz

2015-12-04 11:29

administrator   ~33678

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=16370

c_schmitz

c_schmitz

2015-12-04 11:29

administrator   ~33679

Thank you! Good catch!

c_schmitz

c_schmitz

2015-12-04 15:13

administrator   ~33692

2.06+ Build 151205 released

Related Changesets

LimeSurvey: master 313548fb

2015-12-04 10:28:55

c_schmitz

Details Diff
Fixed issue 10036: Problems when trying to update from 2.0 and using Postgres Affected Issues
10036
mod - application/helpers/update/updatedb_helper.php Diff File
mod - application/models/LSActiveRecord.php Diff File

Issue History

Date Modified Username Field Change
2015-11-15 18:10 gplattner New Issue
2015-11-15 18:15 gplattner Note Added: 33569
2015-11-28 11:53 gplattner Note Added: 33633
2015-12-04 11:29 c_schmitz Changeset attached => LimeSurvey master 313548fb
2015-12-04 11:29 c_schmitz Note Added: 33678
2015-12-04 11:29 c_schmitz Assigned To => c_schmitz
2015-12-04 11:29 c_schmitz Resolution open => fixed
2015-12-04 11:29 c_schmitz Status new => assigned
2015-12-04 11:29 c_schmitz Note Added: 33679
2015-12-04 11:29 c_schmitz Status assigned => resolved
2015-12-04 11:29 c_schmitz Fixed in Version => 2.06+
2015-12-04 15:13 c_schmitz Note Added: 33692
2015-12-04 15:13 c_schmitz Status resolved => closed