View Issue Details

Related ChangesetsJump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
20820Bug reportsSurvey takingpublic2026-11-05 17:512026-11-06 10:56
Reporterxastrefernando Assigned Toc_schmitz  
PrioritynoneSeveritycrash 
Status assignedResolutionreopened 
Product Version7.7.x 
Summary20820: HTTP 500 error when quota_exit is triggered in surveys migrated from LimeSurvey 5.6.x to 7.x
Description

After migrating from LimeSurvey 5.6.x to LimeSurvey 7.x, some migrated surveys return an HTTP 500 Internal Server Error when a quota is reached and quota_exit is triggered.

The survey works normally until the quota condition is reached.

When the quota is triggered, instead of displaying the configured quota exit message/page, LimeSurvey returns an HTTP 500 Internal Server Error.

The issue appears to affect surveys migrated from LimeSurvey 5.6.x to LimeSurvey 7.x.

Steps To Reproduce

Steps to reproduce

  1. Use a survey originally created and activated in LimeSurvey 5.6.x.
  2. Migrate/upgrade the LimeSurvey environment to LimeSurvey 7.x.
  3. Use the migrated survey without exporting and reimporting it.
  4. Make sure the survey contains an active quota with a configured quota exit message.
  5. Open the public survey and submit a response that reaches the quota limit.
  6. When the quota is reached and quota_exit is triggered, the survey returns an HTTP 500 Internal Server Error.

Expected result

When the quota is reached, LimeSurvey should process quota_exit normally and display the configured quota exit message/page.

Actual result

When quota_exit is triggered, LimeSurvey returns an HTTP 500 Internal Server Error and the participant cannot see the configured quota exit message.

Additional observation:
If the affected survey is exported, deleted from LimeSurvey and then imported again, the same survey works normally and quota_exit no longer produces the HTTP 500 error.

This behavior has been observed in multiple migrated surveys, suggesting that the issue may be related to data or configuration retained during the migration from LimeSurvey 5.6.x to LimeSurvey 7.x.

TagsNo tags attached.
Attached Files
limesurvey_survey_999943.lss (179,271 bytes)
Error_500.jpg (57,079 bytes)   
Error_500.jpg (57,079 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)7.9.0+261029
I will donate to the project if issue is resolvedNo
BrowserGoogle Chrome
Database type & versionMariaDB (server version unknown)
Server OS (if known)Linux (Debian)
Webserver software & version (if known)
PHP Version8.3.36
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2026-11-05 21:16

administrator   ~87203

Last edited: 2026-11-05 21:26

The attached survey has no quotas.
Can you enable debug = 2 in application/config/config.php and try again, please? Paste the complete error message here.
Can you also check your other response_<id> tables if they have a quota_exit field?
xastrefernando

xastrefernando

2026-11-06 10:56

reporter   ~87206

Thank you for the feedback and for looking into this issue.

We will try to carry out the requested tests, including enabling debug = 2, reproducing the error and checking the quota_exit field in the affected response tables.

We will share the results and the complete error message as soon as we have them.

Related Changesets

LimeSurvey: master 49d0afb1

2026-11-05 21:35

c_schmitz


Details Diff		 Fixed issue 20820: Completing a survey caused an internal server error after upgrading from a version before 7.0 when detailed admin notifications were enabled
Dev The upgrade did not add the quota_exit column to any response table: Update_715 used tableExists(), which still had the table names from before Update_700 renamed survey_<sid> to responses_<sid>; Update_719 adds the missing column
Dev getFullResponseTable() skips fieldmap fields that have no column in the response table		 Affected Issues
20820
mod - application/config/version.php Diff File
mod - application/helpers/common_helper.php Diff File
add - application/helpers/update/updates/Update_719.php Diff File
add - tests/unit/helpers/QuotaExitColumnTest.php Diff File

Issue History

Date Modified Username Field Change
2026-11-05 17:51 xastrefernando New Issue
2026-11-05 17:51 xastrefernando File Added: limesurvey_survey_999943.lss
2026-11-05 17:51 xastrefernando File Added: Error_500.jpg
2026-11-05 21:16 c_schmitz Assigned To => c_schmitz
2026-11-05 21:16 c_schmitz Status new => feedback
2026-11-05 21:16 c_schmitz Note Added: 87203
2026-11-05 21:16 c_schmitz Bug heat 0 => 2
2026-11-05 21:26 c_schmitz Note Edited: 87203
2026-11-05 21:36 c_schmitz Changeset attached => LimeSurvey master 49d0afb1
2026-11-05 21:36 c_schmitz Status feedback => resolved
2026-11-05 21:36 c_schmitz Resolution open => fixed
2026-11-05 21:40 c_schmitz Status resolved => feedback
2026-11-05 21:40 c_schmitz Resolution fixed => reopened
2026-11-06 10:56 xastrefernando Note Added: 87206
2026-11-06 10:56 xastrefernando Bug heat 2 => 4
2026-11-06 10:56 xastrefernando Status feedback => assigned