Welcome to the LimeSurvey Community Forum

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

QuestionEditor doesn't load (several error in console)

  • santics
  • santics's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 1 month ago - 4 years 1 month ago #194079 by santics
Hi :cheer: ,

It is the first time I work with LimeSurvey. I installed it last week, therefore it's a clean installation, and after making a change in my 'PHP.ini' I got it to "work" under SQL Server.

I put "work" in quotes because I have some errors (save button doesn't appear on certain screens, the application is frozen when I try to see the list of questions in a survey, the QuestionEditor doesn't load, etc...) that don't let me use the application at all.

The error for which the list of questions was not shown was due to a bad SQL syntax that I solved by modifying the source code to stop using the word GROUP as a table name, because it's a keyword in T-SQL.

But the error for which the QuestionEditor is not shown is difficult for me to solve.

I've tried with all the internet browsers I know (Internet Explorer, Edge, Chrome, Firefox...). None of them shows the QuestionEditor.
I tried to update the version of LimeSurvey (4.1.5) but it hasn’t worked.

Every time I try to load the question editor, several errors/warning appear in the console:
1.- Warning: PJAX -> No JSON found. If you expected it there was an error (---> sometines appears, sometimes don't)
2.- Error: Uncaught SyntaxError: Unexpected token ';' (---> this one always appears)
When I click on the error link, this appears:
Code:
[]
<script>
    window.QuestionEditData = {"surveyid": []
    window.aStructureArray = ;
    window.aQuestionTypes = {"1":{"code":"1" []
</script>
[]
3.- Error: Uncaught CKEditorError: ckeditor-duplicated-modules: Some CKEditor 5 modules are duplicated. (--->sometimes appears, sometimes don't)

Do you think that all these errors I'm having are related to using SQL Server?
Should I use MySQL to avoid inconvenience?

Thank you so much :)

NOTE: In addition to not loading the question editor, the top Edit button is also not loaded
Attachment screenshot of errors and screen:
Last edit: 4 years 1 month ago by santics.
The topic has been locked.
  • santics
  • santics's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 1 month ago - 4 years 1 month ago #194081 by santics
My installation:
· Windows Server 2012
· Internet Information Services (IIS)
· PHP 7.2.11
· Sql Server 2012
· LimeSurvey 4.1.5
Last edit: 4 years 1 month ago by santics.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 1 month ago - 4 years 1 month ago #194108 by DenisChenu

santics wrote: My installation:
· Windows Server 2012
· Internet Information Services (IIS)
· PHP 7.2.11
· Sql Server 2012
· LimeSurvey 4.1.5

My opinion about SQL server + IIS and 4.X version ? Must use with care ...

Best solution :
Setup a LTS version : www.limesurvey.org/lts-releases-download for production

Keep the 4.X version to report issue : www.limesurvey.org/community/bug-tracker

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.
Last edit: 4 years 1 month ago by DenisChenu.
The following user(s) said Thank You: santics
The topic has been locked.
  • santics
  • santics's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 1 month ago #194113 by santics
ok, I'll try the LTS version. Although I would've liked to fix this mistake, if possible.

Thank you very much for your reply.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 1 month ago #194114 by DenisChenu

DenisChenu wrote: ....
Keep the 4.X version to report issue : www.limesurvey.org/community/bug-tracker

And if you already fix some issue about SQL : pull request are welcome.

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.
  • ollehar
  • ollehar's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
4 years 1 month ago #194226 by ollehar
In LS4, please enable debug = 2 in application/config/config.php and try again. Paste the entire error message here. You can also check the response from each Ajax quest in the network tab.
The topic has been locked.
  • santics
  • santics's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 1 month ago #194229 by santics
Hi ollehar,
I already installed the LTS version, it works perfect, so I'll work with this version.

Thank you very much for your help

Anyway before that I tried to change debug to 2 in config.php and I didn't get any new error message.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 1 month ago #194236 by DenisChenu
@santics : if you don't report nthe issue : we can not fix it.
Then when 3.X are deprecated or you need a 4.X function : it's not ready.



You already write

The error for which the list of questions was not shown was due to a bad SQL syntax that I solved by modifying the source code to stop using the word GROUP as a table name, because it's a keyword in T-SQL.

Dis this issue are reported ? Did this issue was fixed ?

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.
  • santics
  • santics's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 1 month ago #194244 by santics
You're right.

I just registered the bug:
bugs.limesurvey.org/view.php?id=15895
The topic has been locked.
  • ollehar
  • ollehar's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
4 years 1 month ago #194251 by ollehar
Thanks!
The topic has been locked.
More
3 years 9 months ago - 3 years 9 months ago #201394 by 8256583
Hello,

Just to say, we have the same problem with our installation updated from 2.x to 4.3
We can't downgrade now ?

We use xampp on windows server
Last edit: 3 years 9 months ago by 8256583.
The topic has been locked.
More
3 years 9 months ago #201415 by pakezonite
Hi,

I have just installed a fresh LS Version 4.3.0+200616 on Centos 7 with Nginx and PostgreSQL 12.

I'm experiencing similar problems where I cannot edit or create questions or question groups but I don't see any errors. Just the green animation (loading...).

Any advice to solve this is wellcome!
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose