Welcome, Guest
Username: Password: Remember me

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

Help: trying to output results to pdf and getting sql error 2 years 11 months 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.

Re: Help: trying to output results to pdf and getting sql error 2 years 11 months ago #69058

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

Re: Help: trying to output results to pdf and getting sql error 2 years 11 months ago #69062

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5349
  • Thank you received: 299
  • Karma: 250
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)limesurvey.org'"
The administrator has disabled public write access.

Re: Help: trying to output results to pdf and getting sql error 2 years 11 months 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.

Re: Help: trying to output results to pdf and getting sql error 2 years 11 months ago #69077

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5349
  • Thank you received: 299
  • Karma: 250
Great ;-)

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.100 seconds
Donation Image