View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
05865Bug reportsSurvey editingpublic2012-03-01 14:292012-03-15 18:41
Reporterjhubbs Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionunable to reproduce 
Summary05865: Adding a new question to a group results in error
Description

Occasionally, I'm getting the following error message. This typically occurs after I've left the survey window open and not performed any action. I had left this survey window open over night and continued creating the survey. I was able to create a new group enter some additional questions before I error finally showed up.

Error updating attribute value
INSERT into "lime_question_attributes" (qid, value, attribute) values (,'0','hidden')
ERROR: syntax error at or near "," LINE 2: ... (qid, value, attribute) values (,'0','hidd... ^

Steps To Reproduce

I'm not able to make this consistently happen. I had done the following before clicking save:

  • created a new question
  • entered the code
  • entered the question
  • changed type to Yes/No
  • set the value of mandatory to be Yes.
Additional Information

I'm running 1.92RC5 with the change to allow postgresql to escape bytea as well as the fix for the htmlspecialchar change to fix the error for users.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)120225
I will donate to the project if issue is resolvedNo
BrowserFirefox 10
Database type & versionPostgresql 9.1.2
Server OS (if known)Fedora 16
Webserver software & version (if known)Apache 2.2.21
PHP Version5.3.9

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-03-01 18:36

administrator   ~17697

I guesss it is some connection/session timeout to your database so it does not properly return the last insertID when creating a question.
Anyway, I cannot reproduce it here, sorry.

Issue History

Date Modified Username Field Change
2012-03-01 14:29 jhubbs New Issue
2012-03-01 18:36 c_schmitz Note Added: 17697
2012-03-01 18:36 c_schmitz Assigned To => c_schmitz
2012-03-01 18:36 c_schmitz Status new => feedback
2012-03-15 18:41 c_schmitz Status feedback => closed
2012-03-15 18:41 c_schmitz Resolution open => unable to reproduce
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing