Je viens de lancer l'install de la 3.3.11.
J'ai eu un message d'erreur à la fin de l'install (de mémoire, sur une table des scénarios à propos des "tags").
J'ai reforcé l'install 2-3 fois mais ca termine mal :
[START UPDATE]
****Update from 3.3.11 (2019-02-04 11:57:18)****
Parameters : {"preUpdate":"0","backup::before":"0","plugins":"0","core":"1","force":"1","update::reapply":"3.3.11"}
Send begin of update event...***ERROR***[MySQL] Error code : 42S22 (1054). Unknown column 'order' 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_idCheck rights...
OK
Disable all task
OK
Disable all scenarioError during update : [MySQL] Error code : 42S22 (1054). Unknown column 's.order' in 'field list' : SELECT `s`.`id`, `s`.`name`, `s`.`isActive`, `s`.`group`, `s`.`mode`, `s`.`schedule`, `s`.`scenarioElement`, `s`.`trigger`, `s`.`timeout`, `s`.`object_id`, `s`.`isVisible`, `s`.`display`, `s`.`order`, `s`.`description`, `s`.`configuration`, `s`.`type`
FROM scenario s
INNER JOIN object ob ON s.object_id=ob.id ORDER BY ob.name,s.group, s.nameDetails : Array
(
[0] => Array
(
[file] => /var/www/html/core/class/scenario.class.php
[line] => 91
[function] => Prepare
[class] => DB
[type] => ::
[args] => Array
(
[0] => SELECT `s`.`id`, `s`.`name`, `s`.`isActive`, `s`.`group`, `s`.`mode`, `s`.`schedule`, `s`.`scenarioElement`, `s`.`trigger`, `s`.`timeout`, `s`.`object_id`, `s`.`isVisible`, `s`.`display`, `s`.`order`, `s`.`description`, `s`.`configuration`, `s`.`type`
FROM scenario s
INNER JOIN object ob ON s.object_id=ob.id ORDER BY ob.name,s.group, s.name
[1] => Array
(
)
[2] => 1
[3] => 8
[4] => scenario
)
)
[1] => Array
(
[file] => /var/www/html/core/class/jeedom.class.php
[line] => 667
[function] => all
[class] => scenario
[type] => ::
[args] => Array
(
)
)
[2] => Array
(
[file] => /var/www/html/install/update.php
[line] => 113
[function] => stop
[class] => jeedom
[type] => ::
[args] => Array
(
)
)
)
[END UPDATE ERROR]
PHP Fatal error: Uncaught Exception: [MySQL] Error code : 42S22 (1054). Unknown column 's.order' in 'field list' : SELECT `s`.`id`, `s`.`name`, `s`.`isActive`, `s`.`group`, `s`.`mode`, `s`.`schedule`, `s`.`scenarioElement`, `s`.`trigger`, `s`.`timeout`, `s`.`object_id`, `s`.`isVisible`, `s`.`display`, `s`.`order`, `s`.`description`, `s`.`configuration`, `s`.`type`
FROM scenario s
INNER JOIN object ob ON s.object_id=ob.id ORDER BY ob.name,s.group, s.name in /var/www/html/core/class/DB.class.php:105
Stack trace:
#0 /var/www/html/core/class/scenario.class.php(91): DB::Prepare('SELECT `s`.`id`...', Array, 1, 8, 'scenario')
#1 /var/www/html/core/class/jeedom.class.php(667): scenario::all()
#2 /var/www/html/install/update.php(113): jeedom::stop()
#3 {main}
thrown in /var/www/html/core/class/DB.class.php on line 105
Depuis, lorsque je vais sur le dashboard, j'ai ce message, et plus rien qui s'affiche :
[MySQL] Error code : 42S22 (1054). Unknown column 'order' in 'field list' : SELECT `id`, `name`, `isActive`, `group`, `mode`, `schedule`, `scenarioElement`, `trigger`, `timeout`, `object_id`, `isVisible`, `display`, `order`, `description`, `configuration`, `type` FROM scenario WHERE object_id=:object_id AND isVisible = 1 ORDER BY `order`
Et une page de scénario vide avec ce message :
[MySQL] Error code : 42S22 (1054). Unknown column 's.order' in 'field list' : SELECT `s`.`id`, `s`.`name`, `s`.`isActive`, `s`.`group`, `s`.`mode`, `s`.`schedule`, `s`.`scenarioElement`, `s`.`trigger`, `s`.`timeout`, `s`.`object_id`, `s`.`isVisible`, `s`.`display`, `s`.`order`, `s`.`description`, `s`.`configuration`, `s`.`type` FROM scenario s INNER JOIN object ob ON s.object_id=ob.id ORDER BY ob.name,s.group, s.name
J'ai peur...