Check out the LimeSurvey source code on GitHub!

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

More
5 years 3 months ago #69056 by nicolanicola
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

Please Log in to join the conversation.

More
5 years 3 months ago #69058 by nicolanicola
anybody got any suggestions?

Please Log in to join the conversation.

More
5 years 3 months ago #69062 by Mazi
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'"

Please Log in to join the conversation.

More
5 years 3 months ago #69075 by nicolanicola

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!

Please Log in to join the conversation.

More
5 years 3 months ago #69077 by Mazi
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'"

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form