formcreator
formcreator copied to clipboard
Error when try update 2.13.6 to 2.13.9
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
@btry can u help us?
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.
If I delete the table, won't I lose the data contained within? Won't this cause problems or lack of data when updating?
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)