View Issue Details

This issue affects 1 person(s).
 16
IDProjectCategoryView StatusLast Update
20624Bug reportsComfortUpdatepublic2026-09-10 14:12
ReporterMazi Assigned Toc_schmitz  
PrioritynoneSeveritycrash 
Status closedResolutionfixed 
Summary20624: DB crash when updating from 7.0.5 to 7.0.7 due to missing DB version check
Description

While upgrading LimeSurvey 7.0.5 to 7.0.7, we encountered a database update failure on a server running MariaDB 10.1.48.

As a temporary workaround, we were able to complete the update by changing the column type from JSON to LONGTEXT in:
application/helpers/update/updates/Update_709.php (line 19)

addColumn("{{responses_" . $sid . "}}", "Q{$parent_qid}", "LONGTEXT");

However, we believe the actual issue is that the updater starts the database migration without first verifying that the database server meets the documented minimum requirements.

Steps To Reproduce

Steps to reproduce

  1. Install LimeSurvey 7.0.5.
  2. Use MariaDB 10.1.48 as the database server.
  3. Update the LimeSurvey files to 7.0.7.
  4. Open the administration interface and start the database update.

During Update_709, the update attempts to execute:

ALTER TABLE `lime_responses_<surveyId>`
ADD `Q<questionId>` JSON;

MariaDB 10.1 does not support the JSON data type, causing the update to fail with a SQL syntax error.

Expected result

Before starting any database migration, LimeSurvey should verify that the database server meets the documented minimum requirements (currently MariaDB 10.3.38 or newer).

If the database version is not supported, the updater should stop immediately and display a clear error message, for example:

MariaDB 10.3.38 or newer is required. Detected version: 10.1.48.

No database migration should be started.

Actual result

The updater starts the database migration without checking the MariaDB version.

The update fails during Update_709 with a SQL syntax error when attempting to add a JSON column. Since the migration has already started, the database is left in a partially updated state and every subsequent attempt to continue the update fails at the same step.

The documented minimum database version exists, but it is not validated before the update process begins, resulting in an avoidable failed upgrade.

TagsNo tags attached.
Bug heat16
Complete LimeSurvey version number (& build)7.0.7
I will donate to the project if issue is resolvedNo
Story point estimate
Browser
Database type & versionMariaDB 10.1.48
Server OS (if known)
Webserver software & version (if known)
PHP Version8.3

Relationships

has duplicate 20665 closedc_schmitz Missing PostgreSQL version and webserver config tests before upgrading to version 7 

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2026-09-08 18:00

administrator   ~85611

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

LimeBot

LimeBot

2026-09-10 14:12

administrator   ~85639

Fixed in Release 7.0.15+260910

Related Changesets

LimeSurvey: master 5e00ef60

2026-09-08 18:00

c_schmitz

Committer: GitHub


Details Diff
Fixed issue 20624: Error when updating to 7.0.7 due to missing DB version check (05185) Affected Issues
20624
add - application/helpers/DbVersionHelper.php Diff File
mod - application/helpers/update/updatedb_helper.php Diff File
mod - application/models/InstallerConfigForm.php Diff File

Issue History

Date Modified Username Field Change
2026-07-30 19:24 Mazi New Issue
2026-07-31 11:53 c_schmitz Assigned To => c_schmitz
2026-07-31 11:53 c_schmitz Status new => assigned
2026-07-31 11:53 c_schmitz Status assigned => ready for code review
2026-07-31 11:53 c_schmitz Bug heat 0 => 2
2026-07-31 11:53 c_schmitz Bug heat 2 => 0
2026-08-14 17:08 gabrieljenik Assigned To c_schmitz => tibor.pacalat
2026-08-14 17:08 gabrieljenik Status ready for code review => ready for testing
2026-09-01 11:06 Mazi Relationship added related to 20665
2026-09-01 14:33 c_schmitz Relationship replaced duplicate of 20665
2026-09-01 14:33 c_schmitz Relationship replaced has duplicate 20665
2026-09-01 14:33 c_schmitz Bug heat 0 => 12
2026-09-08 18:00 c_schmitz Changeset attached => LimeSurvey master 5e00ef60
2026-09-08 18:00 c_schmitz Note Added: 85611
2026-09-08 18:00 c_schmitz Assigned To tibor.pacalat => c_schmitz
2026-09-08 18:00 c_schmitz Status ready for testing => resolved
2026-09-08 18:00 c_schmitz Resolution open => fixed
2026-09-08 18:00 c_schmitz Bug heat 12 => 14
2026-09-10 14:12 LimeBot Note Added: 85639
2026-09-10 14:12 LimeBot Status resolved => closed
2026-09-10 14:12 LimeBot Bug heat 14 => 16