Welcome to the LimeSurvey Community Forum

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

mySQL error message in activated survey

  • flink
  • flink's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 10 months ago #119872 by flink
Dear forum members,

I'm encountering the following error message when I try to submit an answer:

Unknown column '87948X1163X17329' in 'field list':UPDATE lime_survey_87948 SET `lastpage`='3', `datestamp`='2015-05-03 18:46:32', `ipaddr`='92.72.144.11', `87948X1163X17329`='' WHERE ID=44714

Interestingly, the error occurs only when the survey is activated. In deactivated mode, everything works just fine.

I am using Version 1.92+ Build 120919

Does anyone know how to solve this?

Thank you very much!
The topic has been locked.
More
8 years 10 months ago #119873 by Bigred01
Replied by Bigred01 on topic mySQL error message in activated survey
It looks like your responses table is missing a column for a question. It will work while offline since lime doesn't use a responses table while offline. Did you add a question then rename a backup table to be your current table?
The topic has been locked.
  • flink
  • flink's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 10 months ago #119874 by flink
Replied by flink on topic mySQL error message in activated survey
No, I did not rename any backup tables. Putting the survey offline and online again also does not work to solve the problem.
The topic has been locked.
  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
8 years 10 months ago #119876 by tammo
Replied by tammo on topic mySQL error message in activated survey
I would try to copy the survey and import it and see if you encounter the error message on the copy...

Tammo


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The following user(s) said Thank You: flink
The topic has been locked.
  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
8 years 10 months ago #119877 by tammo
Replied by tammo on topic mySQL error message in activated survey
BTW: you are working with a LimeSurvey built from 2012! Would it be possible to update? This might also help...


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The following user(s) said Thank You: holch
The topic has been locked.
  • flink
  • flink's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 10 months ago #119882 by flink
Replied by flink on topic mySQL error message in activated survey
Hey tammo, thanks for your advice, this actually solved the issue. Hope it is stable now.
The topic has been locked.
  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
8 years 10 months ago #119885 by tammo
Replied by tammo on topic mySQL error message in activated survey
What solved the issue? Updating or copying?

Just curious...

Tammo


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
  • flink
  • flink's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 10 months ago #119886 by flink
Replied by flink on topic mySQL error message in activated survey
Copying. But you're right, I should consider updating some day.. ;)
The following user(s) said Thank You: tammo
The topic has been locked.
  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
8 years 10 months ago #119889 by tammo
Replied by tammo on topic mySQL error message in activated survey
Yes, the LimeSurvey world did develop since 2012!


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose