Check out the LimeSurvey source code on GitHub!

Error: Couldn't get response data

More
5 years 10 months ago #57619 by DPajak
I am using Limesurvey Version 1.91RC2 Build 9672 and got the following error after exporting survey results to SPSS. After the export I am not able to open the results in "show answers" anymore.
Couldn't get response data
SELECT count(*) FROM `lime_survey_39369` submitdate IS NOT NULL
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 'IS NOT NULL' at line 1

I also got an similar error when I tried to delete an survey response before the export.

I already found a similar bug report under: bugs.limesurvey.org/print_bug_page.php?bug_id=4929

So does it makes any sense to upgrade to 1.91RC4 to solve the issue or shall I wait for RC5?

Please Log in to join the conversation.

More
5 years 10 months ago #57631 by DenisChenu

DPajak wrote: So does it makes any sense to upgrade to 1.91RC4 to solve the issue or shall I wait for RC5?

You don't have to use 91RC in production actually.

But if you want 1.91 came on week with less bug, please use the last RC version for bug report .

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

More
5 years 10 months ago #57633 by DPajak
It was a test survey where I found the bug. For my real survey I still use the last stable version.

I will give RC4 a try tomorrow, to see whether the problem is still there.

But since the problem is already in your bug tracker (as far as understand still unsolved), my actual question was whether it makes sense to wait for RC5 to test the issue again.

Please Log in to join the conversation.

More
5 years 10 months ago #57636 by DPajak
After some testing the update of browse.php to the version from RC4 solved my two problems.

See bugs.limesurvey.org/view.php?id=4894&nbn=3 for more information.

Tomorrow I will do some more testing of Version 1.91RC4 Build 9797.

Please Log in to join the conversation.

More
5 years 10 months ago #57655 by DenisChenu
Hello,

Thanks i put a relationship betwwen the 2 bug, maybe it can be solved now :)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

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