09682: Unable to update with pgsql - LimeSurvey bugs and feature requests

This issue affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

09682	Bug reports	ComfortUpdate	public	2015-06-15 08:55	2015-06-18 10:46

Reporter	DenisChenu	Assigned To	sammousa
Priority	normal	Severity	minor
Status	closed	Resolution	fixed
Product Version	2.06+
Target Version	2.06+

Summary	09682: Unable to update with pgsql
Description	Testing pgsql update from 4547f0a to master/2.06 version this morning: An non-recoverable error happened during the update. Error details: CDbCommand failed to execute the SQL statement: SQLSTATE[42704]: Undefined object: 7 ERREUR: le type « varying » n'existe pas. The SQL statement executed was: ALTER TABLE "lime_tokens_765478" ALTER COLUMN "email" TYPE varying
Steps To Reproduce	Update a pgsql version.
Additional Information	Not sure when it happen. Think it's only from 2.05 to 2.06 (because no error like this at forum ?). DB version : 178
Tags	No tags attached.

Bug heat	6
Complete LimeSurvey version number (& build)	150615
I will donate to the project if issue is resolved	No
Browser	firefox
Database type & version	pgsql 9
Server OS (if known)	debian/linux
Webserver software & version (if known)	apache
PHP Version	PHP 5.4

User List	There are no users monitoring this issue.

DenisChenu 2015-06-15 08:55 developer ~32346	Not ComfortUpdate but update :)

c_schmitz 2015-06-15 09:08 administrator ~32347	Sam, can you please have a look at this?

DenisChenu 2015-06-15 09:17 developer ~32348	Think it's db/PgsqlSchema because we move from string(254) to varying ?

c_schmitz 2015-06-15 09:44 administrator ~32350	It is 'character varying' which is 'varchar' in other databases. So obviously the new DB schema routines are cutting off something

sammousa 2015-06-15 10:23 reporter ~32351	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=15425

c_schmitz 2015-06-18 10:46 administrator ~32418	Version 2.06+ Build 150618 released

Date Modified	Username	Field	Change
2015-06-15 08:55	DenisChenu	New Issue
2015-06-15 08:55	DenisChenu	Status	new => assigned
2015-06-15 08:55	DenisChenu	Assigned To	=> c_schmitz
2015-06-15 08:55	DenisChenu	Assigned To	c_schmitz =>
2015-06-15 08:55	DenisChenu	Note Added: 32346
2015-06-15 08:55	DenisChenu	Status	assigned => new
2015-06-15 09:07	c_schmitz	Assigned To	=> DenisChenu
2015-06-15 09:07	c_schmitz	Status	new => assigned
2015-06-15 09:07	c_schmitz	Assigned To	DenisChenu => sammousa
2015-06-15 09:08	c_schmitz	Note Added: 32347
2015-06-15 09:17	DenisChenu	Note Added: 32348
2015-06-15 09:44	c_schmitz	Note Added: 32350
2015-06-15 10:23	sammousa	Status	assigned => resolved
2015-06-15 10:23	sammousa	Resolution	open => fixed
2015-06-15 10:23	sammousa	Changeset attached	=> LimeSurvey master db0280d9
2015-06-15 10:23	sammousa	Note Added: 32351
2015-06-18 10:46	c_schmitz	Note Added: 32418
2015-06-18 10:46	c_schmitz	Status	resolved => closed

LimeSurvey: master db0280d9 2015-06-15 10:22 sammousa Details Diff	Fixed issue 09682: Unable to update with pgsql		Affected Issues 09682
	mod - application/core/db/SmartColumnTypeTrait.php		Diff File