Welcome, Guest
Username: Password: Remember me

TOPIC: Array type question not saving any data!!

Array type question not saving any data!! 3 years 9 months ago #53064

  • bluenatt
  • bluenatt's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
Hi, I´ve been using LimeSurvey for quite some time now, but never had this type of issues before.

It seems that the array type questions are not saving the answers. I have all those columns blank in my database.
This happens at random it seems, because for some of those questions the answers are saved.

Most of the time, when I have more than one array question type in the same group, it just saves the data from the first and leaves the rest blank.

I´ve tried setting all of these questions mandatory, but with the same result.

I don´t know what to do, I´ve lost 3 weeks of answered surveys because of this.

I´m using the latest build of version 1.90, the survey has about 760 questions, the database is on mysql.

I didn´t know if this was the correct forum to post this, I apologise if I posted it in the wrong place.

Nati.
The administrator has disabled public write access.

Re:Array type question not saving any data!! 3 years 9 months ago #53068

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2634
  • Thank you received: 309
  • Karma: 114
First of all: Wow! What are you guys doing. There are so many people with enormous questionnaires. I just can't believe anyone is willing to fill in a 760 question "monster".

Now let's try to get to the point and try to fix this. When you say the "rest is blank", how do you check that? Does it appear in the back end only, or also when you export the data? Maybe you can have a look at the MySQL-Database and see, if the data is saved there at least?

By the way: with some database engines 760 questions (which means a lot more columns of course) can be already too much (see documentation, e.g. MySQL InnoDB: Maximum number of 1000 columns).

But in your case the columns are there, just not filled, so the above limit seems not the problem.

Can you export a file with the results? You can delete all lines, but one, maybe? You could also file a bug report and make it private, so you can upload for example the exported survey and maybe a results file, and anything that can help to find the problem.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re:Array type question not saving any data!! 3 years 9 months ago #53069

  • bluenatt
  • bluenatt's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
An Update on the issue.

I have the questions group by group. Let´s say that on the first group, I have 2 array type questions, among others...

When I answer that first group, all of the answers from all of the questions are saved OK in the database.
Then I answer the 2nd group and when I go to the 3rd group (meaning that the 2nd group its being saved on the database), I loose the answers on the 1st group, starting from the 2nd array question to the end of the group.

I really don´t know what to do, It´s so weird, never happened to me before...

I´ve tried moving the survey to another server, removing the token-based persistance, making the survey anonymous, But so far, nothing has solved the issue.
Last Edit: 3 years 9 months ago by bluenatt.
The administrator has disabled public write access.

Re:Array type question not saving any data!! 3 years 9 months ago #53070

  • bluenatt
  • bluenatt's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
Ok, I´ll do that and post it here.
The administrator has disabled public write access.

Re:Array type question not saving any data!! 3 years 9 months ago #53072

  • bluenatt
  • bluenatt's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
I´ve opened a bug report: bugs.limesurvey.org/view.php?id=4766
Uploaded the survey structure and a couple of responses exported.
I hope it helps to solve the issue.
The administrator has disabled public write access.

Re:Array type question not saving any data!! 3 years 8 months ago #53174

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5324
  • Thank you received: 294
  • Karma: 248
Bug fixed. There will be a bugfix release this evening.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.116 seconds
Donation Image