Bug upgrade da 2.3 a 2.4

Segnalate qui eventuali problemi riscontrati durante il normale utilizzo
Post Reply
MaxTer
FormaLms User
Posts: 62
Joined: Mon Nov 19, 2018 6:53 am
Version: forma.lms 2.0

Bug upgrade da 2.3 a 2.4

Post by MaxTer »

buongiorno, segnalo che tentando l'upgrade da 2.3 a 2.4 ottengo questo errore:
Upgrade db with file: xxxxxxxx/upgrade/data/upg_data/20400_db.sqlTable '2223.learning_report_schedule' doesn't exist
Grazie e buona giornata

MaxTer
FormaLms User
Posts: 62
Joined: Mon Nov 19, 2018 6:53 am
Version: forma.lms 2.0

Re: Bug upgrade da 2.3 a 2.4

Post by MaxTer »

buongiorno ho risolto eseguendo manualmente questo codice sql:
CREATE TABLE `learning_report_schedule` (
`id_report_schedule` int(11) UNSIGNED NOT NULL,
`id_report_filter` int(11) UNSIGNED NOT NULL DEFAULT '0',
`id_creator` int(11) UNSIGNED NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`period` varchar(255) NOT NULL DEFAULT '',
`time` time NOT NULL DEFAULT '00:00:00',
`creation_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`enabled` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
`last_execution` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `learning_report_schedule`
ADD PRIMARY KEY (`id_report_schedule`);

ALTER TABLE `learning_report_schedule`
MODIFY `id_report_schedule` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

User avatar
CisterNino
FormaLms User
Posts: 40
Joined: Mon May 06, 2013 2:59 pm

Re: Bug upgrade da 2.3 a 2.4

Post by CisterNino »

In realtà nello script di setup del db (install/data/sql/lms.sql) della versione 2.3 di forma, la creazione della tabella learning_report_schedule, è già presente.
I'm Livio, the Two. If you need, you can contact the one.

Post Reply