View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
05779Bug reportsData Entry (non public)public2012-02-08 13:332012-02-26 10:15
Reporteruser17841Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.91+ 
Fixed in Version1.92RC5 
Summary05779: When "Edit this response" the responses from Array (Numbers) question type are lost
Description

Hello
I have a survey in production
When i edit a response the values, given on questions of arrays numbers type or multiple numeric input type, are lost.
the uploaded pdf file shoes the problem.

Thanks
José Oliveira

TagsNo tags attached.
Attached Files
report_de_problema.pdf (309,310 bytes)
numbers_browse_response.PNG (21,765 bytes)   
numbers_browse_response.PNG (21,765 bytes)   
numbers_dataentry.PNG (34,249 bytes)   
numbers_dataentry.PNG (34,249 bytes)   
limesurvey_survey_23274.lss (205,092 bytes)
Bug heat8
Complete LimeSurvey version number (& build)1270
I will donate to the project if issue is resolvedNo
BrowserIE 9
Database type & versionMySql Server version 5.5.13
Server OS (if known)Windows 2008 R2 Standard
Webserver software & version (if known)IIS 7.5
PHP VersionPHP Version 5.3.6, Build Date Mar 17 2011 10:46:06

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2012-02-09 09:38

updater   ~17311

Last edited: 2012-02-09 09:41

I had an error when submitting responses for the attached survey: "Notice: Undefined index: scale_id in C:\xampp\htdocs\limeSOURCE\limesurvey_current\common_functions.php on line 1921
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND language='en'' at line 1:SELECT answer FROM lime191_answers WHERE qid=195 AND code='' AND scale_id= AND language='en'"

Results were shown at the browse response screen. When then clicking the edit answers icon to get to the data entry screen, this error message shown uo:
"Notice: Undefined variable: datentryoutput in C:\xampp\htdocs\limeSOURCE\limesurvey_current\admin\dataentry.php on line 1250"

At the data entry overview, the given responses (numbers) are not loaded correctly (see attached screens).
When I click save at the data entry screen, the former existing numbers are overwritten with the empty values.

When then viewing the just editing data set (admin/admin.php?action=browse&sid=23274&subaction=id&id=7) the following error (same as above) shows up:
Notice: Undefined index: scale_id in C:\xampp\htdocs\limeSOURCE\limesurvey_current\common_functions.php on line 1921
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND language='en'' at line 1:SELECT answer FROM lime191_answers WHERE qid=195 AND code='' AND scale_id= AND language='en'

user17998

2012-02-14 12:17

  ~17395

I had the same problem. It's a typing error in a file. The file is called dataentry.php and is located in the admin folder. Inside the file you have to look for line number 1250 and replace the value
if (!empty($idrow[$fname['fieldname']])) {$datentryoutput .= $idrow[$fname['fieldname']];}
with
if (!empty($idrow[$fname['fieldname']])) {$dataentryoutput .= $idrow[$fname['fieldname']];}.

Sometimes it's only one vokal (a).

Hope I could help.
Mazi

Mazi

2012-02-14 12:32

updater   ~17396

thebearer: Thanks for your hint. This problem should be fixed at the next 1.91+ release.

user17841

2012-02-17 15:06

  ~17487

Hi.

Thanks for the help.
I changed the file dataentry.php and now it works fine

Great work and great software.

Thanks again.
José Oliveira
magiclko

magiclko

2012-02-19 10:08

reporter   ~17514

Fixed in http://limesurvey.svn.sourceforge.net/limesurvey/?rev=12452&view=rev .
Marking it resolved!

Issue History

Date Modified Username Field Change
2012-02-08 13:33 user17841 New Issue
2012-02-08 13:33 user17841 File Added: report_de_problema.pdf
2012-02-09 09:38 Mazi Note Added: 17311
2012-02-09 09:38 Mazi Assigned To => c_schmitz
2012-02-09 09:38 Mazi Status new => assigned
2012-02-09 09:38 Mazi File Added: numbers_browse_response.PNG
2012-02-09 09:38 Mazi File Added: numbers_dataentry.PNG
2012-02-09 09:41 Mazi Note Edited: 17311
2012-02-09 09:42 Mazi File Added: limesurvey_survey_23274.lss
2012-02-14 12:17 user17998 Note Added: 17395
2012-02-14 12:32 Mazi Note Added: 17396
2012-02-17 15:06 user17841 Note Added: 17487
2012-02-19 10:08 magiclko Note Added: 17514
2012-02-19 10:08 magiclko Status assigned => resolved
2012-02-19 10:08 magiclko Fixed in Version => 1.92RC5
2012-02-19 10:08 magiclko Resolution open => fixed
2012-02-26 10:15 c_schmitz Status resolved => closed