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

TOPIC: Help! Deactivated Survey

Help! Deactivated Survey 3 years 5 months ago #94632

  • divyen90
  • divyen90's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
Hi,
So I deactivated my survey and now need to get the answers back, I have followed the procedure here: docs.limesurvey.org/Closing+a+survey&str...y_survey_-_what_now_

But when I try to import my data, I get the error:
Error:
INSERT into lime_survey_41573
<values go in here>
ERROR: invalid input syntax for type timestamp: ""

I think it's trying to insert my incomplete survey answers but it won't accept empty timestamps in the database. It only imports the first 10 responses out of 200, is there anyway I can get it to import all the data?

Many Thanks!

Edit: The survey has not been edited in any way since being deactivated, could I somehow just rename the old table on the back end?
Last Edit: 3 years 5 months ago by divyen90.
The administrator has disabled public write access.
Time to create page: 0.241 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form