View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
09682Bug reportsComfortUpdatepublic2015-06-15 08:552015-06-18 10:46
ReporterDenisChenu Assigned Tosammousa  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.06+ 
Target Version2.06+ 
Summary09682: 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

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)150615
I will donate to the project if issue is resolvedNo
Browserfirefox
Database type & versionpgsql 9
Server OS (if known)debian/linux
Webserver software & version (if known)apache
PHP VersionPHP 5.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2015-06-15 08:55

developer   ~32346

Not ComfortUpdate but update :)
c_schmitz

c_schmitz

2015-06-15 09:08

administrator   ~32347

Sam, can you please have a look at this?
DenisChenu

DenisChenu

2015-06-15 09:17

developer   ~32348

Think it's db/PgsqlSchema because we move from string(254) to varying ?
c_schmitz

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

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

c_schmitz

2015-06-18 10:46

administrator   ~32418

Version 2.06+ Build 150618 released

Related Changesets

LimeSurvey: master db0280d9

2015-06-15 08:22:43

sammousa

Details Diff 		Fixed issue 09682: Unable to update with pgsql Affected Issues
09682
mod - application/core/db/SmartColumnTypeTrait.php Diff File

Issue History

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