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
Description

After 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 Reproduce

Steps 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.
Attached Files
ls_error.png (47,657 bytes)   
ls_error.png (47,657 bytes)   
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

There are no users monitoring this issue.

Activities

galads

galads

2021-11-24 09:51

reporter   ~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

reporter   ~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 "limesurvey(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 limeold*, 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