Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:
  • Page:
  • 1
  • 2

TOPIC: Unable to edit Question Groups or Questions

Unable to edit Question Groups or Questions 3 years 5 months ago #94101

  • itfixt
  • itfixt's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 14
  • Karma: 0
Apologies if this is posted in the wrong place but I don't think this is classed a a bug... yet.
LimeSurvey Version 2.00+ Build 130317
Ubuntu Linux 12.04.1
Apache 2.2.22
PHP Version 5.3.10-1ubuntu3.4
MySQL version 5.5.28

I have two surveys under the same username. One works perfectly. The other suddenly stopped allowing edits to Question Groups and Questions. I.e., if you click on the "Edit current question group" having selected one in the drop-down, the page refreshes but the area below the navigation bars stays empty. Examination of the HTML shows that the required data is missing, rather than just hidden. The behaviour with individual questions is identical. None of the following have made any difference:
  • Changing the admin style.
  • Cleared the browser cache and cookies after logging out, then logged back in.
  • Exported the survey then re-imported it again into a new, empty survey.
  • Exported an individual question then re-imported it again into a new, empty survey.

Exporting a Question Group and re-importing it into an empty survey restored the ability to edit the Group - but not the individual questions.
Having clicked the button to edit a Question, if I then delete the session cookie and refresh the page I have to log back in again, of course, and then the page appears correctly, with the editable question!!

I have tried this with both the latest LS build and the previous one. I even did a clean install of the previous build and imported the survey into that with precisely the same results.

I should add that this was all working perfectly and suddenly stopped for no apparent reason. Any suggestions (other than re-inputting the whole survey!) gratefully received.
This space accidentally left blank
The administrator has disabled public write access.

Unable to edit Question Groups or Questions 3 years 5 months ago #94104

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9305
  • Thank you received: 1330
  • Karma: 386
Hello,

Please set debug=2 in config.php to have more information.

Denis
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
The administrator has disabled public write access.

Unable to edit Question Groups or Questions 3 years 5 months ago #94107

  • itfixt
  • itfixt's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 14
  • Karma: 0
Thanks Denis. I had seen that debug setting in the config & then forgotten all about it :blush:

I tried it and when I tried to display the survey (choosing it from the drop-down), I get:
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 7589464 bytes) in /var/www/clients/client2/web70/web/ls2/application/helpers/expressions/em_manager_helper.php on line 6045

I don't get that on the other survey.

Cheers
Dave
This space accidentally left blank
The administrator has disabled public write access.

Unable to edit Question Groups or Questions 3 years 5 months ago #94112

  • holch
  • holch's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 5101
  • Thank you received: 756
  • Karma: 227
Well, seems like your questionnaire has reached a limit somewhere. Could it be that it is a very big questionnaire and makes a lot of use of the Expression Manager?
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.

Unable to edit Question Groups or Questions 3 years 5 months ago #94113

  • itfixt
  • itfixt's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 14
  • Karma: 0
holch wrote:
Well, seems like your questionnaire has reached a limit somewhere. Could it be that it is a very big questionnaire and makes a lot of use of the Expression Manager?

It's not that big - some 30 question groups, mostly each containing around 6 questions. And yet the Questions table in the DB has 3101 rows for the relevant survey.

Cheers,
Dave
This space accidentally left blank
The administrator has disabled public write access.

Unable to edit Question Groups or Questions 3 years 5 months ago #94114

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9305
  • Thank you received: 1330
  • Karma: 386
Did you have a lot of condition ?
Did you use array_filter and array_filter_exclusion a lot ?

6 question: but with or without sub question ?
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
The administrator has disabled public write access.

Unable to edit Question Groups or Questions 3 years 5 months ago #94118

  • itfixt
  • itfixt's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 14
  • Karma: 0
DenisChenu wrote:
Did you have a lot of condition ?
No.
DenisChenu wrote:
Did you use array_filter and array_filter_exclusion a lot ?
No.
DenisChenu wrote:
6 question: but with or without sub question ?
A few.

Structure is:

