View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 17692 | Bug reports | Survey taking | public | 2021-11-02 09:18 | 2026-10-26 13:51 |
| Reporter | Mazi | Assigned To | c_schmitz | ||
| Priority | none | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.25.13 | ||||
| Summary | 17692: Missing data set ID info at "Error saving results" email | ||||
| Description | If Limesurvey fails to save a response, a "Error saving results" email is sent including the response details, see screenshot. On a side note: What setting do we need to activate to include the full fialing SQL statement at the error email? Is that only doable by enabling debiug mode? | ||||
| Steps To Reproduce | Steps to reproduceThis is difficult to reproduce, You need to force e.g. an SQL error by entering some invalid input. Expected resultInclude the data set ID at the error email. Actual resultMissing data set ID information | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 18 | ||||
| Complete LimeSurvey version number (& build) | Version 3.25.14+210218 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Chrome | ||||
| Database type & version | MySQL | ||||
| Server OS (if known) | Linux | ||||
| Webserver software & version (if known) | Apache | ||||
| PHP Version | 7.3 | ||||
| Git branch / Pull Request URL | |||||
|
here you can see : https://forums.limesurvey.org/forum/french-forum/122853-erreur-de-sauvegarde?start=0 but i must trad this :) soon. |
|
|
@riqcles : Marcel ask to hav reponse->id in returned information. Not about the issue … why this question was not saved … |
|
We must have a better way to return the issue , the exact SQL error seem the best. And maybe the complete request. |
|
|
@DeniChenu, I agree, the more information gets included, the easier it is to track this down. @galads, can we add this to the next sprint? It affects many users. |
|
|
The error mail is only sent in two cases: 1) Response creation failed In the first case, the ID cannot be included in the mail because it does not exist. On the subject of SQL, apparently it is never included. Looks like it was used at some point, but not anymore. And with the use of ActiveRecord it is not easy to do it. We could create a logger, but that will hit performance. As per the ID, althgouh we can't include the ID, we could include the max id on the table at that time :) |
|
We can not get the SQL error message ? I think i have a way to get SQL error on survey , i send instruction after. Then we have a system to try to get the SQL error :) |
|
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=41027 |
|
|
Fixed in Release 7.8.0+261026 |
|
|
LimeSurvey: master b3916696 2026-10-25 17:03 Details Diff |
Fixed issue 17692: The "Error saving results" email did not include the response ID, and a database error while saving answers showed an error page without sending the email Dev submitfailed() adds the response ID from the session when the response row exists; a database exception from encryptSave() in LimeExpressionManager::_UpdateValuesInDatabase() is caught and passed to submitfailed() as error message |
Affected Issues 17692 |
|
| mod - application/helpers/expressions/em_manager_helper.php | Diff File | ||
| mod - application/helpers/frontend_helper.php | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-11-02 09:18 | Mazi | New Issue | |
| 2021-11-02 09:18 | Mazi | File Added: image.png | |
| 2022-04-29 17:45 | riqcles | Note Added: 69306 | |
| 2022-04-29 17:45 | riqcles | Bug heat | 0 => 8 |
| 2022-04-29 21:09 | DenisChenu | Note Added: 69314 | |
| 2022-04-29 21:09 | DenisChenu | Bug heat | 8 => 10 |
| 2022-04-29 21:13 | DenisChenu | Note Added: 69315 | |
| 2022-05-17 12:18 | Mazi | Note Added: 69715 | |
| 2022-05-17 12:18 | Mazi | Bug heat | 10 => 12 |
| 2022-07-19 15:35 | gabrieljenik | Note Added: 71015 | |
| 2022-07-19 15:35 | gabrieljenik | Bug heat | 12 => 14 |
| 2022-07-20 11:12 | DenisChenu | Note Added: 71046 | |
| 2022-07-20 15:47 | gabrieljenik | Status | new => confirmed |
| 2026-10-25 17:14 | c_schmitz | Changeset attached | => LimeSurvey master b3916696 |
| 2026-10-25 17:14 | c_schmitz | Note Added: 86785 | |
| 2026-10-25 17:14 | c_schmitz | Assigned To | => c_schmitz |
| 2026-10-25 17:14 | c_schmitz | Status | confirmed => resolved |
| 2026-10-25 17:14 | c_schmitz | Resolution | open => fixed |
| 2026-10-25 17:14 | c_schmitz | Bug heat | 14 => 16 |
| 2026-10-26 13:51 | LimeBot | Note Added: 86832 | |
| 2026-10-26 13:51 | LimeBot | Status | resolved => closed |
| 2026-10-26 13:51 | LimeBot | Bug heat | 16 => 18 |