Welcome, Guest
Username: Password: Remember me

TOPIC: SQL error when trying to view survey results

SQL error when trying to view survey results 2 years 11 months ago #65173

Hi! I'm getting this error when trying to view survey results:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND language='en'' at line 1:SELECT type, lid, lid1 FROM `lime_questions` WHERE qid= AND language='en'

This happens when going into a survey > Browse Responses > Display Responses > clicking on any of the IDs for the responses listed. I can click on the token and see the details of the person who answered the survey just fine - but not their answers! Any ideas? This is a critical issue for me. :(
The administrator has disabled public write access.

Re: SQL error when trying to view survey results 2 years 11 months ago #65269

Anyone? Please?

This works fine for all other Surveys in my installation, just not for this one particular one. I have 5 surveys in total, 1-4 I can browse the responses just fine for, only 5 gives the SQL error. Coincidentally, 5 is an imported copy of 4, renamed and some of the questions changed. Could that have something to do with it?

Please, if anyone can help, I'd soo appreciate it! :(
The administrator has disabled public write access.

Re: SQL error when trying to view survey results 2 years 11 months ago #65396

Bump - anyone? I need to be able to browse/see the reponses to this survey! :(
The administrator has disabled public write access.

Re: SQL error when trying to view survey results 2 years 10 months ago #67111

Bump - anyone? This is a serious issue - we can't view ANY of the responses!
The administrator has disabled public write access.

Re: SQL error when trying to view survey results 2 years 10 months ago #67112

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 753
  • Thank you received: 104
  • Karma: 87
Looks like you are using an old version. How about updating to the latest version and see if the issue will be gone?
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.

Re: SQL error when trying to view survey results 2 years 10 months ago #67117

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5324
  • Thank you received: 293
  • Karma: 248
1. Which Limesurvey version do you use?

2. Does that problem show up with every survey?

3. Can you reproduce the problem when copying the survey?

4. You can test if this is fixed at the latest version by testing our online demo at demo.limesurvey.org/admin(external link) which always runs the latest Limesurvey version.
Username: admin
Password: test
If you can reproduce the problem there please report back.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.126 seconds
Donation Image