08614: Error during upgrade vom 2.00 to 2.05 on a PostgreSQL-Backend

This bug affects 1 person(s).

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: Unpack new 2.05-release in a fresh directory in the web directory Copy config.php + upload-dir from 2.00 installation Start admin page on the new 2.05 directory from browser Click "next"
Additional Information	DBVersion: 164 I think, the sql-statement for updating to DBVersion 175 must be something like this: ALTER TABLE plugins ALTER active TYPE integer USING (active::integer); (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

User List	There are no users monitoring this issue.

riqcles 2014-01-31 15:56 reporter ~28331 Last edited: 2014-01-31 15:57	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

i_meyer 2014-02-04 08:40 reporter ~28468	@rigcles: The table plugins will be created in DBVersion 165 (LimeSurvey 2.05 I guess) and modified in DBVersion 175.

riqcles 2014-02-04 12:24 reporter ~28483	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 :)

c_schmitz 2014-02-04 12:47 administrator ~28484	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13838

c_schmitz 2014-02-04 13:32 administrator ~28490	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

LimeSurvey: master 609676a4 2014-02-04 12:47 c_schmitz Details Diff	Fixed issue 08614: Error during upgrade vom 2.00 to 2.05 when using Postgres		Affected Issues 08614
	mod - application/helpers/update/updatedb_helper.php		Diff File