Alors voilà je rencontre un petit soucis avec mon installation Jeedom.
Jusqu’à aujourd’hui mon Jeedom tournait sur un rpi3 en v3.
Je me suis enfin décidé à migrer en v4 car ayant un peu de temps devant moi.
Mais pour le coup je me suis dit autant virtualiser Jeedom sur mon nouveau NAS.
Allez hop création d’une VM, installation de Debian 10 puis de Jeedom v4.
Puis j’ai restauré mon backup de Jeedom v3 dessus.
Tout à bien fonctionné sauf que Jeedom pense qu’il est toujours en v3.
Bon pas grave je me suis dit que j’allais lancer la migration vers v4 mais là petit soucis, la migration se bloque sur : thrown in /var/www/html/core/class/DB.class.php on line 105 et là c’est le drame erreur de partout…
Voilà du coup je ne sais pas comment faire pour restaurer cette sauvegarde v3 sur une installation v4 sans que Jeedom ne pense être en v3.
Je vous remercie par avance pour vos informations.
En vrai c’est normal, le backup est en v3 donc la restauration « restaure » ton Jeedom en v3. Même s’il était installé en v4 tout neuf.
Donc pas le choix, il faut corriger l’erreur, d’ailleurs si tu pouvais mettre le message complet (la on a juste le fichier et la ligne).
Je viens de retenter la migration vers la v4 depuis le menu « Centre de mise à jour » et voici où se bloque la maj :
[START UPDATE]
****Update from 3.3.59 (2022-05-16 22:24:46)****
Parameters : {"preUpdate":"0","backup::before":"1","plugins":"1","core":"1","force":"0"," update::reapply":"0"}
Send begin of update event...OK
Check update...OK
Check rights...
OK
[START BACKUP]
***************Start of Jeedom backup at 2022-05-16 22:24:47***************
Envoi l'évènement de début de sauvegarde...OK
Vérification des droits sur les fichiers...OK
Vérification de la base de données...
OK
Sauvegarde la base de données...
OK
Persistance du cache :
OK
Création de l'archive...
OK
Nettoyage de l'ancienne sauvegarde...OK
Limitation de la taille des sauvegardes à 2048 Mo...
OK
Nom de la sauvegarde : /var/www/html/core/php/../../backup/backup-Jeedom-3.3.59-2022-05-16-22h24.tar.gz
Vérification des droits sur les fichiers...OK
Envoi l'évènement de fin de sauvegarde...OK
Durée de la sauvegarde : 20s
***************Fin de la sauvegarde de Jeedom***************
[END BACKUP SUCCESS]
Disable all task
.
kill: (29767): No such process
. OK
Disable all scenario................... OK
Download url : https://github.com/jeedom/core/archive/V4-stable.zip
Download in progress...--2022-05-16 22:25:09-- 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-05-16 22:25:10-- 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: 82120395 (78M) [application/zip]
Saving to: '/tmp/jeedom/install/jeedom_update.zip'
0K ........ ........ ........ ........ ........ ........ 3% 15.4M 5s
3072K ........ ........ ........ ........ ........ ........ 7% 23.2M 4s
6144K ........ ........ ........ ........ ........ ........ 11% 34.8M 3s
9216K ........ ........ ........ ........ ........ ........ 15% 19.0M 3s
12288K ........ ........ ........ ........ ........ ........ 19% 36.5M 3s
15360K ........ ........ ........ ........ ........ ........ 22% 18.9M 3s
18432K ........ ........ ........ ........ ........ ........ 26% 29.5M 2s
21504K ........ ..
...... ........ ........ ........ ........ 30% 22.2M 2s
24576K ........ ........ ........ ........ ........ ........ 34% 34.9M 2s
27648K ........ ........ ........ ........ ........ ........ 38% 33.4M 2s
30720K ........ ........ ........ ........ ........ ........ 42% 20.0M 2s
33792K ........ ........ ........ ........ ........ ........ 45% 37.2M 2s
36864K ........ ........ ........ ........ ........ ........ 49% 34.9M 2s
39936K ........ ........ ........ ........ ........ ........ 53% 18.4M 1s
43008K ........ ........ ........ ........ ........ ........ 57% 35.8M 1s
46080K ........ ........ ........ ........ ........ ........ 61% 35.8M 1s
49152K ........ ........ ........ ........ ........ ...
..... 65% 21.1M 1s
52224K ........ ........ ........ ........ ........ ........ 68% 34.0M 1s
55296K ........ ........ ........ ........ ........ ........ 72% 33.7M 1s
58368K ........ ........ ........ ........ ........ ........ 76% 20.3M 1s
61440K ........ ........ ........ ........ ........ ........ 80% 29.7M 1s
64512K ........ ........ ........ ........ ........ ........ 84% 43.7M 0s
67584K ........ ........ ........ ........ ........ ........ 88% 33.8M 0s
70656K ........ ........ ........ ........ ........ ........ 91% 21.1M 0s
73728K ........ ........ ........ ........ ........ ........ 95% 35.8M 0s
76800K ........ ........ ........ ........ ........ ........ 99% 34.9M 0s
79872K ..... 100% 213M=2.9s
2022-05-16 22:25:13 (26.9 MB/s) - '/tmp/jeedom/install/jeedom_update.zip' saved [82120395/82120395]
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/cerulean/Suppression theme /var/www/html/install/update/../../core/themes/cosmo/Suppression theme /var/www/html/install/update/../../core/themes/cyan/Suppression theme /var/www/html/install/update/../../core/themes/cyborg/Suppression theme /var/www/html/install/update/../../core/themes/darkly/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/flatly/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/indigo/Suppression theme /var/www/html/install/update/../../core/themes/journal/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/lumen/Suppression theme /var/www/html/install/update/../../core/themes/orange/Suppression theme /var/www/html/install/update/../../core/themes/paper/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/readable/Suppression theme /var/www/html/install/update/../../core/themes/red/Suppression theme /var/www/html/install/update/../../core/themes/sandstorn/Suppression theme /var/www/html/install/update/../../core/themes/simplex/Suppression theme /var/www/html/install/update/../../core/themes/slate/Suppression theme /var/www/html/install/update/../../core/themes/spacelab/Suppression theme /var/www/html/install/update/../../core/themes/superhero/Suppression theme /var/www/html/install/update/../../core/themes/teal/Suppression theme /var/www/html/install/update/../../core/themes/united/Suppression theme /var/www/html/install/update/../../core/themes/yellow/Suppression theme /var/www/html/install/update/../../core/themes/yeti/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...Begin migrate planOK
Update system into : 4.0.6...
OK
Update system into : 4.0.11...OK
Update system into : 4.0.15...OK
Update system into : 4.0.23...
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...
Fix repo issueOK
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 `eqReal_id`;
Fix : ALTER TABLE `eqLogic` DROP INDEX `logica_id_eqTypeName`;
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
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
