- Posts: 3
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Error saving surveys after using Comfort Update
- HSwebteam
- Topic Author
- Offline
- New Member
Less
More
5 years 3 months ago #178173
by HSwebteam
Error saving surveys after using Comfort Update was created by HSwebteam
Hello!
I am currently helping someone with their Limesurvey installation.
Last week I used comfort update to update the server and suddenly most surveys will no longer save correctly.
My client uses a few empty questions at the end of the survey as logs in case information in the survey is edited at a later moment. That whole questiongroup is hidden at the end of the survey, as those questions should never be filled out in the survey itself (they are for later data management).
But now every time we finish a survey we get an error message in the admin panel saying not all data could be saved, and an email with the following message:
I am sure the last (hidden) page is the problem. When I remove the entire hidden group there are no problems (apart from no longer having the log files). When I set the questionnaire to Format "all-in one" instead of "group by group" (in general settings) there are no problems either
I have tried every question in that group individually and every single one gives me the error, so I doubt it is an individual question that causes it. It really seems to be the group by itself.
Also: I exported the survey and imported it into another Limesurvey (that was not Comfort Updated recently). There are questionnaires of a similar structure there that do not bug, but this one keeps bugging.
Did Comfort Update change something in the questionnaires themselves?
Does anyone have any idea what might be happening here?
I am currently helping someone with their Limesurvey installation.
Last week I used comfort update to update the server and suddenly most surveys will no longer save correctly.
My client uses a few empty questions at the end of the survey as logs in case information in the survey is edited at a later moment. That whole questiongroup is hidden at the end of the survey, as those questions should never be filled out in the survey itself (they are for later data management).
But now every time we finish a survey we get an error message in the admin panel saying not all data could be saved, and an email with the following message:
SQL CODE THAT FAILED:
UPDATE {{survey_921358}} SET `lastpage`, `datestamp`='2018-12-11 15:15:38', `ipaddr`='131.211.87.222', `921358X10X135`=NULL, `921358X10X136`=NULL, `921358X10X137`=NULL, `921358X10X138`=NULL, `921358X10X132Ta`=NULL, `921358X10X132Inh`=NULL, `921358X10X132Ns`=NULL, `921358X10X132IV`=NULL, `921358X10X132Ch`=NULL, `921358X10X132Cb`=NULL, `921358X10X132other`=NULL, `921358X10X133`=NULL WHERE ID=24
ERROR MESSAGE:
I am sure the last (hidden) page is the problem. When I remove the entire hidden group there are no problems (apart from no longer having the log files). When I set the questionnaire to Format "all-in one" instead of "group by group" (in general settings) there are no problems either
I have tried every question in that group individually and every single one gives me the error, so I doubt it is an individual question that causes it. It really seems to be the group by itself.
Also: I exported the survey and imported it into another Limesurvey (that was not Comfort Updated recently). There are questionnaires of a similar structure there that do not bug, but this one keeps bugging.
Did Comfort Update change something in the questionnaires themselves?
Does anyone have any idea what might be happening here?
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11758
- Thank you received: 2753
5 years 3 months ago #178174
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Error saving surveys after using Comfort Update
Basic information missing: Update from which version to which version?
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- HSwebteam
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
5 years 3 months ago #178176
by HSwebteam
Replied by HSwebteam on topic Error saving surveys after using Comfort Update
Old version, not sure, probably Version 2.58.0+170104
New version: Version 3.15.5+181115
New version: Version 3.15.5+181115
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11758
- Thank you received: 2753
5 years 3 months ago #178179
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Error saving surveys after using Comfort Update
So a version upgrade, not just a small update.
Maybe the database structure has changed somehow.
Sometimes it helps to export the survey and import it again. Worth a shot.
Maybe the database structure has changed somehow.
Sometimes it helps to export the survey and import it again. Worth a shot.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- LouisGac
- Visitor
5 years 3 months ago #178180
by LouisGac
Replied by LouisGac on topic Error saving surveys after using Comfort Update
what is the error message? You cut it.
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10634
- Thank you received: 3698
5 years 3 months ago #178186
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic Error saving surveys after using Comfort Update
Try disabling AJAX in the survey theme options.When I set the questionnaire to Format "all-in one" instead of "group by group" (in general settings) there are no problems either
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
- HSwebteam
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
5 years 3 months ago #178262
by HSwebteam
No I did not, there is no error message. Every mail leaves it blank.
I did not realise at the time how big the difference was between the versions, so maybe in between there something got changed drastically enough to corrupt this survey.
I tried importing and exporting it, but it takes the error with it
Replied by HSwebteam on topic Error saving surveys after using Comfort Update
LouisGac wrote: what is the error message? You cut it.
No I did not, there is no error message. Every mail leaves it blank.
I did not realise at the time how big the difference was between the versions, so maybe in between there something got changed drastically enough to corrupt this survey.
I tried importing and exporting it, but it takes the error with it
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
5 years 3 months ago #178266
by DenisChenu
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.
Replied by DenisChenu on topic Error saving surveys after using Comfort Update
If the survey is not so big, and export/import in your instance show the same issue : maybe you can send it at our bug report (mantis).
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.