20722: When check data integrity : if you have a old response table : it broke

This issue affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update
20722	Bug reports	Database design	public	2026-09-24 16:01	2026-11-01 21:11

Reporter	DenisChenu	Assigned To	c_schmitz
Priority	none	Severity	minor
Status	resolved	Resolution	fixed
Product Version	7.3.x

Summary	20722: When check data integrity : if you have a old response table : it broke
Description	When there are old response table data inetgrity result throiw a DB error
Steps To Reproduce	Steps to reproduce Create a survey Activate : answer Deactivate Activate : answer Deactivate Activate : answer Delete Go to Data integrity: see old_response, submit Expected result Action done Actual result Throw a CDB exception: old_questions didn't exist (and Go to Data integrity: see old_response and old_questins)
Tags	No tags attached.

Bug heat	4
Complete LimeSurvey version number (& build)	7.3.0
I will donate to the project if issue is resolved	No
Browser	not relevant
Database type & version	not relevant
Server OS (if known)	not relevant
Webserver software & version (if known)	not relevant
PHP Version	not relevant
Git branch / Pull Request URL	N/A

User List	There are no users monitoring this issue.

DenisChenu 2026-09-24 16:02 developer ~85968	@c_schmitz https://github.com/LimeSurvey/LimeSurvey/commit/768972a16c6ae2706597b0ec217eb651657a4e29#r201843677 I don't understand your commit here. (Maybe we need to add the old_survey existing table. I check and report another issue)

DenisChenu 2026-09-24 16:24 developer ~85969	Capture d’écran du 2026-09-24 15-52-26.png (36,236 bytes) Capture d’écran du 2026-09-24 15-52-26.png (36,236 bytes) Capture d’écran du 2026-09-24 15-52-33.png (36,903 bytes) Capture d’écran du 2026-09-24 15-52-33.png (36,903 bytes)

c_schmitz 2026-11-01 21:11 administrator ~87082	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=41233

LimeSurvey: master 515dc15f 2026-11-01 21:04 c_schmitz Details Diff	Fixed issue 20722: Check data integrity showed a "table does not exist" error when deleting the old tables of a deleted survey Dev An empty old_responses table and its old_questions table were both in orphansurveytables; the old_questions table was dropped together with the responses table and then again on its own (CDbException before 7.5.0, warning and exit code 1 of the checkintegrity command since then); dropOrphanSurveyTables() now skips it	Affected Issues 20722
	mod - application/models/DataIntegrityChecker.php	Diff File
	mod - tests/unit/controllers/CheckIntegrityTest.php	Diff File

Date Modified	Username	Field	Change
2026-09-24 16:01	DenisChenu	New Issue
2026-09-24 16:02	DenisChenu	Note Added: 85968
2026-09-24 16:02	DenisChenu	Bug heat	0 => 2
2026-09-24 16:23	DenisChenu	Summary	When check dta inetgety : if you have a old response table : it broke => When check data inetgety : if you have a old response table : it broke
2026-09-24 16:24	DenisChenu	Note Added: 85969
2026-09-24 16:24	DenisChenu	File Added: Capture d’écran du 2026-09-24 15-52-26.png
2026-09-24 16:24	DenisChenu	File Added: Capture d’écran du 2026-09-24 15-52-33.png
2026-09-24 16:24	DenisChenu	Summary	When check data inetgety : if you have a old response table : it broke => When check data integrity : if you have a old response table : it broke
2026-09-24 16:24	DenisChenu	Relationship added	related to 20723
2026-09-24 17:19	tibor.pacalat	Assigned To	=> c_schmitz
2026-09-24 17:19	tibor.pacalat	Status	new => confirmed
2026-11-01 21:11	c_schmitz	Changeset attached	=> LimeSurvey master 515dc15f
2026-11-01 21:11	c_schmitz	Note Added: 87082
2026-11-01 21:11	c_schmitz	Status	confirmed => resolved
2026-11-01 21:11	c_schmitz	Resolution	open => fixed
2026-11-01 21:11	c_schmitz	Bug heat	2 => 4