View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
17757Bug reportsSurvey editingpublic2021-11-24 16:14
Reportermhladun Assigned Togalads  
PrioritynoneSeverityminor 
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
BrowserBrave/Chrome
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.

Activities

mhladun

mhladun

2021-11-23 19:50

reporter  

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

galads

2021-11-24 09:51

administrator   ~67528

Hello,

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..
mhladun

mhladun

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.
galads

galads

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.
mhladun

mhladun

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