pluginsGLPI / formcreator

GLPI Plugin Formcreator (DOWNLOAD : https://github.com/pluginsGLPI/formcreator/releases)
http://www.teclib-edition.com
GNU General Public License v3.0
174 stars 125 forks source link

Error when try update 2.13.6 to 2.13.9 #3498

Open breninferreira opened 7 months ago

breninferreira commented 7 months ago

Describe the bug Hi when try update 2.13.6 to 2.13.9 in CLI mode, we have this error:

Unknown table "glpi_plugin_formcreator_forms_answers" was found in the database.
--- Expected database schema
+++ Current database schema
@@ @@
+CREATE TABLE glpi_plugin_formcreator_forms_answers (
+  id int unsigned NOT NULL AUTO_INCREMENT,
+  comment text,
+  entities_id int unsigned NOT NULL DEFAULT 0,
+  groups_id_validator int unsigned,
+  is_deleted tinyint NOT NULL DEFAULT 0,
+  is_recursive tinyint NOT NULL DEFAULT 0,
+  name varchar(255) NOT NULL DEFAULT '',
+  plugin_formcreator_forms_id int unsigned NOT NULL,
+  request_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  requester_id int unsigned,
+  status enum('waiting','refused','accepted') NOT NULL DEFAULT 'waiting',
+  users_id_validator int unsigned,
+  PRIMARY KEY (id),
+  KEY entities_id_is_recursive (entities_id,is_recursive),
+  KEY groups_id_validator (groups_id_validator),
+  KEY plugin_formcreator_forms_id (plugin_formcreator_forms_id),
+  KEY requester_id (requester_id),
+  KEY users_id_validator (users_id_validator)
+) COLLATE=utf8mb4_unicode_ci DEFAULT CHARSET=utf8mb4 ENGINE=InnoDB

image

@btry can u help us?

btry commented 7 months ago

Hi

When you upgraded to any version 2.13.x you should have this error. Then you did not fix it at least once, probably by disabling the database check.

Take a backup of this table and delete it, then try again to upgrade.

breninferreira commented 7 months ago

If I delete the table, won't I lose the data contained within? Won't this cause problems or lack of data when updating?

btry commented 7 months ago

Hi this table shall no longer exist. Actually it was renamed long ago. Take a backup of it, then delete it. The database check system says it does not exists in the version 2.13.6 (the version you had prior the upgrade)