View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
05856Bug reportsOtherpublic2012-02-27 11:262012-03-03 02:25
Reporteruser18286Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.92RC5 
Target Version1.92Fixed in Version1.92 
Summary05856: Syntax problem with database postgresql-9.0
Description

When I try fill my survey I get error messages in browser:
ERROR: syntax error at end of input LINE 1: ...:35', "49389X3X11SQ001"='N', "49389X3X11SQ002"='U' WHERE ID= ^:UPDATE "lime_survey_49389" SET "lastpage"='1', "submitdate"='2012-02-27 12:19:35', "49389X3X11SQ001"='N', "49389X3X11SQ002"='U' WHERE ID=

In postgresql.log I can see something like that:

2012-02-27 11:19:29 GMT ERROR: invalid name syntax at character 16
2012-02-27 11:19:29 GMT STATEMENT: SELECT CURRVAL('"lime_survey_49389"_sid_seq')
2012-02-27 11:19:35 GMT ERROR: syntax error at end of input at character 138
2012-02-27 11:19:35 GMT STATEMENT: UPDATE "lime_survey_49389" SET "lastpage"='1', "submitdate"='2012-02-27 12:19:35', "49389X3X11SQ001"='N', "49389X3X11SQ002"='U' WHERE ID=

Additional Information

$versionnumber = "1.92 RC5";
$dbversionnumber = 155;
$buildnumber = '120225';

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)155
I will donate to the project if issue is resolvedNo
BrowserFirefox 10.0.2
Database type & versionPostgreSQL 9.0.6 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit
Server OS (if known)Debian 6.0 x64
Webserver software & version (if known)2.2.16-6+squeeze6
PHP VersionPHP 5.3.10-1~dotdeb.1 with Suhosin-Patch (cli) (built: Feb 2 2012 23:28:08)

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-03-03 02:25

administrator   ~17727

1.92 released

Issue History

Date Modified Username Field Change
2012-02-27 11:26 user18286 New Issue
2012-02-27 15:28 c_schmitz Assigned To => c_schmitz
2012-02-27 15:28 c_schmitz Status new => assigned
2012-02-27 15:32 c_schmitz Status assigned => resolved
2012-02-27 15:32 c_schmitz Fixed in Version => 1.92
2012-02-27 15:32 c_schmitz Resolution open => fixed
2012-03-01 16:05 TMSWhite Target Version => 1.92
2012-03-03 02:25 c_schmitz Note Added: 17727
2012-03-03 02:25 c_schmitz Status resolved => closed