Page 1 of 1
Aggiornamento da Docebo 4.0.5 a Formalms 2.3
Posted: Tue Dec 03, 2019 11:47 am
by 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?
Re: Aggiornamento da Docebo 4.0.5 a Formalms 2.3
Posted: Wed Dec 04, 2019 9:37 am
by 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`;
Re: Aggiornamento da Docebo 4.0.5 a Formalms 2.3
Posted: Thu Dec 05, 2019 12:58 pm
by arturo1111
Ho fatto ma ricevo ccomunque l'errore forse bisogna modificare altre righe dello script sql?
Re: Aggiornamento da Docebo 4.0.5 a Formalms 2.3
Posted: Thu Dec 05, 2019 1:12 pm
by alfa24
Lo stesso errore?
Re: Aggiornamento da Docebo 4.0.5 a Formalms 2.3
Posted: Fri Dec 06, 2019 9:44 am
by 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
Re: Aggiornamento da Docebo 4.0.5 a Formalms 2.3
Posted: Fri Dec 06, 2019 10:38 am
by 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`);
Re: Aggiornamento da Docebo 4.0.5 a Formalms 2.3
Posted: Fri Dec 06, 2019 11:30 am
by arturo1111
Aggiormanento riuscito. Grazie infinite!