Back to limesurvey.org

Welcome to the LimeSurvey Community Forum

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

Deleting survey

  • ymca
  • ymca's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
5 years 2 months ago #195863 by ymca
Deleting survey was created by ymca
Hi,

I've seen this:
www.limesurvey.org/manual/Delete_survey

So when I delete a survey, its responses will be deleted after some time automatically so I won't need to delete them manually?
LS Version 4.2+
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 2 months ago #195884 by Joffm
Replied by Joffm on topic Deleting survey
If your LS installation is self hosted, the survey and the answer table are deleted immediately.
But manually you have to delete the "old" answer tables lime_old_survey_{SID}_{datetime}, which are created while deactivating a survey.

This
Attention :

We highly recommend our users to export the survey and its corresponding responses table before deleting it.
The responses table is getting archived and it can still be recovered for a limited period of time. However, for the sake of simplicity and to avoid further import-related complications, we recommend our users to also backup the responses table.

seems to refer to people with a LimeSurvey GmbH hosted installation.

Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • ymca
  • ymca's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
5 years 2 months ago #195894 by ymca
Replied by ymca on topic Deleting survey
:ohmy:
Is there a button that does this or do I need to go somewhere in "phpMyAdmin" every time I delete a survey and delete it from there?
LS Version 4.2+
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 2 months ago #195899 by tpartner
Replied by tpartner on topic Deleting survey
Configuration --> Check data integrity

- www.limesurvey.org/manual/Check_data_integrity
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
  • ymca
  • ymca's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
5 years 2 months ago #195918 by ymca
Replied by ymca on topic Deleting survey

tpartner wrote: Configuration --> Check data integrity

- www.limesurvey.org/manual/Check_data_integrity

I get this:
Code:
The following surveys have an errorneous question order. Please go to each question and group respectively, check the question order and save it.
SID: 971159 GID: 13 Parent QID: 1018
SID: 971159 GID: 18 Parent QID: 1072
But it's not the problematic survey
LS Version 4.2+
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 2 months ago #195919 by holch
Replied by holch on topic Deleting survey
Did you deactivate and activate the survey at any time? If not, then there are no response tables archived and deleting the survey will delete everything that has to do with this survey and then the Data Integrity Check will not find any archived response tables.
Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
  • ymca
  • ymca's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
5 years 2 months ago #195921 by ymca
Replied by ymca on topic Deleting survey
Yes it was activated.
LS Version 4.2+
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 2 months ago - 5 years 2 months ago #195922 by holch
Replied by holch on topic Deleting survey

Yes it was activated.


Of course it was activated, because otherwise there would be no response table at all. However, the issue is only arising if a responsetable has been archived, after deactiving an active survey.

So if it was active, but has never been deactivated, there is no archived response table.

The "deactivating" part is what creates archived response tables. Non archived responsetables should be deleted when the survey is deleted.
Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
Last edit: 5 years 2 months ago by holch.
The following user(s) said Thank You: ymca
The topic has been locked.
Moderators: tpartner, holch

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source