The Elearning Community • New Release - Forma 2.4.1 - Page 2
Page 2 of 3

Re: New Release - Forma 2.4.1

Posted: Fri Mar 20, 2020 4:03 pm
by fg123
Hi there,
just running upgrade from 2.4.0 to 2.4.1 - please help.


Upgrade database error


Upgrading to version: 2.4.1
Result: ERROR !!!

Upgrade db with file: /var/www/html/forma/formalms/upgrade/data/upg_data/20401_db.sqlDuplicate entry 'smtp_auto_tls' for key 'PRIMARY' Duplicate entry 'smtp_debug' for key 'PRIMARY'
------

Re: New Release - Forma 2.4.1

Posted: Fri Mar 20, 2020 5:37 pm
by fg123
Well, I removed smtp_debug and smtp_auto_tls from core_settings table and the update ran. Maybe you should use IGNORE in the SQL script as well?


fg123 wrote:
Fri Mar 20, 2020 4:03 pm
Hi there,
just running upgrade from 2.4.0 to 2.4.1 - please help.


Upgrade database error


Upgrading to version: 2.4.1
Result: ERROR !!!

Upgrade db with file: /var/www/html/forma/formalms/upgrade/data/upg_data/20401_db.sqlDuplicate entry 'smtp_auto_tls' for key 'PRIMARY' Duplicate entry 'smtp_debug' for key 'PRIMARY'
------

Re: New Release - Forma 2.4.1

Posted: Fri Mar 20, 2020 6:39 pm
by alfa24
Post content of /upgrade/data/upg_data/20401_db.sql to get help

Re: New Release - Forma 2.4.1

Posted: Fri Mar 20, 2020 6:55 pm
by fg123
The two lines producing errors don't have the "IGNORE" in it.

INSERT IGNORE INTO core_setting (param_name, param_value, value_type, max_size, pack, regroup, sequence, param_load, hide_in_modify, extra_info)
VALUES ('smtp_host', '', 'string', 255, 'Smtp Host', 14, 1, 1, 0, '');

INSERT IGNORE INTO core_setting (param_name, param_value, value_type, max_size, pack, regroup, sequence, param_load, hide_in_modify, extra_info)
VALUES ('smtp_port', '', 'string', 255, 'Smtp Port', 14, 2, 1, 0, '');

INSERT IGNORE INTO core_setting (param_name, param_value, value_type, max_size, pack, regroup, sequence, param_load, hide_in_modify, extra_info)
VALUES ('smtp_secure', '', 'string', 255, 'Smtp Secure', 14, 3, 1, 0, '');

INSERT IGNORE INTO core_setting (param_name, param_value, value_type, max_size, pack, regroup, sequence, param_load, hide_in_modify, extra_info)
VALUES ('smtp_user', '', 'string', 255, 'Smtp User', 14, 4, 1, 0, '');

INSERT IGNORE INTO core_setting (param_name, param_value, value_type, max_size, pack, regroup, sequence, param_load, hide_in_modify, extra_info)
VALUES ('smtp_pwd', '', 'string', 255, 'Smtp Password', 14, 5, 1, 0, '');

INSERT INTO `core_setting` (`param_name`, `param_value`, `value_type`, `max_size`, `pack`, `regroup`, `sequence`, `param_load`, `hide_in_modify`, `extra_info`)
VALUES ('smtp_auto_tls', '', 'on_off', 255, 'Smtp Auto TLS', 14, 7, 1, 0, '');

INSERT INTO `core_setting` (`param_name`, `param_value`, `value_type`, `max_size`, `pack`, `regroup`, `sequence`, `param_load`, `hide_in_modify`, `extra_info`)
VALUES ('smtp_debug', '0', 'string', 255, 'Smtp Debug', 14, 8, 1, 0, '');

Re: New Release - Forma 2.4.1

Posted: Fri Mar 20, 2020 7:47 pm
by alfa24
replace the following:

INSERT INTO `core_setting` (`param_name`, `param_value`, `value_type`, `max_size`, `pack`, `regroup`, `sequence`, `param_load`, `hide_in_modify`, `extra_info`)
VALUES ('smtp_auto_tls', '', 'on_off', 255, 'Smtp Auto TLS', 14, 7, 1, 0, '');

INSERT INTO `core_setting` (`param_name`, `param_value`, `value_type`, `max_size`, `pack`, `regroup`, `sequence`, `param_load`, `hide_in_modify`, `extra_info`)
VALUES ('smtp_debug', '0', 'string', 255, 'Smtp Debug', 14, 8, 1, 0, '');

with:

INSERT IGNORE INTO `core_setting` (`param_name`, `param_value`, `value_type`, `max_size`, `pack`, `regroup`, `sequence`, `param_load`, `hide_in_modify`, `extra_info`)
VALUES ('smtp_auto_tls', '', 'on_off', 255, 'Smtp Auto TLS', 14, 7, 1, 0, '');

INSERT IGNORE INTO `core_setting` (`param_name`, `param_value`, `value_type`, `max_size`, `pack`, `regroup`, `sequence`, `param_load`, `hide_in_modify`, `extra_info`)
VALUES ('smtp_debug', '0', 'string', 255, 'Smtp Debug', 14, 8, 1, 0, '');

Re: New Release - Forma 2.4.1

Posted: Fri Mar 20, 2020 9:34 pm
by fg123
Yes sure - thanks, as I've written before, my upgrade ran through as soon as I deleted the values in the table, but maybe you should change the upgrade script in the installation zip file.
Regards
Frank

Re: New Release - Forma 2.4.1

Posted: Fri Mar 20, 2020 9:41 pm
by alfa24
I'm not responsible of the upgrade script, just help others.

Re: New Release - Forma 2.4.1

Posted: Wed Apr 15, 2020 10:39 am
by marciozebedeu
Hi !!

I'm trying to download version 2.4 but I can't. Do you have any details I haven't figured out yet?

thanks

Re: New Release - Forma 2.4.1

Posted: Wed Apr 15, 2020 11:35 am
by max
marciozebedeu wrote:
Wed Apr 15, 2020 10:39 am
Hi !!

I'm trying to download version 2.4 but I can't. Do you have any details I haven't figured out yet?

thanks
Hi Marcio, the latest version is always reserved to individual members or company members of our association, not to "registered users" that can only post on the forum.

Re: New Release - Forma 2.4.1

Posted: Thu May 07, 2020 2:02 pm
by putuardi
How to get it ?

This site uses cookies.

Some of the cookies we use are essential for parts of the site to operate and have already been set. We also use Google Analytics scripts, which all use cookies.
You may delete or block all cookies from this site in your browser options.