Pour mon environnement de dev, j’utilise docker sur synology.
J’ai un porbléme récurrent et que si j’arrête le container.
Le jeedom ne redémarre jamais, j’ai cette erreur sur la page web :
[MySQL] Error code : 42S02 (1932). Table ‹ jeedom.config › doesn’t exist in engine : SELECT
key
,value
FROM config WHEREkey
IN (‹ language ›) AND plugin=:plugin
J’essaye de réparer la base, et cela se passe sans erreur :
php /var/www/html/install/database.php
Lorsque j’essaye de recharger une sauvegarde :
root@jeedom-dev:/var/www/html/backup# php /var/www/html/install/restore.php backup-jeedomdev-4.4.19-2024-11-21-05h59.tar.gz
[START RESTORE]
PHP Fatal error: Uncaught Exception: [MySQL] Error code : 42S02 (1932). Table 'jeedom.config' doesn't exist in engine : DELETE FROM config
WHERE `key`=:key
AND plugin=:plugin in /var/www/html/core/class/DB.class.php:120
Stack trace:
#0 /var/www/html/core/class/config.class.php(133): DB::Prepare()
#1 /var/www/html/core/class/config.class.php(69): config::remove()
#2 /var/www/html/core/class/jeedom.class.php(993): config::save()
#3 /var/www/html/install/restore.php(248): jeedom::start()
#4 {main}
thrown in /var/www/html/core/class/DB.class.php on line 120
Error during restore : [MySQL] Error code : 42S02 (1932). Table 'jeedom.config' doesn't exist in engine : SELECT `key`,`value`
FROM config
WHERE `key` IN ('language')
AND plugin=:pluginDetails : Array
(
[0] => Array
(
[file] => /var/www/html/core/class/config.class.php
[line] => 192
[function] => Prepare
[class] => DB
[type] => ::
)
[1] => Array
(
[file] => /var/www/html/core/class/translate.class.php
[line] => 51
[function] => byKeys
[class] => config
[type] => ::
)
[2] => Array
(
[file] => /var/www/html/core/class/translate.class.php
[line] => 207
[function] => getConfig
[class] => translate
[type] => ::
)
[3] => Array
(
[file] => /var/www/html/core/class/translate.class.php
[line] => 102
[function] => getLanguage
[class] => translate
[type] => ::
)
[4] => Array
(
[file] => /var/www/html/core/class/translate.class.php
[line] => 81
[function] => exec
[class] => translate
[type] => ::
)
[5] => Array
(
[file] => /var/www/html/core/class/translate.class.php
[line] => 220
[function] => sentence
[class] => translate
[type] => ::
)
[6] => Array
(
[file] => /var/www/html/core/config/jeedom.config.php
[line] => 23
[function] => __
)
[7] => Array
(
[file] => /var/www/html/core/php/utils.inc.php
[line] => 84
[args] => Array
(
[0] => /var/www/html/core/config/jeedom.config.php
)
[function] => require_once
)
[8] => Array
(
[file] => /var/www/html/core/php/core.inc.php
[line] => 27
[function] => include_file
)
[9] => Array
(
[file] => /var/www/html/install/restore.php
[line] => 28
[args] => Array
(
[0] => /var/www/html/core/php/core.inc.php
)
[function] => require_once
)
)
[END RESTORE ERROR]