View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|13824||Feature requests||Installation||public||2018-06-27 15:45||2018-07-24 11:48|
|Summary||13824: 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.
|Tags||No tags attached.|
I always have to change table engine to InnoDB and "hack" the scripts to create new tables in InnoDB because of the same issue
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.
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.
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.
|rbaier please, can you confirm to me that you use mariadb on galera cluster|
|yniquet, we do not use mariadb on galera cluster, just plain mysql.|
|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|