View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 08614 | Bug reports | Installation | public | 2014-01-28 11:01 | 2014-02-04 13:32 |
| Reporter | i_meyer | Assigned To | c_schmitz | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.05+ | ||||
| Fixed in Version | 2.05+ | ||||
| Summary | 08614: Error during upgrade vom 2.00 to 2.05 on a PostgreSQL-Backend | ||||
| Description | While training an update from 2.00 (latest build) to 2.05 (build 140125) the following error occured: CDbCommand failed to execute the SQL statement: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: column "active" cannot be cast to type integer The update was performed as follows:
| ||||
| Additional Information | DBVersion: 164 I think, the sql-statement for updating to DBVersion 175 must be something like this: (same scenario, but different error like in 08519) | ||||
| Tags | No tags attached. | ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 140125 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Firefox | ||||
| Database type & version | PostgreSQL 9.1 | ||||
| Server OS (if known) | Ubuntu-Linux | ||||
| Webserver software & version (if known) | Apache 2 | ||||
| PHP Version | 5.3 | ||||
| Git branch / Pull Request URL | |||||
|
I had this : http://www.limesurvey.org/fr/forum/installation-a-update-issues/95790-update-2-00-to-2-05-postgres-not-ok#104161 or would you prefer that I show the contents of the forum ? In my setup limesurvey 2.00 build 131219 has no table plugins |
|
|
@rigcles: The table plugins will be created in DBVersion 165 (LimeSurvey 2.05 I guess) and modified in DBVersion 175. |
|
|
Ok I was referring to the note Carsten: http://bugs.limesurvey.org/view.php?id=8519#c28017 I tried this plugin table, now I understand why I could not find :) |
|
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13838 |
|
|
Version 2.05+ Build 140204 released |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2014-01-28 11:01 | i_meyer | New Issue | |
| 2014-01-31 15:56 | riqcles | Note Added: 28331 | |
| 2014-01-31 15:57 | riqcles | Note Edited: 28331 | |
| 2014-02-03 16:33 | c_schmitz | Assigned To | => c_schmitz |
| 2014-02-03 16:33 | c_schmitz | Status | new => assigned |
| 2014-02-04 08:40 | i_meyer | Note Added: 28468 | |
| 2014-02-04 12:24 | riqcles | Note Added: 28483 | |
| 2014-02-04 12:47 | c_schmitz | Status | assigned => resolved |
| 2014-02-04 12:47 | c_schmitz | Fixed in Version | => 2.05+ |
| 2014-02-04 12:47 | c_schmitz | Resolution | open => fixed |
| 2014-02-04 12:47 | c_schmitz | Changeset attached | => LimeSurvey master 609676a4 |
| 2014-02-04 12:47 | c_schmitz | Note Added: 28484 | |
| 2014-02-04 13:32 | c_schmitz | Note Added: 28490 | |
| 2014-02-04 13:32 | c_schmitz | Status | resolved => closed |