You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2020-12-09 07:42:58

livier
Member
Registered: 2016-11-15
Posts: 172

FORMCREATOR-V2.5.2 --> V2.10.0-formcreator_forms_answers' doesn't exis

Bonjour,

Je suis en GLPi V9.1.3 avec le plugin formcreator en v2.5.2.
Je souhaiterai migrer en GLPi V9.4.6 avec le plugin formcreator en v2.10.0

Lorsque j'essaie d'installer le plugin, je rencontre le message d'erreur suivant :

Changement de la structure de la base de données - glpi_plugin_formcreator_forms_answers (0 seconde)
2.10.0 multiple alter in glpi_plugin_formcreator_forms_answers - Erreur durant l'éxecution de la requête : ALTER TABLE `glpi_plugin_formcreator_forms_answers` ADD `users_id_validator` INT(11) NOT NULL DEFAULT '0' AFTER `requester_id` , ADD `groups_id_validator` INT(11) NOT NULL DEFAULT '0' AFTER `users_id_validator` , ADD INDEX `users_id_validator` (`users_id_validator`) , ADD INDEX `groups_id_validator` (`groups_id_validator`) - 
L'erreur est Table 'glpi.glpi_plugin_formcreator_forms_answers' doesn't exist

D'avance merci pour votre aide

Offline

#2 2020-12-09 09:32:44

btry
Moderator
Registered: 2015-10-01
Posts: 588

Re: FORMCREATOR-V2.5.2 --> V2.10.0-formcreator_forms_answers' doesn't exis

Bonjour

Pouvez vous vérifier si dans glpi/files/_log/migration_to_2.10.0.log vous retrouvez l'erreur accompagnée d'un backtrace ?

Prévoyez également d'upgrader en 2.10.4 une fois votre problème résolu.


No support with MP - Always run an upgrade task on a testing instance before running it on production! Always backup before any upgrade task!

Offline

#3 2020-12-09 10:28:55

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 6,146

Re: FORMCREATOR-V2.5.2 --> V2.10.0-formcreator_forms_answers' doesn't exis

bonjour,
pour info, j'ai du passer par la version 2.7 du plugin  lorsque j'ai mis à jour mon GLPI de 9.1.6 à 9.4.6


Trouver la panne avant de réparer...
GLPI10.0.10 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6

Offline

#4 2020-12-09 10:29:00

livier
Member
Registered: 2016-11-15
Posts: 172

Re: FORMCREATOR-V2.5.2 --> V2.10.0-formcreator_forms_answers' doesn't exis

Bonjour,

Merci pour votre réponse.
Je ne vois rien de parlant dans le fichier log cité :

