Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Help: trying to output results to pdf and getting sql error

Help: trying to output results to pdf and getting sql error 5 years 4 weeks ago #69056

I'm clicking on the pie chart, and then clicking generate pdf, excel, html, whatever, they all come back at me with the same error msg:
Couldn't get results
SELECT count(*) FROM `lime_survey_32399` WHERE 9X1X7` IN ('A1', 'A2', 'A3', 'A4', 'A5', 'A6', 'A7', 'A8', 'A9', '10')
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 '` IN ('A1', 'A2', 'A3', 'A4', 'A5', 'A6', 'A7', 'A8', 'A9', '10')' at line 1
The administrator has disabled public write access.

Help: trying to output results to pdf and getting sql error 5 years 4 weeks ago #69058

anybody got any suggestions?
The administrator has disabled public write access.

Help: trying to output results to pdf and getting sql error 5 years 4 weeks ago #69062

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 6029
  • Thank you received: 373
  • Karma: 260
1. Which Limesurvey version do you use?

2. Can you reproduce the problem with each survey?

3. Can you break this down to a certain question by limiting the analysis to single questions?

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"
The administrator has disabled public write access.

Help: trying to output results to pdf and getting sql error 5 years 4 weeks ago #69075

Mazi wrote:
1. Which Limesurvey version do you use?

2. Can you reproduce the problem with each survey?

3. Can you break this down to a certain question by limiting the analysis to single questions?

It seems to have magically fixed itself when I tried it today!
The administrator has disabled public write access.

Help: trying to output results to pdf and getting sql error 5 years 4 weeks ago #69077

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 6029
  • Thank you received: 373
  • Karma: 260
Great ;-)

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"
The administrator has disabled public write access.
Time to create page: 0.209 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form