View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
08235Bug reportsImport/Exportpublic2013-10-04 18:162013-10-10 00:35
Reporterriqcles Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary08235: Postgresql - Import .csv 1.85 to 2.00 fail
Description

When I import a questionnaire in v1.85 V2.00 in postgresql 9.1, I have an error message:

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42883]: Undefined function: 7 ERREUR: la fonction last_insert_id() n'existe pas
LINE 1: Select LAST_INSERT_ID()
^
HINT: Aucune fonction ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

DenisChenu say :
It is in the csvimport function:
$ newlid = Yii :: app () -> db-> CreateCommand ('Select LAST_INSERT_ID ()') -> query () -> read ();

Can you solve the problem?
By importing this questionnaire v1.85 V2.00 in a MySql no problem

Steps To Reproduce
  1. Import the 1.85 survey on Postgres database
TagsNo tags attached.
Attached Files
V185_limesurvey_survey_52987.csv (3,860 bytes)
Bug heat2
Complete LimeSurvey version number (& build)build130929
I will donate to the project if issue is resolvedNo
BrowserInternet explorer 9 / Firefox 10.0.0
Database type & versionPostgreSql 9.1
Server OS (if known)Windows Seven 32 bits / CentOS 5.x
Webserver software & version (if known)EasyPHP 12.0 / Apache V2
PHP Version5.1.14

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-10-09 10:31

administrator   ~26643

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

c_schmitz

2013-10-09 11:22

administrator   ~26652

2.00+ Build 121009 released
c_schmitz

c_schmitz

2013-10-10 00:35

administrator   ~26689

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

Related Changesets

LimeSurvey: master 1ec3707b

2013-10-09 10:31

c_schmitz


Details Diff		 Fixed issue 08235: Import of old .csv survey file format in Postgresql fails Affected Issues
08235
mod - application/helpers/admin/import_helper.php Diff File
mod - application/models/Quota.php Diff File

LimeSurvey: 2.05 06b130c4

2013-10-10 00:34

c_schmitz


Details Diff		 Fixed issue 08235: Import of old .csv survey file format in Postgresql fails Affected Issues
08235
mod - application/helpers/admin/import_helper.php Diff File
mod - application/models/Quota.php Diff File

Issue History

Date Modified Username Field Change
2013-10-04 18:16 riqcles New Issue
2013-10-04 18:16 riqcles File Added: V185_limesurvey_survey_52987.csv
2013-10-07 22:02 c_schmitz Assigned To => c_schmitz
2013-10-07 22:02 c_schmitz Status new => assigned
2013-10-09 10:31 c_schmitz Status assigned => resolved
2013-10-09 10:31 c_schmitz Fixed in Version => 2.00+
2013-10-09 10:31 c_schmitz Resolution open => fixed
2013-10-09 10:31 c_schmitz Changeset attached => LimeSurvey master 1ec3707b
2013-10-09 10:31 c_schmitz Note Added: 26643
2013-10-09 11:22 c_schmitz Note Added: 26652
2013-10-09 11:22 c_schmitz Status resolved => closed
2013-10-10 00:35 c_schmitz Changeset attached => LimeSurvey 2.05 06b130c4
2013-10-10 00:35 c_schmitz Note Added: 26689