Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Error saving results

  • sanjeev
  • sanjeev's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 1 month ago #148291 by sanjeev
Error saving results was created by sanjeev
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
The topic has been locked.
  • ollehar
  • ollehar's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
7 years 1 month ago #148293 by ollehar
Replied by ollehar on topic Error saving results
What's the error message? Or is the message blank after "ERROR MESSAGE:"?
The topic has been locked.
  • sanjeev
  • sanjeev's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 1 month ago #148295 by sanjeev
Replied by sanjeev on topic Error saving results
SQL CODE THAT FAILED and error subject is "Error saving results"
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 1 month ago #148302 by DenisChenu
Replied by DenisChenu on topic Error saving results
Please : limesurvey version

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

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
More
7 years 1 month ago #148468 by RTOPS
Replied by RTOPS on topic Error saving results
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:
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 1 month ago #148470 by DenisChenu
Replied by DenisChenu on topic Error saving results
LimeSUrvey version , multilingual survey , in update survey mode (during survey conception) ?

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

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
More
7 years 1 month ago #148471 by RTOPS
Replied by RTOPS on topic Error saving results
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)"
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 1 month ago #148477 by DenisChenu
Replied by DenisChenu on topic Error saving results
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

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
More
7 years 1 month ago #148478 by RTOPS
Replied by RTOPS on topic Error saving results
Thanks Denis! I will make more tests today.
The topic has been locked.
More
6 years 4 months ago #160162 by Marernon_25251
Replied by Marernon_25251 on topic Error saving results
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.
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
6 years 4 months ago #160164 by Mazi
Replied by Mazi on topic Error saving results
@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?

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose