Merci !
La première partie du tuto m’a permis de reprendre la main sur jeedom.
La 2eme partie par contre claque une erreur tout de suite :
Send begin of update event...Error during update : [MySQL] Error code : 42S22 (1054). Unknown column 'type' in 'field list' : SELECT `id`, `name`, `isActiv e`, `group`, `mode`, `schedule`, `scenarioElement`, `trigger`, `timeout`, `obj ect_id`, `isVisible`, `display`, `order`, `description`, `configuration`, `typ e`
FROM scenario
WHERE mode != "schedule" AND isActive=1 AND `trigger` LIKE :cm d_idDetails : Array
(
[0] => Array
(
[file] => /var/www/html/core/class/scenario.class.php
[line] => 202
[function] => Prepare
[class] => DB
[type] => ::
[args] => Array
(
[0] => SELECT `id`, `name`, `isActive`, `group`, `mode`, ` schedule`, `scenarioElement`, `trigger`, `timeout`, `object_id`, `isVisible`, `display`, `order`, `description`, `configuration`, `type`
FROM scenario
WHERE mode != "schedule" AND isActive=1 AND `trigger` LIKE :cm d_id
[1] => Array
(
[cmd_id] => %#begin_update#%
)
[2] => 1
[3] => 8
[4] => scenario
)
)
[1] => Array
(
[file] => /var/www/html/core/class/scenario.class.php
[line] => 259
[function] => byTrigger
[class] => scenario
[type] => ::
[args] => Array
(
[0] => begin_update
)
)
[2] => Array
(
[file] => /var/www/html/core/class/jeedom.class.php
[line] => 824
[function] => check
[class] => scenario
[type] => ::
[args] => Array
(
[0] => begin_update
[1] => 1
)
)
[3] => Array
(
[file] => /var/www/html/install/update.php
[line] => 62
[function] => event
[class] => jeedom
[type] => ::
[args] => Array
(
[0] => begin_update
[1] => 1
)
)
)
[END UPDATE ERROR]
PHP Fatal error: Uncaught exception 'Exception' with message '[MySQL] Error c ode : 42S22 (1054). Unknown column 'type' in 'field list' : SELECT `id`, `nam e`, `isActive`, `group`, `mode`, `schedule`, `scenarioElement`, `trigger`, `ti meout`, `object_id`, `isVisible`, `display`, `order`, `description`, `configur ation`, `type`
FROM scenario
WHERE mode != "schedule" AND isActive=1 AND `trigger` LIKE :cm d_id' in /var/www/html/core/class/DB.class.php:105
Stack trace:
#0 /var/www/html/core/class/scenario.class.php(202): DB::Prepare('SELECT `id`, `n...', Array, 1, 8, 'scenario')
#1 /var/www/html/core/class/scenario.class.php(259): scenario::byTrigger('begi n_update')
#2 /var/www/html/core/class/jeedom.class.php(824): scenario::check('begin_upda te', true)
#3 /var/www/html/install/update.php(62): jeedom::event('begin_update', true)
#4 {main}
thrown in /var/www/html/core/class/DB.class.php on line 105
L’interface est « cassée » mais en mode rescue c’est utilisable, j’essaye actuellement de faire une restauration depuis un backup d’aujourd’hui (avant la tentative de maj).
Pour le moment ça tourne, mais ça claque aussi des erreurs :
[START RESTORE]
***************Début de la restauration de Jeedom 2021-01-13 21:36:36***************
Envoie l'événement de début de restauration...***ERREUR*** [MySQL] Error code : 42S22 (1054). Unknown column 'type' in 'field list' : SELECT `id`, `name`, `isActive`, `group`, `mode`, `schedule`, `scenarioElement`, `trigger`, `timeout`, `object_id`, `isVisible`, `display`, `order`, `description`, `configuration`, `type`
FROM scenario
WHERE mode != "schedule" AND isActive=1 AND `trigger` LIKE :cmd_idVérifiez les droits...
OK
Et entretemps la restauration est terminé, j’ai de nouveau accès à l’interface normalement !
Merci beaucoup pour le coup de main !