2020-11-18 09:10:58 [24@glpi.fr]
0 seconde for "Upgrade to schema version 2.6" @ 2020-11-18 09:10:58 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-11-18 09:10:59 [24@glpi.fr]
1 seconde for "Upgrade glpi_plugin_formcreator_questions" @ 2020-11-18 09:10:59 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-11-18 09:11:00 [24@glpi.fr]
1 seconde for "Changement de la structure de la base de données - glpi_plugin_formcreator_forms_answers" @ 2020-11-18 09:11:00 [24@glpi.fr]
0 seconde for "Changement de la structure de la base de données - glpi_plugin_formcreator_targettickets" @ 2020-11-18 09:11:01 [24@glpi.fr]
1 seconde for "Changement de la structure de la base de données - glpi_plugin_formcreator_forms_answers" @ 2020-11-18 09:11:09 [24@glpi.fr]
8 secondes for "Changement de la structure de la base de données - glpi_plugin_formcreator_answers" @ 2020-11-18 09:11:09 [24@glpi.fr]
0 seconde for "Traitement terminé." @ 2020-11-18 09:11:09 [24@glpi.fr]
0 seconde for "Traitement terminé." @ 2020-11-18 09:11:09 [24@glpi.fr]
0 seconde for "Done" @ 2020-11-18 09:11:19 [24@glpi.fr]
0 seconde for "Traitement terminé." @ 2020-11-18 09:11:19 [24@glpi.fr]
0 seconde for "Done" @ 2020-11-18 09:11:19 [24@glpi.fr]
0 seconde for "Traitement terminé." @ 2020-11-18 09:11:19 [24@glpi.fr]
0 seconde for "Done" @ 2020-11-18 09:12:56 [24@glpi.fr]
1 minutes 20 secondes for "Changement de la structure de la base de données - glpi_plugin_formcreator_answers" @ 2020-11-18 09:12:56 [24@glpi.fr]
0 seconde for "Changement de la structure de la base de données - glpi_plugin_formcreator_formanswers" @ 2020-11-18 09:13:40 [24@glpi.fr]
0 seconde for "Upgrade to schema version 2.6" @ 2020-11-18 09:13:40 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-11-18 09:13:40 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_questions" @ 2020-11-18 09:13:40 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:15:19 [24@glpi.fr]
0 seconde for "Upgrade to schema version 2.6" @ 2020-12-09 03:15:19 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:15:19 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_questions" @ 2020-12-09 03:15:19 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:15:41 [24@glpi.fr]
0 seconde for "Upgrade to schema version 2.6" @ 2020-12-09 03:15:41 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:15:41 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_questions" @ 2020-12-09 03:15:41 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:17:29 [24@glpi.fr]
0 seconde for "Upgrade to schema version 2.6" @ 2020-12-09 03:17:29 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:17:29 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_questions" @ 2020-12-09 03:17:29 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:18:57 [24@glpi.fr]
0 seconde for "Upgrade to schema version 2.6" @ 2020-12-09 03:18:57 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:18:57 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_questions" @ 2020-12-09 03:18:57 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:39:37 [24@glpi.fr]
0 seconde for "Upgrade to schema version 2.6" @ 2020-12-09 03:39:37 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:39:37 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_questions" @ 2020-12-09 03:39:37 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:40:43 [24@glpi.fr]
0 seconde for "Upgrade to schema version 2.6" @ 2020-12-09 03:40:43 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:40:43 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_questions" @ 2020-12-09 03:40:43 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:56:10 [24@glpi.fr]
0 seconde for "Upgrade to schema version 2.6" @ 2020-12-09 03:56:10 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 03:56:10 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_questions" @ 2020-12-09 03:56:10 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 05:35:41 [24@glpi.fr]
0 seconde for "Upgrade to schema version 2.6" @ 2020-12-09 05:35:41 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 2020-12-09 05:35:41 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_questions" @ 2020-12-09 05:35:41 [24@glpi.fr]
0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 

REMARQUE : le log que j'affiche est bien complet. Il se termine bien par la ligne

0 seconde for "Upgrade glpi_plugin_formcreator_forms_answers" @ 

Offline

#5 2020-12-09 10:30:17

livier
Member
Registered: 2016-11-15
Posts: 172

Re: FORMCREATOR-V2.5.2 --> V2.10.0-formcreator_forms_answers' doesn't exis

Bonjour @LaDenrée
Merci pour votre réponse.
On va essayer ça smile

Offline

#6 2020-12-09 10:33:50

btry
Moderator
Registered: 2015-10-01
Posts: 588

Re: FORMCREATOR-V2.5.2 --> V2.10.0-formcreator_forms_answers' doesn't exis

Bien qu'il n'y a pas de backtrace, je sais déjà que l'erreur survient dans la migration 2.5.2 vers 2.6.x. J'ai l'information qu'il me faut.

J'attends le résultat de votre essai d'upgrade intermédiaire vers 2.7.


No support with MP - Always run an upgrade task on a testing instance before running it on production! Always backup before any upgrade task!

Offline

#7 2020-12-23 09:49:03

livier
Member
Registered: 2016-11-15
Posts: 172

Re: FORMCREATOR-V2.5.2 --> V2.10.0-formcreator_forms_answers' doesn't exis

Bonjour,

Désolé pour ma réponse tardive.
Je confirme que l'upgrade intermédiaire en 2.7 résout mon problème.
Pour résumer :
V2.5.2 --> V2.7 --> 2.10.4

Merci beaucoup pour votre aide

Offline

Board footer

Powered by FluxBB