Aggiornamento da Docebo 4.0.5 a Formalms 2.3

Installazione, configurazione generale, notifiche, API, lingue, problemi server
Post Reply
arturo1111
Newbie
Posts: 10
Joined: Tue Mar 26, 2019 12:55 pm
Version: forma.lms 2.0

Aggiornamento da Docebo 4.0.5 a Formalms 2.3

Post 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?

alfa24
Senior Boarder
Posts: 621
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: Aggiornamento da Docebo 4.0.5 a Formalms 2.3

Post 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`;
I'm Jasmines, the One. If you need, you can contact me.

arturo1111
Newbie
Posts: 10
Joined: Tue Mar 26, 2019 12:55 pm
Version: forma.lms 2.0

Re: Aggiornamento da Docebo 4.0.5 a Formalms 2.3

Post by arturo1111 »

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

alfa24
Senior Boarder
Posts: 621
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: Aggiornamento da Docebo 4.0.5 a Formalms 2.3

Post by alfa24 »

Lo stesso errore?
I'm Jasmines, the One. If you need, you can contact me.

arturo1111
Newbie
Posts: 10
Joined: Tue Mar 26, 2019 12:55 pm
Version: forma.lms 2.0

Re: Aggiornamento da Docebo 4.0.5 a Formalms 2.3

Post 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

alfa24
Senior Boarder
Posts: 621
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: Aggiornamento da Docebo 4.0.5 a Formalms 2.3

Post 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`);
I'm Jasmines, the One. If you need, you can contact me.

arturo1111
Newbie
Posts: 10
Joined: Tue Mar 26, 2019 12:55 pm
Version: forma.lms 2.0

Re: Aggiornamento da Docebo 4.0.5 a Formalms 2.3

Post by arturo1111 »

Aggiormanento riuscito. Grazie infinite!

Post Reply