View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
13824Feature requestsInstallationpublic2021-11-26 07:40
Reporteryniquet Assigned Toc_schmitz  
PrioritynoneSeverityfeature 
Status closedResolutionfixed 
Summary13824: installing with innodb
Description

Is it possible to have a delivery date for having the choice between innodb and myisam during the installation?
I can change to innodb after installation, but when we create a survey with participant the table is create with myisam...
And the synchronization on mariadb cluster don't work with myisam.

Thank's

TagsNo tags attached.
Bug heat8
Story point estimate
Users affected %

Users monitoring this issue

There are no users monitoring this issue.

Activities

danigri

danigri

2018-07-12 17:56

reporter   ~48500

+1
I always have to change table engine to InnoDB and "hack" the scripts to create new tables in InnoDB because of the same issue

rbaier

rbaier

2018-07-17 14:00

reporter   ~48520

To change the table engine fom MyISAM to InnoDB you can edit the file <LS-root dir>/application/core/db/MysqlSchema.php
You will have to repeat this step each time after installing a LimeSurvey update.

yniquet

yniquet

2018-07-19 17:38

reporter   ~48536

it does not solve the problem, since limesurvey create tables in myisam when adding participant, surveys etc.
And even with innodb we have problems of integrity. Finally we installed on MySQL on single server.

rbaier

rbaier

2018-07-23 10:00

reporter   ~48547

I cannot confirm this. We have used this method for years and the tables created by LimeSurvey always were of type InnoDB.
In Version 2.05 you had to set the engine type (InnoDB) in application/config/config.php. In LS versions >2.5 the relevant file is application/core/db/MysqlSchema.php.

yniquet

yniquet

2018-07-23 17:45

reporter   ~48550

rbaier please, can you confirm to me that you use mariadb on galera cluster

rbaier

rbaier

2018-07-24 11:48

reporter   ~48563

yniquet, we do not use mariadb on galera cluster, just plain mysql.

c_schmitz

c_schmitz

2021-11-26 07:40

administrator   ~67577

Since version 4 you can select the default table format during installation.

Issue History

Date Modified Username Field Change
2018-06-27 15:45 yniquet New Issue
2018-07-12 17:56 danigri Note Added: 48500
2018-07-17 14:00 rbaier Note Added: 48520
2018-07-19 17:38 yniquet Note Added: 48536
2018-07-23 10:00 rbaier Note Added: 48547
2018-07-23 17:45 yniquet Note Added: 48550
2018-07-24 11:48 rbaier Note Added: 48563
2021-11-26 07:40 c_schmitz Assigned To => c_schmitz
2021-11-26 07:40 c_schmitz Status new => resolved
2021-11-26 07:40 c_schmitz Resolution open => fixed
2021-11-26 07:40 c_schmitz Note Added: 67577
2021-11-26 07:40 c_schmitz Bug heat 6 => 8
2021-11-26 07:40 c_schmitz Status resolved => closed