Hi Team,

I am frequently getting :"Error saving results" and "SQL CODE THAT FAILED:" error inside my inbox from lime survey based website.

Please let me know from what cause such issue occurring again and again, how can i overcome from this issue.

Thanks,
Sanjeev Srivastava

What's the error message? Or is the message blank after "ERROR MESSAGE:"?

SQL CODE THAT FAILED and error subject is "Error saving results"

Please : limesurvey version

Maybe related to bugs.limesurvey.org/view.php?id=12113 or some other older old bug.

Hello everyone,

Yesterday I received the same king of error. As you can see, there is no error message ("message d'erreur") in the e-mail received:


Une erreur s’est produite pendant la sauvegarde d‘une réponse au questionnaire d’identifiant Portrait des attitudes et des pratiques des enseignants à l’égard des élèves doués - 322153

DONNÉES A SAISIR:
token: N/A
322153X287X1005SQ001: N/A
322153X287X1005SQ002: N/A
322153X287X1008: N/A
322153X287X1187: N/A
322153X287X1009: N/A
322153X288X1010: N/A
322153X288X1207: N/A
322153X288X1030: N/A
322153X288X1030other: N/A
322153X288X1011: N/A
322153X288X1012S103a: N/A
322153X288X1012S103b: N/A
322153X288X1012S103c: N/A
322153X288X1012S103d: N/A
322153X288X1012S103e: N/A
322153X288X1012S103f: N/A
322153X288X1012S103g: N/A
322153X288X1012S103h: N/A
322153X288X1209: N/A
322153X288X1031: N/A
322153X288X1020: N/A
322153X288X1210: N/A
322153X288X1021: N/A
322153X288X1021comment: N/A
322153X288X1032: N/A
322153X288X1032other: N/A
322153X288X1022: N/A
322153X288X1022other: N/A
322153X288X1023: N/A
322153X288X1211: N/A
322153X288X1025: N/A
322153X288X1026: N/A
322153X288X1027: N/A
322153X288X1028: N/A
322153X288X1029: N/A
322153X289X103301: N/A
322153X289X103302: N/A
322153X289X103303: N/A
322153X289X103304: N/A
322153X289X103305: N/A
322153X289X103306: N/A
322153X289X103307: N/A
322153X289X103308: N/A
322153X289X103309: N/A
322153X289X103310: N/A
322153X289X103311: N/A
322153X289X103312: N/A
322153X289X103313: N/A
322153X289X103314: N/A
322153X289X103315: N/A
322153X289X103316: N/A
322153X289X103317: N/A
322153X289X1051: N/A
322153X290X1052: N/A
322153X290X1053: N/A
322153X290X1054: N/A
322153X290X1055: N/A
322153X290X1056: N/A
322153X290X1057: N/A
322153X290X1058: N/A
322153X290X1059: N/A
322153X290X1059comment: N/A
322153X290X1060: N/A
322153X291X106101: N/A
322153X291X106102: N/A
322153X291X106103: N/A
322153X291X106104: N/A
322153X291X106105: N/A
322153X291X106106: N/A
322153X291X106107: N/A
322153X291X106108: N/A
322153X291X106109: N/A
322153X291X106110: N/A
322153X291X106111: N/A
322153X291X106112: N/A
322153X291X106113: N/A
322153X291X106114: N/A
322153X291X106115: N/A
322153X291X106116: N/A
322153X291X106117: N/A
322153X291X106118: N/A
322153X291X1080: N/A
322153X292X108101#0: N/A
322153X292X108101#1: N/A
322153X292X108102#0: N/A
322153X292X108102#1: N/A
322153X292X108103#0: N/A
322153X292X108103#1: N/A
322153X292X108104#0: N/A
322153X292X108104#1: N/A
322153X292X108105#0: N/A
322153X292X108105#1: N/A
322153X292X108106#0: N/A
322153X292X108106#1: N/A
322153X292X108107#0: N/A
322153X292X108107#1: N/A
322153X292X114801#0: N/A
322153X292X114801#1: N/A
322153X292X114802#0: N/A
322153X292X114802#1: N/A
322153X292X114803#0: N/A
322153X292X114803#1: N/A
322153X292X114804#0: N/A
322153X292X114804#1: N/A
322153X292X114805#0: N/A
322153X292X114805#1: N/A
322153X292X114806#0: N/A
322153X292X114806#1: N/A
322153X292X114807#0: N/A
322153X292X114807#1: N/A
322153X292X114808#0: N/A
322153X292X114808#1: N/A
322153X298X121209#0: N/A
322153X298X121209#1: N/A
322153X298X121210#0: N/A
322153X298X121210#1: N/A
322153X298X121211#0: N/A
322153X298X121211#1: N/A
322153X298X121212#0: N/A
322153X298X121212#1: N/A
322153X298X121213#0: N/A
322153X298X121213#1: N/A
322153X298X121214#0: N/A
322153X298X121214#1: N/A
322153X298X121215#0: N/A
322153X298X121215#1: N/A
322153X298X121216#0: N/A
322153X298X121216#1: N/A
322153X298X131109#0: N/A
322153X298X131109#1: N/A
322153X298X131110#0: N/A
322153X298X131110#1: N/A
322153X298X131111#0: N/A
322153X298X131111#1: N/A
322153X298X131112#0: N/A
322153X298X131112#1: N/A
322153X298X131113#0: N/A
322153X298X131113#1: N/A
322153X298X131114#0: N/A
322153X298X131114#1: N/A
322153X298X131115#0: N/A
322153X298X131115#1: N/A
322153X298X131116#0: N/A
322153X298X131116#1: N/A
322153X299X124517#0: N/A
322153X299X124517#1: N/A
322153X299X124518#0: N/A
322153X299X124518#1: N/A
322153X299X124519#0: N/A
322153X299X124519#1: N/A
322153X299X124520#0: N/A
322153X299X124520#1: N/A
322153X299X124521#0: N/A
322153X299X124521#1: N/A
322153X299X124522#0: N/A
322153X299X124522#1: N/A
322153X299X124523#0: N/A
322153X299X124523#1: N/A
322153X299X124524#0: N/A
322153X299X124524#1: N/A
322153X299X134317#0: N/A
322153X299X134317#1: N/A
322153X299X134318#0: N/A
322153X299X134318#1: N/A
322153X299X134319#0: N/A
322153X299X134319#1: N/A
322153X299X134320#0: N/A
322153X299X134320#1: N/A
322153X299X134321#0: N/A
322153X299X134321#1: N/A
322153X299X134322#0: N/A
322153X299X134322#1: N/A
322153X299X134323#0: N/A
322153X299X134323#1: N/A
322153X299X134324#0: N/A
322153X299X134324#1: N/A
322153X300X127825#0: N/A
322153X300X127825#1: N/A
322153X300X127826#0: N/A
322153X300X127826#1: N/A
322153X300X127827#0: N/A
322153X300X127827#1: N/A
322153X300X127828#0: N/A
322153X300X127828#1: N/A
322153X300X127829#0: N/A
322153X300X127829#1: N/A
322153X300X127830#0: N/A
322153X300X127830#1: N/A
322153X300X127831#0: N/A
322153X300X127831#1: N/A
322153X300X127832#0: N/A
322153X300X127832#1: N/A
322153X300X137525#0: N/A
322153X300X137525#1: N/A
322153X300X137526#0: N/A
322153X300X137526#1: N/A
322153X300X137527#0: N/A
322153X300X137527#1: N/A
322153X300X137528#0: N/A
322153X300X137528#1: N/A
322153X300X137530#0: N/A
322153X300X137530#1: N/A
322153X300X137531#0: N/A
322153X300X137531#1: N/A
322153X300X137532#0: N/A
322153X300X137532#1: N/A
322153X293X11221: N/A
322153X293X11222: N/A
322153X293X11223: N/A
322153X293X11811: N/A
322153X293X11812: N/A
322153X293X11813: N/A
322153X294X112633#0: N/A
322153X294X112633#1: N/A
322153X294X112634#0: N/A
322153X294X112634#1: N/A
322153X294X112635#0: N/A
322153X294X112635#1: N/A
322153X294X118533#0: N/A
322153X294X118533#1: N/A
322153X294X118534#0: N/A
322153X294X118534#1: N/A
322153X294X118535#0: N/A
322153X294X118535#1: N/A
322153X295X118801: N/A
322153X295X118802: N/A
322153X295X118803: N/A
322153X295X118804: N/A
322153X295X118805: N/A
322153X295X118806: N/A
322153X295X118807: N/A
322153X295X118808: N/A
322153X295X118809: N/A
322153X295X118810: N/A
322153X295X118811: N/A
322153X295X118812: N/A
322153X295X1202: N/A
322153X316X168201: N/A
322153X316X168202: N/A
322153X316X168203: N/A
322153X316X168204: N/A
322153X316X168205: N/A
322153X316X168206: N/A
322153X316X168207: N/A
322153X316X168208: N/A
322153X316X1695: N/A
322153X296X1454Test: N/A

CODE SQL QUI A ÉCHOUÉ:


UPDATE {{survey_322153}} SET `lastpage`=0, `322153X296X1696`=NULL, `322153X296X1454Test`=NULL, `322153X287X1008`=NULL WHERE ID=9

MESSAGE D’ERREUR:

LimeSUrvey version , multilingual survey , in update survey mode (during survey conception) ?

See www.limesurvey.org/forum/installation-a-...ing-newtest-y#148451 point 3

LM Version 2.51.4+160908
Survey is only in french.
Error has appeared while survey was active.

I don't understand the meaning of point 3 ?
"3. The survey 'column' (of DB) are in session : really , really bad (broke totally survey send)"

If you do some update during survey process : you session can be outdated. Then start the survey again with newtest/Y in url (just via admin part)(or totally close your browser) and see if you have the issue again

Thanks Denis! I will make more tests today.

Did you ever find a solution to this issue?
I am running version 2.06 and getting lots of these errors every day.
It is super annoying.

@all: What may cause this "Error saving results" error to show up randomly? My assumption is that it can only be related to server resources if for 90% of the submitted responses this works fine!?
Any hints or lessons learned?