Aggiornamento da Docebo 4.0.5 a Formalms 2.3

[arturo1111]

Tentando di aggiornare da Docebo 4.0.5 su php 5.6 e MariaDB 10.3 ricevo questo errore:

Source pre-upgrade file: /home/docebo/public_html/upgrade/data/upg_data/20000_pre.php
Execute pre-upgrade func: preUpgrade20000
Upgrade db with file: /home/docebo/public_html/upgrade/data/upg_data/20000_db.sqlKey column 'code' doesn't exist in table

Esiste una soluzione nota per questo inconveniente?

[alfa24]

Modifica il file /upgrade/data/upg_data/20000_db.sql.
Trova la riga

Code: Select all

ALTER TABLE `core_plugin` DROP `code`;

e sostituiscila con:

Code: Select all

ALTER TABLE `core_plugin` DROP IF EXISTS `code`;

[arturo1111]

Ho fatto ma ricevo ccomunque l'errore forse bisogna modificare altre righe dello script sql?

[alfa24]

Lo stesso errore?

[arturo1111]

Si stesso errore:


Upgrade database error


Upgrading to version: 2.0
Result: ERROR !!!

Source pre-upgrade file: /home/docebo/public_html/upgrade/data/upg_data/20000_pre.php
Execute pre-upgrade func: preUpgrade20000
Upgrade db with file: /home/docebo/public_html/upgrade/data/upg_data/20000_db.sqlKey column 'code' doesn't exist in table

[alfa24]

Ok.
Allora proviamo così:

ALTER TABLE `core_plugin` DROP INDEX `name`;
ALTER TABLE `core_plugin` DROP IF EXISTS `code`;
ALTER TABLE `core_plugin` ADD UNIQUE (`name`);

[arturo1111]

Aggiormanento riuscito. Grazie infinite!