Anonymous Login
2017-01-24 16:19 CET

View Issue Details Jump to Notes ] Related Changesets ]
IDProjectCategoryView StatusLast Update
05897Bug reports[User patches] Other issuespublic2012-03-14 18:14
Assigned ToTMSWhite 
Product Version 
Target VersionFixed in Version1.92+ 
Summary05897: Survey ID not set correctly after row insert in servey_NNN table
DescriptionPeople who come to fill out a survey for the first time are greeted with an error message after they try to click Next on the first page. Their answers can't be saved because survey id is not retrieved from the database correctly.
Additional InformationIn the latest code (1.92 build 20120303) the following line is wrong:

$srid = $connect->Insert_ID($this->surveyOptions['tablename'],"sid");

It should be "id" not "sid" as the last parameter.

The line (in "dev" branch) is 3279:
TagsNo tags attached.
Complete LimeSurvey version number (& build)201203
I will donate to the project if issue is resolved
Database & DB-Version
Operating System (Server)
Webserver software & version
PHP Version
Attached Files




TMSWhite (reporter)

Fixed with commit

Interestingly, this is exactly how it has always been done in 1.91+ too.

That argument is ignored in all databases except Postgres, so this must be a Postgres-only issue.


c_schmitz (administrator)

1.92+ Build 120211 released

+Related Changesets

-Issue History
Date Modified Username Field Change
2012-03-11 01:41 sergey New Issue
2012-03-11 03:52 TMSWhite Project User patches => Bug reports
2012-03-11 03:52 TMSWhite Category Survey at runtime => Other issues
2012-03-11 03:54 TMSWhite Note Added: 17821
2012-03-11 03:54 TMSWhite Status new => resolved
2012-03-11 03:54 TMSWhite Fixed in Version => 1.92+
2012-03-11 03:54 TMSWhite Resolution open => fixed
2012-03-11 03:54 TMSWhite Assigned To => TMSWhite
2012-03-11 16:31 c_schmitz Note Added: 17822
2012-03-11 16:31 c_schmitz Status resolved => closed
2012-03-14 18:14 TMSWhite Changeset attached => Import 2012-03-09 13:30:34 master d7cffd0a
+Issue History