search

NextDom / nextdom-core

NextDom Core >>
https://www.nextdom.org/
GNU General Public License v3.0
21 stars 13 forks source link

Change ENGINE=`MyISAM` to `InnoDB` for `interactQuery` #1716

Closed lucguinchard closed 4 years ago

Esso1-jeedom commented 4 years ago

comment on test deja ?

Esso1-jeedom commented 4 years ago

nota j'arrive pas a restorer un backup image

sonarcloud[bot] commented 4 years ago

SonarCloud Quality Gate failed.

Bug A 0 Bugs
Vulnerability A 0 Vulnerabilities (and Security Hotspot 0 Security Hotspots to review)
Code Smell B 2 Code Smells

No Coverage information No Coverage information
0.0% 0.0% Duplication

Esso1-jeedom commented 4 years ago

aprés avoir refait le postinst. image

therealcorwin commented 4 years ago

@lucguinchard , sur la table interactQuery je ne pense pas avoir la bonne chose

`

Table Create Table
interactQuery CREATE TABLE interactQuery ( id int(11) NOT NULL AUTO_INCREMENT, interactDef_id int(11) NOT NULL, query text COLLATE utf8_unicode_ci DEFAULT NULL, actions text COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (id), KEY fk_sarahQuery_sarahDef1_idx (interactDef_id), FULLTEXT KEY query (query) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

`

lucguinchard commented 4 years ago

Annulation de cette PR pour remplacement https://github.com/NextDom/nextdom-core/pull/1721