View Issue Details

This bug affects 1 person(s).
IDProjectCategoryView StatusLast Update
17757Bug reportsSurvey editingpublic2021-11-24 16:14
Reportermhladun Assigned Togalads  
Status assignedResolutionopen 
Product Version5.2.x 
Summary17757: Deactivating a Survey - List of Surveys Not Accessible
DescriptionAfter deactivating an active survey, and attempting to visit the list of existing surveys, the following error is raised (see screenshot).

I noticed this issue is fixed when visiting the data integrity page. There is a notification message saying some automatic changes were made. So it seems like a procedure that runs when first visiting the data integrity page needs to be run when clicking deactivate survey.
Steps To ReproduceSteps to reproduce
Deactivate an active survey.
Go to the list of surveys at limesurvey/index.php?r=surveyAdministration/listsurveys

Expected result
The list of existing surveys is displayed.

Actual result
The error page seen the attached screenshot is displayed.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)5.2.2+211115
I will donate to the project if issue is resolvedNo
Database type & versionPostgresql/EnterpriseDB 10.9.17
Server OS (if known)Windows Server 2019 Datacenter
Webserver software & version (if known)nginx 1.20.1/php-cgi
PHP Version8.0.12

Users monitoring this issue

User List There are no users monitoring this issue.




2021-11-23 19:50


ls_error.png (47,657 bytes)   
ls_error.png (47,657 bytes)   


2021-11-24 09:51

administrator   ~67528


I cannot reproduce this error. From the error message in the screenshot, it seems you deleted the survey from the DB. Check if the survey "lime_survey_297654" is in the DB..


2021-11-24 15:39

reporter   ~67536

It doesn't get deleted, instead it gets renamed to something like lime_old_survey_297654_20211123192058 and LS throws and error saying it expects lime_survey_297654 to exist.


2021-11-24 15:59

administrator   ~67537

I know it gets renamed to lime_old_survey_297654_20211123192058 for example. Clicking on the survey list does not search for the deactivated surveys with the "old" included in the name. It searches for the columns with "lime_survey_(survey_ID)". In your case, the survey with ID 297654 is not in the database I assume.


2021-11-24 16:14

reporter   ~67538

Correct, it is not in the database because it was renamed to lime_old_*, as expected.

The bug is when clicking deactivate, the survey remains "active" until the data integrity page is visited.

1. I start a survey
2. I deactivate it
3. "Stop this survey" is still being show, and the "Active surveys" in the nav banner is still 1 count too high. If I click "Stop this survey", the notification "Error: Repsonse table does not exist. Survey cannot be deactivated" is shown.
4. I visit */checkintegrity and "Some automatic fixed were already applied" appears. The "Active surveys" decreases by 1 (to the correct count) and the "Stop this survey" button becomes "Activate survey" as expected, but only after visiting */checkintegrity.
image.png (15,328 bytes)   
image.png (15,328 bytes)   
image-2.png (15,202 bytes)   
image-2.png (15,202 bytes)   
image-3.png (21,237 bytes)   
image-3.png (21,237 bytes)   

Issue History

Date Modified Username Field Change
2021-11-23 19:50 mhladun New Issue
2021-11-23 19:50 mhladun File Added: ls_error.png
2021-11-24 09:51 galads Note Added: 67528
2021-11-24 09:51 galads Bug heat 0 => 2
2021-11-24 09:51 galads Assigned To => galads
2021-11-24 09:51 galads Status new => feedback
2021-11-24 15:39 mhladun Note Added: 67536
2021-11-24 15:39 mhladun Bug heat 2 => 4
2021-11-24 15:39 mhladun Status feedback => assigned
2021-11-24 15:59 galads Note Added: 67537
2021-11-24 16:14 mhladun Note Added: 67538
2021-11-24 16:14 mhladun File Added: image.png
2021-11-24 16:14 mhladun File Added: image-2.png
2021-11-24 16:14 mhladun File Added: image-3.png