View Issue Details

This issue affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
20734Bug reportsOtherpublic2026-09-29 12:13
ReporterDenisChenu Assigned Totibor.pacalat  
PrioritynoneSeverityminor 
Status ready for code reviewResolutionopen 
Product Version7.4.x 
Summary20734: When DB have an issue unable to fix it
Description

If a survey is set as active== Y but the responses table are deleted or disappears (or any other error ) : no way to login and fix the issue.

Steps To Reproduce

Steps to reproduce

Create a new survey,
Update the database : lime_surveys SET active = 'Y' WHERE lime_surveys.sid = 1; (1234 to be replaced by the real new sid
Go to survey listing

Expected result

See the survey list

Actual result

DB error and no way to go elsewhere

TagsNo tags attached.
Attached Files
Bug heat2
Complete LimeSurvey version number (& build)7.4.0
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionnot relevant
Server OS (if known)not relevant
Webserver software & version (if known)not relevant
PHP Versionnot relevant

Relationships

related to 20736 ready for code reviewDenisChenu Better difference between No response and not activated 
child of 19883 closedDenisChenu PHP 8.3 + debug : home page broken 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2026-09-28 18:24

developer   ~86075

Such survey cannot be deactivated

Error: Response table does not exist. Survey cannot be deactivated.

It's an issue too ..

DenisChenu

DenisChenu

2026-09-28 18:25

developer   ~86076

I'm unsure about decision :
Just set active=N ?

I think the best is to launch deactivation (the rename timings) but whet for tokens ?

DenisChenu

DenisChenu

2026-09-28 18:42

developer   ~86077

https://github.com/LimeSurvey/LimeSurvey/pull/5367

Issue History

Date Modified Username Field Change
2026-09-28 17:39 DenisChenu New Issue
2026-09-28 17:39 DenisChenu File Added: Capture d’écran du 2026-09-28 15-51-33.png
2026-09-28 17:39 DenisChenu File Added: Capture d’écran du 2026-09-28 17-34-58.png
2026-09-28 17:43 DenisChenu Assigned To => DenisChenu
2026-09-28 17:43 DenisChenu Status new => assigned
2026-09-28 17:47 DenisChenu Relationship added child of 19883
2026-09-28 18:24 DenisChenu Note Added: 86075
2026-09-28 18:24 DenisChenu File Added: Capture vidéo du 2026-09-28 18-23-23.mp4
2026-09-28 18:24 DenisChenu Bug heat 0 => 2
2026-09-28 18:25 DenisChenu Assigned To DenisChenu => tibor.pacalat
2026-09-28 18:25 DenisChenu Status assigned => ready for code review
2026-09-28 18:25 DenisChenu Note Added: 86076
2026-09-28 18:42 DenisChenu Note Added: 86077
2026-09-29 12:13 DenisChenu Relationship added related to 20736