| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 12075 | Bug reports | Translation | public | 2017-01-23 11:59 | 2017-01-30 15:25 |
| Reporter | rar | Assigned To | c_schmitz | ||
| Priority | none | Severity | block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.59.x | ||||
| Fixed in Version | 2.62.x | ||||
| Summary | 12075: The value for the column "scale_id" is not supplied when querying the table "lime_answers". | ||||
| Description | Limesurvey Version 2.59.1+170116 On using quick translate all is fine. But if i update some content on tab "answer option" the error 'The value for the column "scale_id" is not supplied when querying the table "lime_answers".' occur. | ||||
| Steps To Reproduce | install latest limesurvey on a postgres database (8.4), | ||||
| Additional Information | i think that the scale_id for function query in translate.php (row 815) did not have the scale_id parameter | ||||
| Tags | No tags attached. | ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 2.59.1+170116 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Firefox | ||||
| Database type & version | PostgreSQL 8.4 | ||||
| Server OS (if known) | debian | ||||
| Webserver software & version (if known) | Apache2 | ||||
| PHP Version | 5.3.3 | ||||
 |
Please attach the debug output as PDF or HTML file to the bug report. Thank you. |
|
|
Thank you. I think your server cuts off POST parameters. Please check the following FAQ item: and let us know if that is the problem. |
 |
server configuration is: php.ini: i hope i don't forget a value to post the sended values come to the server, i testet with add some other content to other tabs and save successfully. so i think the problem is in the answer-option processing |
|
|
Can you attach that survey as .lss file, please? Because I cannot reproduce this issue with our test surveys. |
 |
pgsql updateByPk scale_id=null ???? Stange , no ? |
|
|
I cannot reproduce using your LSS. In translate.php line 127 there is the place where the scale_id is read from the POST data. Check if the particular POST param was really posted when you submit the page. If it was and it cannot be read by that line then I think there must be something with your server configuration. Please check again. Thank you. |
|
|
Ok, i don't know where the problem could be. If I create a new survey with one option question, two languages ... and test to quick translate then:
see post (Firefox, LiveHttpHeaders) in attached files. |
|
|
Try to disable Suhosin tempoarily by enabling https://suhosin.org/stories/configuration.html#suhosin-simulation and see if that helps. |
|
|
I have install a fresh limesurvey and import the lss-file. On quicktranslate the answer-option the same error occur. So either its a bug or the server requirements are not correct. In table lime_answers all scale_id have a 0 as value (0 as integer, not NULL). |
|
|
Disabeling suhosin did not effect, sorry |
|
|
Looking at Firefox Dev: seems thare are a scale_id (upload scrennshot) |
|
|
I cannot reproduce on a fresh installation. If it works on a small survey but not on a big one then the POST data is cut off for some reason. LimeSurvey does not cut off anything so it is something server-related - if it is not Suhosin it might be some other module or settings. |
|
|
look at my screenshot, there is no answer_scaleid value ... but where is it? so the scale_id are available for system |
|
|
ok, I addes manually an hidden inputfile like the template-image from DenisChenu, add a new value for answer_option and it saved successfully. |
|
|
How should I know - the screenshot of your HTML source does not even reveal which question it is - so the answers for which question are affected? |
|
|
your are right, look at the next screenshot, it is from shared lss file, answer_option question S1Q001 (31) |
|
|
so, i search for it, and i ended in application/conbtrollers/admin/translate.php where the form for editing translation is generated. In function displayTranslateFields the variable $iScaleID is empty, so no input field is generated. In debug output of yii framework three query sended to database with results: 2: 3: Maybe it helps you for find the error. Thanks |
|
|
I think i get it! |
|
|
Even if $iScaleID is numeric 0 then $iScaleID!='' still should not be evaluating to false. That seems to be very weird. Maybe it is a specialty of the database driver. is_numeric I the function that fits best here, I think. Great catch - I am sorry that I gave up too early and hope that I did not frustrate you. |
|
|
Frustation gone ;-) and i think it for a good software it is a fine challange to fix |
|
|
LimeSurvey Version 2.62.1 released |
