Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Data Disappeared

  • prajwaldk
  • prajwaldk's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 4 months ago #128393 by prajwaldk
Data Disappeared was created by prajwaldk
My data for the last 2 years has disappeared. I have not upgraded or changed the survey in anyway. How can I retrieve this data?
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
8 years 4 months ago #128395 by LouisGac
Replied by LouisGac on topic Data Disappeared
can you please provide us more info ?
which version of limesurvey are you using ? what kind of server ? What do you mean by "disappeared" ?
The topic has been locked.
  • prajwaldk
  • prajwaldk's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 4 months ago #128398 by prajwaldk
Replied by prajwaldk on topic Data Disappeared
The version is 1.92+
What I mean when I say disappeared is: All the responses that were present for the survey for the last 2 years were available until last month. Now, only 7 responses from this month are present in the database.
It is on Linux server
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
8 years 4 months ago #128399 by LouisGac
Replied by LouisGac on topic Data Disappeared
someone probably deactivated the survey and then activated it again. see:
manual.limesurvey.org/Closing_a_survey#H...survey_-_what_now.3F
The topic has been locked.
  • prajwaldk
  • prajwaldk's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 4 months ago #128400 by prajwaldk
Replied by prajwaldk on topic Data Disappeared
Yes, that has been done several times earlier also. Is there anyway of retreiving the data??
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
8 years 4 months ago #128401 by LouisGac
Replied by LouisGac on topic Data Disappeared
It is still in the database (the true database server, like MYSQL, or postgresql.. ).
It's a table like :
lime_old_survey_{id of your survey}_{ date }
The topic has been locked.
  • prajwaldk
  • prajwaldk's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 4 months ago #128402 by prajwaldk
Replied by prajwaldk on topic Data Disappeared
How can I retrieve these responses back to my survey?
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
8 years 4 months ago #128405 by LouisGac
Replied by LouisGac on topic Data Disappeared
see :
manual.limesurvey.org/Closing_a_survey#H...survey_-_what_now.3F

but it could remove your last answers. If you can't do it by yourself, consider buying the services of a limesurvey partner:
www.limesurvey.com/
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 4 months ago #128406 by holch
Replied by holch on topic Data Disappeared
Did you read the link that Louis was posting thoroughly?

manual.limesurvey.org/Closing_a_survey#H...survey_-_what_now.3F

Help! I accidentally deactivated my survey - what now?

If you closed your survey accidentally it is important that you don't change anything in the survey.
Then, and only then the following steps will work.
Activate your survey again
Go to the "Browse responses for this survey" menu.
Click at the "Import answers from a deactivated survey table" button.
Choose your source table.
Click at the "Import responses" button.


However, as your version of Limesurvey is ancient I can't tell if this feature already existed in "1.92"

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose