- Posts: 168
- Thank you received: 2
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Deleting survey
- ymca
- Topic Author
- Offline
- Elite Member
Less
More
4 years 1 month ago #195863
by ymca
LS Version 4.2+
Deleting survey was created by ymca
Hi,
I've seen this:
manual.limesurvey.org/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?
I've seen this:
manual.limesurvey.org/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
- Away
- LimeSurvey Community Team
Less
More
- Posts: 12941
- Thank you received: 3979
4 years 4 weeks ago #195884
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
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
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
- Topic Author
- Offline
- Elite Member
Less
More
- Posts: 168
- Thank you received: 2
4 years 4 weeks ago #195894
by ymca
LS Version 4.2+
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?
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10109
- Thank you received: 3595
4 years 4 weeks ago #195899
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic Deleting survey
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
- Topic Author
- Offline
- Elite Member
Less
More
- Posts: 168
- Thank you received: 2
4 years 4 weeks ago #195918
by ymca
But it's not the problematic survey
LS Version 4.2+
Replied by ymca on topic Deleting survey
I get this:tpartner wrote: Configuration --> Check data integrity
- manual.limesurvey.org/Check_data_integrity
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
LS Version 4.2+
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11660
- Thank you received: 2742
4 years 4 weeks ago #195919
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
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.
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.
- ymca
- Topic Author
- Offline
- Elite Member
Less
More
- Posts: 168
- Thank you received: 2
4 years 4 weeks ago #195921
by ymca
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11660
- Thank you received: 2742
4 years 4 weeks ago - 4 years 4 weeks ago #195922
by holch
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.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
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.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Last edit: 4 years 4 weeks ago by holch.
The following user(s) said Thank You: ymca
The topic has been locked.