Error saving results

More
10 months 1 week ago #148291 by sanjeev
sanjeev created the topic: Error saving results
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
Attachments:

Please Log in to join the conversation.

More
10 months 1 week ago #148293 by olle
olle replied the topic: Error saving results
What's the error message? Or is the message blank after "ERROR MESSAGE:"?

Please Log in to join the conversation.

More
10 months 1 week ago #148295 by sanjeev
sanjeev replied the topic: Error saving results
SQL CODE THAT FAILED and error subject is "Error saving results"

Please Log in to join the conversation.

More
10 months 1 week ago #148302 by DenisChenu
DenisChenu replied the 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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
10 months 6 days ago #148468 by RTOPS
RTOPS replied the 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:

Please Log in to join the conversation.

More
10 months 6 days ago #148470 by DenisChenu
DenisChenu replied the 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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
10 months 6 days ago #148471 by RTOPS
RTOPS replied the 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)"

Please Log in to join the conversation.

More
10 months 6 days ago #148477 by DenisChenu
DenisChenu replied the 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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
10 months 6 days ago #148478 by RTOPS
RTOPS replied the topic: Error saving results
Thanks Denis! I will make more tests today.

Please Log in to join the conversation.

More
1 month 2 weeks ago #160162 by AndyPTC
AndyPTC replied the 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.

Please Log in to join the conversation.

More
1 month 2 weeks ago #160164 by Mazi
Mazi replied the 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
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!