Back to limesurvey.org

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

More
6 years 6 months ago - 6 years 6 months ago #195223 by bebs
bug ? answers not recorded in DB but notification email is sent was created by bebs
Hello.

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.
Last edit: 6 years 6 months ago by bebs. Reason: clarification
The topic has been locked.
Partner Banner
More
6 years 6 months ago #195225 by jelo
Replied by jelo on topic bug ? answers not recorded in DB but notification email is sent
The LS3 build you use is lacking some updates. I recommend to update to a higher build of LS3. There where issues with lost answers when accessing the first page. Are you using a shared webhosting account or something else from OVH?
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: bebs
The topic has been locked.
More
6 years 6 months ago #195226 by bebs
Replied by bebs on topic bug ? answers not recorded in DB but notification email is sent
yes, shared hosting indeed. So far I'm happy with their "perso2014" offer, and LS used to work fine thereon.

Will try to update, thanks for the recommandation.
The topic has been locked.
More
6 years 6 months ago #195227 by bebs
Replied by bebs on topic bug ? answers not recorded in DB but notification email is sent
would 3.22.8+200309 do, or is there a more recent LS3 update that I didn't find ?

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 ?
The topic has been locked.
More
6 years 6 months ago #195228 by jelo
Replied by jelo on topic bug ? answers not recorded in DB but notification email is sent
I wouldn't recommend doing an manual upgrade on a running system without precaution.
www.limesurvey.org/manual/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
The following user(s) said Thank You: bebs
The topic has been locked.
More
6 years 5 months ago #195461 by bebs
Replied by bebs on topic bug ? answers not recorded in DB but notification email is sent
Hello.
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 ?
The topic has been locked.
More
6 years 5 months ago #195463 by holch
Replied by holch on topic bug ? answers not recorded in DB but notification email is sent
If the data is NOT recorded in the database, how can expressions use the answers? 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.
Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
More
6 years 5 months ago #195471 by tpartner
Replied by tpartner on topic bug ? answers not recorded in DB but notification email is sent

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.

Not necessarily - Expression Manager works in inactive surveys where no data is recorded.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
More
6 years 5 months ago #195472 by holch
Replied by holch on topic bug ? answers not recorded in DB but notification email is sent

Not necessarily - Expression Manager works in inactive surveys where no data is recorded.

Good point! So does it draw from the session files?
Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
More
6 years 5 months ago - 6 years 5 months ago #195571 by bebs
Replied by bebs on topic bug ? answers not recorded in DB but notification email is sent
I'm still looking as to where this issue may come from... but to no avail for now:



When run in debug mode a few warning are printed on top of each question page:
Code:
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:
Code:
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:
Code:
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.
Last edit: 6 years 5 months ago by bebs. Reason: precision
The topic has been locked.
More
6 years 5 months ago #195576 by DenisChenu
Replied by DenisChenu on topic bug ? answers not recorded in DB but notification email is sent

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.

Before anything else : update to last LTS version : www.limesurvey.org/lts-releases-download

Notice: Undefined index: anonymized in /home/vunderatdm/limesurvey/application/helpers/expressions/em_manager_helper.php on line 6031

There are really a big issue here ...
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 support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
More
6 years 5 months ago #195801 by bebs
Replied by bebs on topic bug ? answers not recorded in DB but notification email is sent
Hello Denis.
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.
The topic has been locked.
More
6 years 5 months ago #195803 by tpartner
Replied by tpartner on topic bug ? answers not recorded in DB but notification email is sent

I did try to add the localized survey introduction message in the welcome page, but that did not work... would that be the culprit ?

What happens when you test with a core theme?
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
More
6 years 5 months ago - 6 years 5 months ago #195804 by bebs
Replied by bebs on topic bug ? answers not recorded in DB but notification email is sent
more info: I updated to 3.22.8, and set debug to 2

When I register in FR, and then change the language on the privacy statement page (without ticking the privacy box first) I got the error notice below. Setting the language back to FR does not display the error.
Code:
PHP notice Undefined index: anonymized /home/vunderatdm/limesurvey/application/helpers/expressions/em_manager_helper.php(6031) 6019 6020 if ($groupSeq < 0 || $groupSeq >= $LEM->numGroups) { 6021 return NULL; // TODO - what is desired behavior? 6022 } 6023 $groupSeqInfo = (isset($LEM->groupSeqInfo[$groupSeq]) ? $LEM->groupSeqInfo[$groupSeq] : NULL); 6024 if (is_null($groupSeqInfo)) { 6025 // then there are no questions in this group 6026 return NULL; 6027 } 6028 $qInfo = $LEM->questionSeq2relevance[$groupSeqInfo['qstart']]; 6029 $gseq = $qInfo['gseq']; 6030 $gid = $qInfo['gid']; 6031 $LEM->StartProcessingGroup($gseq, $LEM->surveyOptions['anonymized'], $LEM->sid); // analyze the data we have about this group 6032 6033 $grel=false; // assume irrelevant until find a relevant question 6034 $ghidden=true; // assume hidden until find a non-hidden question. If there are no relevant questions on this page, $ghidden will stay true 6035 $gmandViolation=false; // assume that the group contains no manditory questions that have not been fully answered 6036 $gvalid=true; // assume valid until discover otherwise 6037 $debug_message = ''; 6038 $messages = array(); 6039 $currentQset = array(); 6040 $unansweredSQs = array(); 6041 $invalidSQs = array(); 6042 $updatedValues = array(); 6043 $ganyUnanswered = false; Stack Trace #0 – /home/vunderatdm/limesurvey/application/helpers/expressions/em_manager_helper.php(5300): LimeExpressionManager->_ValidateGroup(0) 5295 'invalidSQs'=>(isset($result['invalidSQs']) ? $result['invalidSQs'] : ''), 5296 ); 5297 return $LEM->lastMoveResult; 5298 } 5299 5300 $result = $LEM->_ValidateGroup($LEM->currentGroupSeq); 5301 if (is_null($result)) { 5302 continue; // this is an invalid group - skip it 5303 } 5304 $message .= $result['message']; 5305 $updatedValues = array_merge($updatedValues,$result['updatedValues']); #1 – /home/vunderatdm/limesurvey/application/helpers/SurveyRuntimeHelper.php(828): LimeExpressionManager::NavigateForwards() 823 $this->aMoveResult = false; // so display welcome page again 824 } 825 } 826 827 if ($this->sMove == "movenext") { 828 $this->aMoveResult = LimeExpressionManager::NavigateForwards(); 829 } 830 831 if (($this->sMove == 'movesubmit')) { 832 if ($this->sSurveyMode == 'survey') { 833 $this->aMoveResult = LimeExpressionManager::NavigateForwards(); #2 – /home/vunderatdm/limesurvey/application/helpers/SurveyRuntimeHelper.php(531): SurveyRuntimeHelper->setMoveResult() 526 $this->initFirstStep(); // If it's the first time user load this survey, will init session and LEM 527 $this->initTotalAndMaxSteps(); 528 $this->checkIfUseBrowserNav(); // Check if user used browser navigation, or relaoded page 529 if ($this->sMove != 'clearcancel' && $this->sMove != 'confirmquota') { 530 $this->checkPrevStep(); // Check if prev step is set, else set it 531 $this->setMoveResult(); 532 $this->checkClearCancel(); 533 $this->setPrevStep(); 534 $this->checkIfFinished(); 535 $this->setStep(); 536 #3 + /home/vunderatdm/limesurvey/application/helpers/SurveyRuntimeHelper.php(105): SurveyRuntimeHelper->initMove() #4 + /home/vunderatdm/limesurvey/application/controllers/survey/index.php(590): SurveyRuntimeHelper->run("612987", array("surveyid" => "612987", "thissurvey" => array("htmlemail" => "Y", "format" => "G", "template" => "VdA", "language" => "fr", ...), "thisstep" => "0", "clienttoken" => "48iEq43t9", ...)) #5 + /home/vunderatdm/limesurvey/application/controllers/survey/index.php(24): index->action() #6 + /home/vunderatdm/limesurvey/framework/web/actions/CAction.php(76): index->run() #7 + /home/vunderatdm/limesurvey/framework/web/CController.php(308): CAction->runWithParams(array("sid" => "612987")) #8 + /home/vunderatdm/limesurvey/framework/web/CController.php(286): CController->runAction(index) #9 + /home/vunderatdm/limesurvey/framework/web/CController.php(265): CController->runActionWithFilters(index, array()) #10 + /home/vunderatdm/limesurvey/framework/web/CWebApplication.php(282): CController->run("index") #11 + /home/vunderatdm/limesurvey/framework/web/CWebApplication.php(141): CWebApplication->runController("survey/index/sid/612987") #12 + /home/vunderatdm/limesurvey/framework/base/CApplication.php(185): CWebApplication->processRequest() #13 + /home/vunderatdm/limesurvey/index.php(194): CApplication->run() 2020-03-25 11:14:05 Apache Yii Framework/1.1.22-dev
Last edit: 6 years 5 months ago by bebs. Reason: precision.
The topic has been locked.
More
6 years 5 months ago #195811 by DenisChenu
Replied by DenisChenu on topic bug ? answers not recorded in DB but notification email is sent
OK,

Then : seems related to multilingual and privacy box ....
See
github.com/LimeSurvey/LimeSurvey/commit/...8b63dd5d27dbbb3796e4
and
bugs.limesurvey.org/view.php?id=16025

But for 4.X ....
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
Moderators: holch, tpartner

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source