View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
17419Bug reportsInstallationpublic2021-07-21 15:27
Reportergabrieljenik Assigned Togabrieljenik  
PrioritynormalSeveritycrash 
Status feedbackResolutionopen 
Product Version5.x 
Summary17419: Transactions do not work during upgrade
DescriptionEx: Upgrade 425 creates records in question themes table for all available question themes. If one fails, the records that were inserted remain in the table.
TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)5.0
I will donate to the project if issue is resolvedNo
Browser
Database & DB-VersionMysql
Server OS (if known)
Webserver software & version (if known)
PHP Versionphp

Activities

c_schmitz

c_schmitz

2021-07-08 10:03

administrator   ~65254

The problem is rather that models are used in 425 in updatedb_helper.
These need to be replaced with direct SQL queries.
Transaction work only up to a point. For example if you have table structure modifications they auto-commit.
ollehar

ollehar

2021-07-21 15:27

administrator   ~65527

As Carsten said, table mods in MySQL auto-commit the transaction, but the 425 upgrade should work. Strange.
ollehar

ollehar

2021-07-21 15:27

administrator   ~65528

Did you apply *only* the 425 upgrade, or any others?

Issue History

Date Modified Username Field Change
2021-07-07 21:18 gabrieljenik New Issue
2021-07-07 21:19 gabrieljenik Issue cloned: 17420
2021-07-08 09:21 galads Assigned To => gabrieljenik
2021-07-08 09:21 galads Status new => assigned
2021-07-08 10:03 c_schmitz Note Added: 65254
2021-07-21 15:27 ollehar Note Added: 65527
2021-07-21 15:27 ollehar Bug heat 2 => 4
2021-07-21 15:27 ollehar Priority none => normal
2021-07-21 15:27 ollehar Note Added: 65528
2021-07-21 15:27 ollehar Status assigned => feedback