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 …

On a side note: What setting do we need to activate to include the full failing SQL statement at the error email? Is that only doable by enabling debiug mode?

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
2) You want to update an answer that does not exist (eg: the admin deleted the incomplete answer while someone else was completing it).

In the first case, the ID cannot be included in the mail because it does not exist.
In the second case it could be included, but I don't know if it is of much use in most cases.

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 :)
That could give a sense of where the record should have been located in the table.
Again, not sure it is worth it.

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.

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 :)