Alors j’ai fais une SD neuve sous buster
installé jeedom v4 vierge dessus
restauré mon backup en v3
puis lors de la maj vers v4 voici le log :
[START UPDATE]
****Update from 3.3.56 (2022-07-10 16:12:45)****
Parameters : {"preUpdate":"0","backup::before":"0","plugins":"1","core":"1","force":"0","update::reapply":""}
Send begin of update event...OK
Check update...
OK
Check rights...
OK
Disable all task.
.
(4594): No such process
.. OK
Disable all scenario....
...................
.................
...... OK
Download url : https://github.com/jeedom/core/archive/V4-stable.zip
Download in progress...--2022-07-10 16:13:01-- https://github.com/jeedom/core/archive/V4-stable.zip
Resolving github.com (github.com)... 140.82.121.4
Connecting to github.com (github.com)|140.82.121.4|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://codeload.github.com/jeedom/core/zip/refs/heads/V4-stable [following]
--2022-07-10 16:13:01-- https://codeload.github.com/jeedom/core/zip/refs/heads/V4-stable
Resolving codeload.github.com (codeload.github.com)... 140.82.121.9
Connecting to codeload.github.com (codeload.github.com)|140.82.121.9|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 82120477 (78M) [application/zip]
Saving to: '/tmp/jeedom/install/jeedom_update.zip'
0K ........ ........ ........ ........ .....
... ........ 3% 2.35M 32s
3072K ........ ........ ........ ........ .......
. ........ 7% 2.81M 28s
6144K ........ ........ ........ ........ .......
. ........ 11% 2.62M 27s
9216K ........ ........ ........ ........ ........
........ 15% 2.62M 26s
12288K ........ ........ ........ ........ ........
........ 19% 2.61M 24s
15360K ........ ........ ........ ........ ........ .
....... 22% 2.64M 23s
18432K ........ ........ ........ ........ ........ ..
...... 26% 2.65M 22s
21504K ........ ........ ........ ........ ........ ...
..... 30% 2.62M 21s
24576K ........ ........ ........ ........ ........ ..
...... 34% 2.62M 20s
27648K ........ ........ ........ ........ ........ ........ 38% 2.60M 19s
30720K ........ ........ ........ ........ ........ ......
.. 42% 2.54M 17s
33792K ........ ........ ........ ........ ........ .......
. 45% 2.66M 16s
36864K ........ ........ ........ ........ ........ ........ 49% 2.62M 15s
39936K ...
..... ........ ........ ........ ........ ........ 53% 2.63M 14s
43008K ...
..... ........ ........ ........ ........ ........ 57% 2.61M 13s
46080K ...
..... ........ ........ ........ ........ ........ 61% 2.63M 12s
49152K ........
........ ........ ........ ........ ........ 65% 2.62M 10s
52224K ........ ....
.... ........ ........ ........ ........ 68% 2.62M 9s
55296K ........ .......
. ........ ........ ........ ........ 72% 2.62M 8s
58368K ........ ........
........ ........ ........ ........ 76% 2.64M 7s
61440K ........ ........ .....
... ........ ........ ........ 80% 2.64M 6s
64512K ........ ........ ........ .
....... ........ ........ 84% 2.60M 5s
67584K ........ ........ ........
........ ........ ........ 88% 2.61M 4s
70656K ........ ........ ......
. ........ ........ ........ 91% 2.55M 2s
73728K ........ ........ ........
........ ........ ........ 95% 2.50M 1s
76800K ........ ........ ........
........ ........ ........ 99% 2.28M 0s
79872K ..... 100% 1.61M=30s
2022-07-10 16:13:32 (2.59 MB/s) - '/tmp/jeedom/install/jeedom_update.zip' saved [82120477/82120477]
OK
Cleaning folders...OK
Create temporary folder...OK
Unzip in progress...
OK
Clean temporary files (tmp)...OK
Moving files...
Ignore file /tmp/jeedom_unzip/core-4-stable///docs/de_DE/noteVersion.md because size is 0
Ignore file /tmp/jeedom_unzip/core-4-stable///docs/en_US/noteVersion.md because size is 0
Ignore file /tmp/jeedom_unzip/core-4-stable///docs/es_ES/noteVersion.md because size is 0
Ignore file /tmp/jeedom_unzip/core-4-stable///docs/fr_FR/noteVersion.md because size is 0
Ignore file /tmp/jeedom_unzip/core-4-stable///docs/pt_PT/noteVersion.md because size is 0
OK
Remove temporary files...OK
Update system into : 3.4.0...
Suppression theme /var/www/html/install/update/../../core/themes/amber/Suppression theme /var/www/html/install/update/../../core/themes/blue/Suppression theme /var/www/html/install/update/../../core/themes/blue_grey/Suppression theme /var/www/html/install/update/../../core/themes/bootable/Suppression theme /var/www/html/install/update/../../core/themes/brown/Suppression theme /var/www/html/install/update/../../core/themes/cyan/Suppression theme /var/www/html/install/update/../../core/themes/darksobre/Suppression theme /var/www/html/install/update/../../core/themes/deep_orange/Suppression theme /var/www/html/install/update/../../core/themes/deep_purple/Suppression theme /var/www/html/install/update/../../core/themes/green/Suppression theme /var/www/html/install/update/../../core/themes/grey/Suppression theme /var/www/html/install/update/../../core/themes/light_blue/Suppression theme /var/www/html/install/update/../../core/themes/light_green/Suppression theme /var/www/html/install/update/../../core/themes/lime/Suppression theme /var/www/html/install/update/../../core/themes/orange/Suppression theme /var/www/html/install/update/../../core/themes/pink/Suppression theme /var/www/html/install/update/../../core/themes/purple/Suppression theme /var/www/html/install/update/../../core/themes/red/Suppression theme /var/www/html/install/update/../../core/themes/teal/Suppression theme /var/www/html/install/update/../../core/themes/yellow/OK
Update system into : 4.0.1...OK
Update system into : 4.0.2...
OK
Update system into : 4.0.3...
Copy widget of plugin widget to jeedom custom widget dir...OK
Update system into : 4.0.4...
OK
Update system into : 4.0.5...
OK
Update system into : 4.0.6...E: dpkg was interrupted, you must manually run 'sudo dpkg --configure -a' to correct the problem.
OK
Update system into : 4.0.11...
OK
Update system into : 4.0.15...
OK
Update system into : 4.0.23...E: dpkg was interrupted, you must manually run 'sudo dpkg --configure -a' to correct the problem.
je passeOK
Update system into : 4.1.1...
OK
Update system into : 4.1.2...cp: cannot stat '/var/www/html/install/update/../../core/config/scenario': No such file or directory
OK
Update system into : 4.1.3...
OK
Update system into : 4.1.4...
OK
Update system into : 4.1.5...OK
Update system into : 4.1.7...OK
Update system into : 4.1.15...
PHP Fatal error: Uncaught Exception: [MySQL] Error code : 42S22 (1054). Unknown column 'order' in 'field list' : SELECT `id`, `name`, `image`, `configuration`, `order`
FROM planHeader
ORDER BY `order` in /var/www/html/core/class/DB.class.php:102
Stack trace:
#0 /var/www/html/core/class/planHeader.class.php(48): DB::Prepare('SELECT `id`, `n...', Array, 1, 8, 'planHeader')
#1 /var/www/html/install/update/4.1.15.php(3): planHeader::all()
#2 {main}
thrown in /var/www/html/core/class/DB.class.php on line 102
OK
Update system into : 4.2.3...
Update system into : 4.2.4...OK
Update system into : 4.2.11...
Enable apache remoteipOK
Check jeedom consistency...[START CONSISTENCY]
[START CHECK AND FIX DB]
Fix : ALTER TABLE `cmd` DROP INDEX `unique`;
Fix : ALTER TABLE `cmd` DROP INDEX `isHistorized`;
Fix : ALTER TABLE `cmd` DROP INDEX `type`;
Fix : ALTER TABLE `cmd` DROP INDEX `name`;
Fix : ALTER TABLE `cmd` DROP INDEX `subtype`;
Fix : ALTER TABLE `cmd` DROP INDEX `eqLogic_id`;
Fix : ALTER TABLE `cmd` DROP INDEX `value`;
Fix : ALTER TABLE `cmd` DROP INDEX `order`;
Fix : ALTER TABLE `cmd` DROP INDEX `logicalID`;
Fix : ALTER TABLE `cmd` MODIFY COLUMN `logicalId` varchar(255) NULL
Fix : ALTER TABLE `cmd` MODIFY COLUMN `name` varchar(127) NULL
Fix : ALTER TABLE `cmd` MODIFY COLUMN `configuration` mediumtext NULL
Fix : ALTER TABLE `cmd` DROP `html`
Fix :
CREATE UNIQUE INDEX `unique` ON `cmd` (`eqLogic_id` ASC,`name` ASC)
Fix :
CREATE INDEX `isHistorized` ON `cmd` (`isHistorized` ASC)
Fix :
CREATE INDEX `type` ON `cmd` (`type` ASC)
Fix :
CREATE INDEX `name` ON `cmd` (`name` ASC)
Fix :
CREATE INDEX `subtype` ON `cmd` (`subType` ASC)
Fix :
CREATE INDEX `eqLogic_id` ON `cmd` (`eqLogic_id` ASC)
Fix :
CREATE INDEX `value` ON `cmd` (`value` ASC)
Fix :
CREATE INDEX `order` ON `cmd` (`order` ASC)
Fix :
CREATE INDEX `logicalID` ON `cmd` (`logicalId` ASC)
Fix : ALTER TABLE `cmd` DROP INDEX `logicalId_eqLogicID`;
Fix : ALTER TABLE `config` MODIFY COLUMN `key` varchar(127) NOT NULL
Fix : ALTER TABLE `config` MODIFY COLUMN `value` mediumtext NULL
Fix : ALTER TABLE `cron` DROP INDEX `deamon`;
Fix : ALTER TABLE `cron` MODIFY COLUMN `option` text NULL
Fix : CREATE INDEX `function` ON `cron` (`function` ASC)
Fix :
CREATE INDEX `deamon` ON `cron` (`deamon` ASC)
Fix : ALTER TABLE `cron` DROP INDEX `type`;
Fix : ALTER TABLE `cron` DROP INDEX `logicalId_Type`;
Fix : ALTER TABLE `eqLogic` DROP INDEX `unique`;
Fix : ALTER TABLE `eqLogic` DROP INDEX `eqTypeName`;
Fix : ALTER TABLE `eqLogic` DROP INDEX `name`;
Fix : ALTER TABLE `eqLogic` DROP INDEX `logical_id`;
Fix : ALTER TABLE `eqLogic` DROP INDEX `object_id`;
Fix : ALTER TABLE `eqLogic` DROP INDEX `timeout`;
Fix : ALTER TABLE `eqLogic` DROP INDEX `generic_type`;
Fix : ALTER TABLE `eqLogic` DROP INDEX `tags`;
Fix : ALTER TABLE `eqLogic` MODIFY COLUMN `configuration` mediumtext NULL
Fix : ALTER TABLE `eqLogic` DROP `eqReal_id`
Fix :
CREATE UNIQUE INDEX `unique` ON `eqLogic` (`name` ASC,`object_id` ASC)
Fix :
CREATE INDEX `eqTypeName` ON `eqLogic` (`eqType_name` ASC)
Fix :
CREATE INDEX `name` ON `eqLogic` (`name` ASC)
Fix :
CREATE INDEX `logical_id` ON `eqLogic` (`logicalId` ASC)
Fix :
CREATE INDEX `object_id` ON `eqLogic` (`object_id` ASC)
Fix :
CREATE INDEX `timeout` ON `eqLogic` (`timeout` ASC)
Fix :
CREATE INDEX `generic_type` ON `eqLogic` (`generic_type` ASC)
Fix :
CREATE INDEX `tags` ON `eqLogic` (`tags` ASC)
Fix : ALTER TABLE `eqLogic` DROP INDEX `logica_id_eqTypeName`;
Fix : ALTER TABLE `eqLogic` DROP INDEX `eqReal_id`;
Fix : ALTER TABLE `eqLogic` DROP INDEX `logicalId`;
Fix : ALTER TABLE `historyArch` DROP INDEX `cmd_id_index`;
Fix : ALTER TABLE `interactDef` ADD `display` text NULL
Fix : ALTER TABLE `interactDef` ADD `comment` text NULL
Fix : ALTER TABLE `message` ADD `occurrences` int(11) NULL
Fix : ALTER TABLE `object` DROP INDEX `name_UNIQUE`;
Fix : ALTER TABLE `object` DROP INDEX `fk_object_object1_idx1`;
Fix : ALTER TABLE `object` DROP INDEX `position`;
Fix : ALTER TABLE `object` MODIFY COLUMN `name` varchar(127) NOT NULL
Fix :
CREATE UNIQUE INDEX `name_UNIQUE` ON `object` (`name` ASC)
Fix :
CREATE INDEX `fk_object_object1_idx1` ON `object` (`father_id` ASC)
Fix :
CREATE INDEX `position` ON `object` (`position` ASC)
Fix : ALTER TABLE `plan3dHeader` ADD `order` int(11) NULL
Fix : CREATE INDEX `order` ON `plan3dHeader` (`order` ASC)
Fix : ALTER TABLE `planHeader` ADD `order` int(11) NULL
Fix : CREATE INDEX `order` ON `planHeader` (`order` ASC)
Fix : ALTER TABLE `scenario` DROP `type`
Fix : ALTER TABLE `scenario` DROP INDEX `group`;
Fix : ALTER TABLE `update` ADD `updateDate` datetime NULL
Fix : ALTER TABLE `viewData` DROP INDEX `fk_data_zone1_idx`;
Fix : CREATE TABLE IF NOT EXISTS `widgets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(191) NOT NULL,
`type` varchar(27) NULL,
`subtype` varchar(27) NULL,
`template` varchar(255) NULL,
`display` text NULL,
`replace` text NULL,
`test` text NULL,
primary key(`id`))
ENGINE InnoDB;
CREATE UNIQUE INDEX `unique` ON `widgets` (`type` ASC,`subtype` ASC,`name` ASC)
Fix : CREATE TABLE IF NOT EXISTS `timeline` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`folder` varchar(255) NULL,
`type` varchar(27) NULL,
`subtype` varchar(27) NULL,
`link_id` varchar(27) NULL,
`name` varchar(255) NULL,
`datetime` datetime NOT NULL,
`options` text NULL,
primary key(`id`,`datetime`))
ENGINE InnoDB;
CREATE INDEX `datetime` ON `timeline` (`datetime` ASC)[END CHECK AND FIX DB]
Check jeedom database...OK
Suppression de : scenario::doIn() car il n'y a pas de lancement prévu
Suppression de : scenario::doIn() car il n'y a pas de lancement prévu
Check filesystem right...PHP Fatal error: Uncaught Error: Call to undefined method jeedom::cleanFileSystemRight() in /var/www/html/install/consistency.php:372
Stack trace:
#0 /var/www/html/install/update.php(348): require_once()
#1 {main}
thrown in /var/www/html/install/consistency.php on line 372