Welcome to the LimeSurvey Community Forum

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

Problem after updating to LS 5.X

More
2 years 9 months ago #233908 by testumfrage123
Please help us help you and fill where relevant:
Your LimeSurvey version: 5.4.10
Own server or LimeSurvey hosting: own server
Survey theme/template: custom/fruity
==================

Hello,

I have just updated our Limesurvey version (from 3.X to 5.X). I used ComfortUpdate.
Now there is an error that always appears at the end of each survey after clicking "Submit". 

The error shows: 

500: Internal Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'question.language' in 'where clause'.


Nevertheless the answers are saved and the survey is set to Completed.
Does anyone know what is the reason for this? Would be really helpful :) 

Chris

Please Log in to join the conversation.

More
2 years 9 months ago #233910 by bismark
set debug mode = 2 and post the whole error screen when possible

Please Log in to join the conversation.

More
2 years 9 months ago #233912 by testumfrage123
Hi bismark,

I added a PDF of the error screen in debug mode=2. Hope this could help.

And I just tried it with another webspace and the same LS version. No problems here. So seems to be something specific with our installation/surveys and not with the limesurvey version?


 

Please Log in to join the conversation.

More
2 years 9 months ago #233913 by holch
Does this happen only with a specific survey or with all surveys?

If it is just with a specific survey, it could have to do with the survey itself. Copy the survey and check if the problem persists.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.

Please Log in to join the conversation.

More
2 years 9 months ago #233916 by testumfrage123
No, it happens to all surveys on this installation.
Just tried to add a new survey - same problem...

Please Log in to join the conversation.

More
2 years 9 months ago #233920 by tpartner

I used ComfortUpdate.

If you paid for ComfortUpdate you can contact LimeSurvey support directly.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
2 years 9 months ago #233926 by testumfrage123
We used the free trial, because it was our first bigger update.
Is it still possible to contact the support?

Please Log in to join the conversation.

More
2 years 9 months ago #233929 by bismark
For me it seems that the plugin pdfReport causes the problems. LS3 != LS5. database schema has changed. deactivate the plugin.
The following user(s) said Thank You: testumfrage123

Please Log in to join the conversation.

More
2 years 9 months ago #233930 by holch

We used the free trial, because it was our first bigger update.
Is it still possible to contact the support?


Not sure. Most of us here in the forum are volunteers (users helping users) and we have no insight into the internal processes of the Limesurvey GmbH.

But to be honest, I don't think that they are too overly enthusiastic do provide professional support to non-clients. Maybe they see you as a "pontential client" as a users of the free trial. You can always try.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The following user(s) said Thank You: testumfrage123

Please Log in to join the conversation.

More
2 years 9 months ago #233936 by testumfrage123
Thank you all!
The problem seems to be caused by the plugin. When I deactivated that, it worked. Fortunately, there is already a newer version for this plugin that is compatible with LS 5.X. I was able to reinstall this version and we can now use the plugin & get no more error message :) 

Thanks a lot. And sorry if it was stupid questions - don't know much about codes and stuff...

Please Log in to join the conversation.

Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose