The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username?
  • Page:
  • 1

TOPIC: Error: Couldn't get response data

Error: Couldn't get response data 2 years 2 months ago #57619

  • DPajak
  • DPajak's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 15
  • Karma: 0
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?
The administrator has disabled public write access.

Re: Error: Couldn't get response data 2 years 2 months ago #57631

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 4409
  • Thank you received: 455
  • Karma: 166
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 .
The administrator has disabled public write access.

Aw: Re: Error: Couldn't get response data 2 years 2 months ago #57633

  • DPajak
  • DPajak's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 15
  • Karma: 0
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.
The administrator has disabled public write access.

Aw: Re: Error: Couldn't get response data 2 years 2 months ago #57636

  • DPajak
  • DPajak's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 15
  • Karma: 0
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.
The administrator has disabled public write access.

Re: Aw: Re: Error: Couldn't get response data 2 years 2 months ago #57655

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 4409
  • Thank you received: 455
  • Karma: 166
Hello,

Thanks i put a relationship betwwen the 2 bug, maybe it can be solved now :)
The administrator has disabled public write access.
  • Page:
  • 1
Moderators: DenisChenu, ITEd
Time to create page: 0.229 seconds
Donation Image