Page 1 of 1

Bug upgrade da 2.3 a 2.4

Posted: Mon Dec 02, 2019 9:48 am
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

Re: Bug upgrade da 2.3 a 2.4

Posted: Wed Dec 04, 2019 9:40 am
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;

Re: Bug upgrade da 2.3 a 2.4

Posted: Mon Dec 09, 2019 2:45 pm
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.