Welcome to the LimeSurvey Community Forum

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

Column not found: 1054 Unknown column 'question.language' in 'where clause'

  • netikja
  • netikja's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 1 month ago #223242 by netikja
Please help us help you and fill where relevant:
Your LimeSurvey version:  5.2.7+211221
Own server or LimeSurvey hosting: own
Theme: custom
==================
Hi,

I have just updated LimeSurvey from old 3.x.x version (cannot remember, possibly 3.17) to up-to-date  5.2.7+211221 and now when participant tries to submit his or her response, an internal error occurs. It is related to missing column "question.language" somewhere on the database side (see the attachment).

The thing is that I don't have an access to the MySQL, so I cannot provide more details now.

Many thanks!
 
The topic has been locked.
  • netikja
  • netikja's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 1 month ago #223243 by netikja
EDIT: I have now full access to both FTP and MySQL. However, a log of SQL queries seems to be unavailable.
The topic has been locked.
More
3 years 1 month ago #223244 by jelo
The is normally no logfile of SQL queries.

Since you already submitted a bugreport the link to the ticket might help others too.
bugs.limesurvey.org/view.php?id=17820

The issue has been mentioned before. I recommend to check if the response is saved and check if certain plugins cause the problem.

forums.limesurvey.org/forum/installation...2s22?start=15#219786

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: netikja
The topic has been locked.
  • netikja
  • netikja's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 1 month ago - 3 years 1 month ago #223247 by netikja
Thank you very much! This was indeed the case of incompatible PDFreport plugin… I have updated the issue at LS BT. Sorry for duplicate, but the search algorithm somehow hidden it from me (I used exactly the same search query as is the title of the issue).
Last edit: 3 years 1 month ago by netikja. Reason: typo
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
3 years 1 month ago #223401 by DenisChenu
pdfReport old version are not disable when update ?

Else : it was updated and compatible now.
gitlab.com/SondagesPro/ExportAndStats/pdfReport

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose