On our system I got an error, "An error occurred saving a response to survey id Values profile RT v12 - 112001"

See below for more details. Other than this one response, the system is working correctly. Can anybody explain why I get this, where to look for more details? This happened when the customer submitted the survey, all data was lost. I don't understand how that can happen, as we run the survey question by question and they should be saved in the database.

DATA TO BE ENTERED:
token: GZYL8sRQKGz4XGL
112001X2640X106529PA011: N/A
112001X2640X106529PA012: N/A
112001X2640X106529PA013: N/A
112001X2640X106529PA014: N/A
112001X2640X106529PA015: N/A
.....(for each answer option)

SQL CODE THAT FAILED:
UPDATE {{survey_112001}} SET `lastpage`=0, `datestamp`='2019-10-02 21:20:24', `ipaddr`='94.142.111.28' WHERE ID=21

No error message was given.

Kind regards,
Auke

LimeSurvey version and build number ?
Survey settings (allow or not update with token)

Version 3.15.5+181115
Enable token-based response persistence: ON
Allow multiple responses or update responses with one token: OFF

Allow multiple responses or update responses with one token: OFF : i have this error sometimes, using a plugin. I try to allow update a survey with already submitted survey …
And this error happen …
The LimeSurvey issue is here : github.com/LimeSurvey/LimeSurvey/blob/c8...ger_helper.php#L5575
We send the same message with a broken SQL and a disable save again.

Maybe you can check if reponse id 21 have a submitdate ?

We can't allow users to update their survey as we process the data after submission.

Yes, there is a submit date.

I don't understand that a broken SQL query can erase all the responses already entered in the database. The survey is set question-by-question, so the answers to a question should be saved once it goes to the next question.

The error didn't come from a broken SQL query, but from a "try to submit an already submitted survey" …

For me it's happen with a plugin. But i have it on another system without plugin and i don't find how exactly this happen (don't find the way to reproduce).

Maybe a potential reproduct step
1. Start survey on browser #1 (get 1st question at minimum)
2. Start survey on browser #2 (go to 1st group, didn't submit)(maybe check with just welcome page)
3. Submit survey in browser #1 : survey submitdate is set
4. Try to move next on browser #2 : the error can happen.

If you can reproduce the issue with such step. And can check on demo.limesurey.org : please report the issue .

The survey is set question-by-question, so the answers to a question should be saved once it goes to the next question.

Try testing to see whether that is the case with and without AJAX enabled.

Thanks Tony. I just found out today that the user choose 'OptOut', likely in combination with having it half filled out. I tried to recreate the problem on my test environment but can't.