- Posts: 20
- Thank you received: 2
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
bug ? answers not recorded in DB but notification email is sent
- bebs
- Topic Author
- Offline
- Junior Member
Using LS 3.19.1+191009 on PHP 7.3 @OVH, I experience a troublesome bug for a running survey. Any help in fixing it is urgently welcome.
After the users gets his token sent by email, answers all questions (multiple pages) with no issue and gets the last "thank you" page displayed, his answers are sometimes not recorded at all in the LS DB.
The related token entry is updated (completion time is set, uses left is decreased,...) but NO ANSWER entry is created for this user.
Moreover :
.The user gets "his" confirmation email with a few (questions-related) shortcodes rightfully replaced by correct values,
. The "full" notification email (default template) sent to administrator is faulty in that
the {EDITRESPONSEURL} does not contain the answer ID
the {ANSWERTABLE} contains no answers (only the questions text and codes), even the "metadata" of the entry is completely missing:
Cliquez sur le lien suivant pour voir cette réponse :
emfro.vunderatert.lu/index.php/admin/res...w/surveyid/612987/id << MISSING ANSWER ID
Cliquez sur le lien suivant pour éditer cette réponse individuelle :
emfro.vunderatert.lu/index.php/admin/dat...t/surveyid/612987/id
Visualisez les statistiques en cliquant ici :
emfro.vunderatert.lu/index.php/admin/sta...ndex/surveyid/612987
Les réponses suivantes ont été données par le participant :
ID de la réponse << MISSING METADATA
Date de soumission
Dernière page
Langue de départ
Tête de série
Code
Date de lancement
Date de la dernière action
Renseignements personnels
civilité << MISSING ANSWER
civilité [Autre]
Vos coordonnées
Vos coordonnées [Prénom]
The user has no "error" feedback while completing the survey. The web console only shows 2 warning on the last ("thank you") page for missing assets maps:
DevTools failed to parse SourceMap: emfro.vunderatert.lu/tmp/assets/301146f9/pjax.js.map
DevTools failed to parse SourceMap: emfro.vunderatert.lu/tmp/assets/d6560812/bootstrap.min.css.map
... but the related assets (stripping .map at the end) are available at the generated URL.
LSS is provided for your inspection, along with theme customisations (VdA.zip) that is used to compute a few answers (simple dynamic sum and products in array-like answers) in JS.
Strangest thing is that in the meantime some other users' answers are recorded correctly, and I see no pattern in those that work or fail (since I don't have any detail on the ones failing). Web server logs don't show any error.
Any idea how to look to debug the problem ?
Thanks in advance,
Berteh.
- jelo
- Offline
- Platinum Member
- Posts: 5033
- Thank you received: 1257
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
- bebs
- Topic Author
- Offline
- Junior Member
- Posts: 20
- Thank you received: 2
Will try to update, thanks for the recommandation.
- bebs
- Topic Author
- Offline
- Junior Member
- Posts: 20
- Thank you received: 2
I looked for documentation on upgrading in the manual... but nothing relates to LS3, is it as simple as backup - overwrite files & test, or is there some DB updates to run too ?
- jelo
- Offline
- Platinum Member
- Posts: 5033
- Thank you received: 1257
manual.limesurvey.org/Upgrading_from_a_previous_version
The fixes applied to LS3 can be seen in the changelog and in GITHUB.
github.com/LimeSurvey/LimeSurvey/commits/3.x-LTS
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
- bebs
- Topic Author
- Offline
- Junior Member
- Posts: 20
- Thank you received: 2
I updated my system to 3.22.8+200309 and the problem still happens:
1) Some people register to get a token, answer via the provided link, submit their answer get the automated confirmation email (with expressions being well replaced by the given answers, but the answer ID is not subsituted in the URL to review answer)
2) the answer is NOT recorded in LS DB, whereas the token table is updated (count left set to 0 and date of submission is recorded)
any idea how to debug this ?
- holch
- Offline
- LimeSurvey Community Team
- Posts: 11658
- Thank you received: 2742
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
- tpartner
- Offline
- LimeSurvey Community Team
- Posts: 10109
- Thank you received: 3593
Not necessarily - Expression Manager works in inactive surveys where no data is recorded.There seems to be more going on. In my opinion, for the expressions to be able to use the previous answers, the data must be recorded in the database at some point.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
- holch
- Offline
- LimeSurvey Community Team
- Posts: 11658
- Thank you received: 2742
Good point! So does it draw from the session files?Not necessarily - Expression Manager works in inactive surveys where no data is recorded.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
- bebs
- Topic Author
- Offline
- Junior Member
- Posts: 20
- Thank you received: 2
When run in debug mode a few warning are printed on top of each question page:
Notice: Undefined index: anonymized in /home/vunderatdm/limesurvey/application/helpers/expressions/em_manager_helper.php on line 6031 Notice: Undefined index: deletenonvalues in /home/vunderatdm/limesurvey/application/helpers/expressions/em_manager_helper.php on line 6979 Notice: Undefined index: deletenonvalues in /home/vunderatdm/limesurvey/application/helpers/expressions/em_manager_helper.php on line 6979 Notice: Undefined index: active in /home/vunderatdm/limesurvey/application/helpers/expressions/em_manager_helper.php on line 5438
and on the top of thirs question the following show up too:
Notice: Undefined index: radix in /home/vunderatdm/limesurvey/application/helpers/expressions/em_manager_helper.php on line 8844 Notice: Undefined index: anonymized in /home/vunderatdm/limesurvey/application/helpers/expressions/em_manager_helper.php on line 6031 Notice: Undefined index: deletenonvalues in /home/vunderatdm/limesurvey/application/helpers/expressions/em_manager_helper.php on line 6979
and on the last, automatic "thank you" page I get this new notice:
Notice: Undefined index: srid in /home/vunderatdm/limesurvey/application/helpers/frontend_helper.php on line 586
I confirm I can reproduce the problem. I got valid answers that fail each time to be recorded in the DB, even though they don't look suspicious: it's just a few select drop downs, integers and free text in german.
Strangely enough, selecting french language and answering in french doesn't seem to ever fail, for the same survey with 2 active languages (FR is main. DE is translation).
Don't know if that helps though.
B.
- DenisChenu
- Away
- LimeSurvey Community Team
- Posts: 13645
- Thank you received: 2491
Before anything else : update to last LTS version : www.limesurvey.org/lts-releases-downloadUsing LS 3.19.1+191009 on PHP 7.3 @OVH, I experience a troublesome bug for a running survey. Any help in fixing it is urgently welcome.
There are really a big issue here ...Notice: Undefined index: anonymized in /home/vunderatdm/limesurvey/application/helpers/expressions/em_manager_helper.php on line 6031
No plugin ? No Ajax mode ? Use included theme ?
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
- bebs
- Topic Author
- Offline
- Junior Member
- Posts: 20
- Thank you received: 2
I use some homemade JS to compute autonamted numeral value, in the answers structure in the attached LSS file.
But the EM error mentionned happens before that, on the first survey page after registration:
The registration link is a static redirection to the "right" questionnaire ID: [url] zaitgemeis.vunderatert.lu [/url] > emfro.vunderatert.lu/index.php/612987 ... and things seem to go wrong if the user registers there in FR, and then changes the language in the first page of the questionnaire to DE. That first page is about privacy policy, displayed using LS normal mechanism for in-page display of these terms.
Attached is also the custom theme (VdA), but no JS there. I did try to add the localized survey introduction message in the welcome page, but that did not work... would that be the culprit ?
How can I further debug this ?
Thanks for your help !
Berteh.