View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
09575 | Bug reports | Data Entry (non public) | public | 2015-03-19 14:12 | 2015-04-24 10:18 |
Reporter | fvanderstarre | Assigned To | c_schmitz | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | not fixable | ||
Product Version | 2.05+ | ||||
Summary | 09575: Select options for radiolist or dropdown not shown in data entry screen | ||||
Description | In data entry mode, select options are not shown for some questions (radio list/dropdown list) | ||||
Steps To Reproduce | create survey response via data entry screen (for a survey with several radio/dropdown lists) | ||||
Additional Information | works OK in L.S. 2.05+ build 140915 on PHP 5.3.3 | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 8 | ||||
Complete LimeSurvey version number (& build) | 2.05+ 150310 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox/Chrome | ||||
Database type & version | MS SQL server 2008 10.0.5500.0 (X64) | ||||
Server OS (if known) | DB server: Windows NT 6.1 <X64> build 7601 SP1 | ||||
Webserver software & version (if known) | Linux RHEL 7 | ||||
PHP Version | 5.4.16 | ||||
Also in 2.05+ build 140915 on PHP 5.4.16; so it may be PHP related? |
|
In the attached survey, the last question is affected (radio list) |
|
Can not reproduce : please activate debug to 2 |
|
I activated php error logging and set debug to 2 - no php error logged. |
|
HTML snippet: You'll notice the selected option values aren't shown for question "radio". |
|
Works fine here:
And here:
|
|
Problem seems to be somewhere around line # 742 in dataentry.php: $lquery = "SELECT * FROM {{answers}} WHERE qid={$fname['qid']} AND language = '{$sDataEntryLanguage}' ORDER BY sortorder, answer"; On iterating through questions type "!" and "L", the second/last one doesn't seem to yield any result there (foreach loop on line # 750 is executed for the first one only, in this case the type dropdown list question). |
|
Did you configure FreeTDS correctly? |
|
.... Microsoft SQL Server 2005 configuration[ms-sql-t263] (same as other system mentioned above (RHEL 5, php 5.3) |
|
Most likely PHP related since it works on newer version. Maybe the MSSQL driver has some kind of problem in that version. You would only find out by upgrading your PHP version. I see this as a no fix required. |
|
The point is, it DOES work on php 5.3.3, but NOT on 5.4.16 (in my setup). |
|
Yes, understood. But 5.4.16 is just some version in the 5.4 series. So update to any later 5.4.x version (best would be probably the latest one, 5.4.38) and see if the issue is gone. |
|
To me 5.4.16 is a newer version ;). Our Unix administrators will only support Linux/php installations based on official Red Hat repositories (that's why we've been stuck for so long on 5.3.3). So I'm not at liberty to update PHP beyond this (5.4.16) version! |
|
I managed (with a little help from my friends) to solve the problem for type "!" and "L" questions by adding "unset($lresult);" before "$lresult = dbExecuteAssoc($lquery);", in dataentry.php (lines 743 & 2043). |
|
Sounds like a memory issue. Can you raise you memory limit in PHP and see if that helps? (without your fix applied ofc). |
|
PHP memory set to 256M (from 128) - makes no difference (fix removed), option display problem still there... |
|
Well, if it is not a problem of memory then it confirms to be a issue in the PHP version. Unsetting the variable should not help :-) |
|
Yep, Sure. In PHP: and Is exactly the same thing .... no difference except one useless instruction. |
|
In this php version (5.4.16), on my systems, whenever you see a construct in LimeSurvey code like this: $lresult = dbExecuteAssoc($lquery); it seems only the first iteration goes OK (see also issue 09600). |
|
Problem solved in PHP 5.4.40 |
|
Great. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2015-03-19 14:12 | fvanderstarre | New Issue | |
2015-03-19 14:12 | fvanderstarre | File Added: limesurvey_survey_956245.lss | |
2015-03-19 14:24 | fvanderstarre | Note Added: 31859 | |
2015-03-19 14:54 | fvanderstarre | Note Added: 31860 | |
2015-03-21 11:23 | DenisChenu | Note Added: 31873 | |
2015-03-23 07:52 | fvanderstarre | Note Added: 31880 | |
2015-03-26 09:20 | fvanderstarre | Note Added: 31910 | |
2015-04-07 13:07 | tpartner | Note Added: 31952 | |
2015-04-07 14:21 | fvanderstarre | Note Added: 31953 | |
2015-04-07 15:46 | c_schmitz | Note Added: 31954 | |
2015-04-07 15:51 | fvanderstarre | Note Added: 31955 | |
2015-04-07 15:57 | c_schmitz | Note Added: 31956 | |
2015-04-07 16:47 | fvanderstarre | Note Added: 31959 | |
2015-04-08 09:23 | c_schmitz | Note Added: 31960 | |
2015-04-09 08:09 | fvanderstarre | Note Added: 31969 | |
2015-04-09 15:11 | fvanderstarre | Note Added: 31975 | |
2015-04-09 15:22 | c_schmitz | Note Added: 31976 | |
2015-04-09 15:29 | fvanderstarre | Note Added: 31977 | |
2015-04-09 17:17 | c_schmitz | Note Added: 31979 | |
2015-04-10 08:21 | DenisChenu | Note Added: 31980 | |
2015-04-13 07:47 | fvanderstarre | Note Added: 31986 | |
2015-04-24 10:06 | fvanderstarre | Note Added: 32051 | |
2015-04-24 10:18 | c_schmitz | Note Added: 32053 | |
2015-04-24 10:18 | c_schmitz | Status | new => closed |
2015-04-24 10:18 | c_schmitz | Assigned To | => c_schmitz |
2015-04-24 10:18 | c_schmitz | Resolution | open => not fixable |