- Number of questions/groups: 154/22
- Two questions in each group, bar the first group, have 1 sub-question.
- Each group has several more questions with no sub-questions.
This space accidentally left blank
Last Edit: 3 years 5 months ago by itfixt. Reason: Left a bit out :(
The administrator has disabled public write access.

Unable to edit Question Groups or Questions 3 years 5 months ago #94120

  • itfixt
  • itfixt's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 14
  • Karma: 0
I just increased the max memory in php.ini to 384M & it all works now - but that 's obviously still not satisfactory behaviour :} Should I raise a bug report for this?
This space accidentally left blank
The administrator has disabled public write access.

Unable to edit Question Groups or Questions 3 years 5 months ago #94121

  • holch
  • holch's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 5101
  • Thank you received: 756
  • Karma: 227
What is strange is that you see to have 128MB (134217728 bytes) of memory, but 7-8MB are already too much. I am not an expert here but this sounds like there is something blocking a lot of the memory.
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.

Unable to edit Question Groups or Questions 3 years 5 months ago #94122

  • holch
  • holch's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 5101
  • Thank you received: 756
  • Karma: 227
I am not sure if the problem actually is limesurvey or something else on your server. 7-8MB of memory usage for a survey sound a lot to me, but then it is not a small survey. But I don't have any data for comparison.

What is strange is that basically 120MB of your allocated memory was already used by something else. What else is running on your webserver?
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.

Unable to edit Question Groups or Questions 3 years 5 months ago #94125

  • itfixt
  • itfixt's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 14
  • Karma: 0
The server has 2GB of RAM and there are a number of other sites running on it, none with high traffic.

This is typical:
Real memory 1.94 GB total, 756.31 MB used

It was the limit for this particular Apache virtual server that I changed - not the limit for everything. I am running PHP-FPM so each web site runs as a separate process with its own memory space. The default is 128MB.
This space accidentally left blank
The administrator has disabled public write access.

Unable to edit Question Groups or Questions 3 years 5 months ago #94127

  • holch
  • holch's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 5101
  • Thank you received: 756
  • Karma: 227
Well, then I find it strange that your instance of Limesurvey already uses 120MB, so that the 7-8MB of this process can't be processed anymore.

As I said, I am not an expert on this. So I think it makes sense that you make a bug report and add a copy of your survey (you can make it private, so no one besides the developers have access to it).

Please describe in detail the problem with the error message etc. so they can have a look at it. Because 128MB of memory should be enough for LS and the underlying webserver infrastructure, I think. But as I said, I am not an expert... ;-)
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.

Unable to edit Question Groups or Questions 3 years 5 months ago #94135

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9305
  • Thank you received: 1330
  • Karma: 386
holch wrote:
Please describe in detail the problem with the error message etc. so they can have a look at it. Because 128MB of memory should be enough for LS and the underlying webserver infrastructure, I think. But as I said, I am not an expert... ;-)
Not an expert too, but right, think this was a great idea to do a bug report : www.limesurvey.org/en/community-services/bug-tracker

Denis
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
The administrator has disabled public write access.

Unable to edit Question Groups or Questions 3 years 5 months ago #94138

  • itfixt
  • itfixt's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 14
  • Karma: 0
Agreed - it strikes me as odd that the memory use should be like that, even knowing little of LimeSurvey. That memory doesn't even include the webserver infrastructure - it is purely the PHP process running the script under the UID/GID of the file owner; Apache child processes are separate!

Anyway, I will raise a bug as you suggested with an export of the survey attached.

Many thanks to the people who answered me so quickly - very much appreciated. The survey was done by a client after I had "found" LS & set it up for them on my server - if I make any money out of this, there will be a donation to LS :)

Cheers
Dave
This space accidentally left blank
The administrator has disabled public write access.

Unable to edit Question Groups or Questions 3 years 5 months ago #94371

  • itfixt
  • itfixt's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 14
  • Karma: 0
Following on from the above, when trying to activate the survey, LS reports an error trying to create the table. The error is that there are too many columns. Not surprising as there are 5617 columns!

I've attached a file with the Create Table query in it and also a dump of the survey. I'm wondering if this is a limitation of LS itself - that it's not well suited to this type of survey - or if it's badly structured and refactoring it will avoid this problem. It is possible to increase the max columns but not by that much, so this is a show-stopper. The only other way I can see round this is persuading LS to use InnoDB instead of MyISAM but that may invoke the Law of Unintended Consequences :/

It just crossed my mind that if the previous issue *was* due to bug, then curing that will fix this issue too, but any constructive comments are welcome.

PS - I hadn't got round to filing the bug report yet due to family illness... but I will get it done this afternoon.
This space accidentally left blank
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.301 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form