View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
20734Bug reportsOtherpublic2026-10-20 17:06
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
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 heat4
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
Git branch / Pull Request URLhttps://github.com/LimeSurvey/LimeSurvey/pull/5367

Relationships

related to 20736 closedc_schmitz 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

DenisChenu

DenisChenu

2026-10-20 14:13

developer   ~86555

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=40935

LimeBot

LimeBot

2026-10-20 17:06

administrator   ~86572

Fixed in Release 7.7.0+261020

Related Changesets

LimeSurvey: master b11acb95

2026-10-20 14:13

DenisChenu

Committer: GitHub


Details Diff
Fixed issue 20734: When DB has an issue, user is unable to fix it (05367) Affected Issues
20734
mod - application/controllers/SurveyAdministrationController.php Diff File
mod - application/libraries/Api/Command/V1/SurveyDetail.php Diff File
mod - application/libraries/Api/Command/V1/Transformer/Output/TransformerOutputSurveyDetail.php Diff File
mod - application/libraries/Api/Command/V1/UserDetail.php Diff File
mod - application/libraries/Api/Rest/V1/SchemaFactory/SchemaFactorySurveyDetail.php Diff File
mod - application/libraries/Api/Rest/V1/SchemaFactory/SchemaFactoryUser.php Diff File
mod - application/models/Survey.php Diff File
mod - application/models/services/SurveyDeactivate.php Diff File
mod - application/views/surveyAdministration/afterDeactivateSurvey_view.php Diff File
mv - editor/build/static/css/index.d43a05bd.css → editor/build/static/css/index.32ce4e52.css Diff File
rm - editor/build/static/js/index.519b29bf.js Diff
add - editor/build/static/js/index.81b3c08b.js Diff File
mod - editor/index.html Diff File
mod - editor/src/components/PublishSettings/SurveyActivationHandler.js Diff File
add - editor/src/components/SurveyDatabaseAlert/SurveyDatabaseAlert.js Diff File
add - editor/src/components/SurveyDatabaseAlert/SurveyDatabaseToastOptions.js Diff File
add - editor/src/components/SurveyDatabaseAlert/index.js Diff File
mod - editor/src/components/SurveyOverview/SurveyOverview.js Diff File
mod - editor/src/components/index.js Diff File
mod - editor/src/hooks/useStatisticsAtGlance.js Diff File
mod - editor/src/pages/Editor/Editor.js Diff File
mod - editor/src/themes/alert/alert.scss Diff File

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 Git branch / Pull Request URL N/A => https://github.com/LimeSurvey/LimeSurvey/pull/5367
2026-09-28 18:42 DenisChenu Note Added: 86077
2026-09-29 12:13 DenisChenu Relationship added related to 20736
2026-10-20 14:13 DenisChenu Changeset attached => LimeSurvey master b11acb95
2026-10-20 14:13 DenisChenu Note Added: 86555
2026-10-20 14:13 DenisChenu Assigned To tibor.pacalat => DenisChenu
2026-10-20 14:13 DenisChenu Status ready for code review => resolved
2026-10-20 14:13 DenisChenu Resolution open => fixed
2026-10-20 17:06 LimeBot Note Added: 86572
2026-10-20 17:06 LimeBot Status resolved => closed
2026-10-20 17:06 LimeBot Bug heat 2 => 4