View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
14344 | Bug reports | Installation | public | 2018-12-12 15:09 | 2020-03-06 00:43 |
Reporter | ritapas | Assigned To | |||
Priority | none | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 3.15.x | ||||
Fixed in Version | 3.22.7 | ||||
Summary | 14344: create-database.php creates table sessions with incorrect data type for field 'data' in MariaDB 5.5.60 | ||||
Description | The create-database.php uses a database-independent script to create the limesurvey database with the required tables. In our configuration, this lead to the creation of a sessions table where the "data" field is a blob while it should be a longblob. This causes issues while executing or previewing surveys if you import them. Surveys created by hand work in the expected way, | ||||
Steps To Reproduce | Install limesurvey on a machine with the same configuration, then check the sessions table in the database.
| ||||
Additional Information | php packets: | ||||
Tags | installation.database | ||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | Version 3.15.5+181115 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | MariaDB 5.5.60 | ||||
Server OS (if known) | RHL7 | ||||
Webserver software & version (if known) | |||||
PHP Version | rh-php71-1-1 | ||||
you must uncomment the following lines in config.php to enable table-based sessions. |
|
Markus I assign it to you because you're the last one who edited this line:) |
|
I believe something similar happens in application/helpers/update/updatedb_helper.php because we experienced the same problems while upgrading the application db from a previous version, with the same configuration. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2018-12-12 15:09 | ritapas | New Issue | |
2018-12-12 15:33 | ritapas | Issue Monitored: ritapas | |
2018-12-12 15:46 | ritapas | Note Added: 49950 | |
2018-12-13 13:43 | ritapas | Tag Attached: installation.database | |
2019-01-10 16:17 |
|
Assigned To | => markusfluer |
2019-01-10 16:17 |
|
Status | new => assigned |
2019-01-10 16:18 |
|
Note Added: 50159 | |
2019-04-12 14:13 | ritapas | Note Added: 51457 | |
2020-03-06 00:43 | c_schmitz | Status | assigned => closed |
2020-03-06 00:43 | c_schmitz | Resolution | open => fixed |
2020-03-06 00:43 | c_schmitz | Fixed in Version | => 3.22.7 |
2021-08-02 17:18 | guest | Bug heat | 4 => 6 |