Page 1 of 1

Can't update 1.45.00 to 1.46.01

Posted: 23 Mar 2020, 10:17
by Ralf
Copied new 1.46.01 files on existing 1.45.00 version and Login screen shows:

Upgrading to version 1.46.00
Failed to upgrade database, please contact support@soplanning.org with full details.
upgrade failed :
1.46.00
request failed :
ALTER TABLE `planning_user` ADD `date_creation` DATETIME NOT NULL AFTER `login_actif`

:(

Re: Can't update 1.45.00 to 1.46.01

Posted: 23 Mar 2020, 10:23
by soplanning
Hello
Can you run manually this query in phpmyadmin and let us know what is the error ?
it seems some users have the same problem, depending on their server settings.
thanks

Re: Can't update 1.45.00 to 1.46.01

Posted: 23 Mar 2020, 11:19
by Ralf
ALTER TABLE `planning_user` ADD `date_creation` DATETIME NOT NULL AFTER `login_actif`

MySQL meldet:
#1292 - Falscher datetime-Wert: '0000-00-00 00:00:00' für Feld 'date_creation' in Zeile 1

Re: Can't update 1.45.00 to 1.46.01

Posted: 23 Mar 2020, 11:39
by soplanning
can you try this please :
ALTER TABLE `planning_user` ADD `date_creation` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `login_actif`;
and run the rest of the sql file

Re: Can't update 1.45.00 to 1.46.01

Posted: 23 Mar 2020, 12:48
by Ralf
Upgrading to version 1.46.00
Database upgrade ok for version 1.46.00
Upgrading to version 1.46.01
Database upgrade ok for version 1.46.01
:D
Merci beaucoup
Great job
Stay healthy