On Jun 30, 2017, at 7:56 PM, Noel Butler <[email protected]> wrote:
> What version of php?
This is PHP 7. The problem turned out to be update.sh failing to execute the
migrations.
What version are you upgrading from? Type '?' if you don't know.
?
Executing database schema update.
Updating database schema (2015111100)... [FAILED]
NOTE: Update dependencies by running `php composer.phar update --no-dev`
Running this manually:
mysql> ALTER TABLE `users`
-> ADD `failed_login` datetime DEFAULT NULL,
-> ADD `failed_login_counter` int(10) UNSIGNED DEFAULT NULL;
ERROR 1067 (42000): Invalid default value for 'created'
Looking in mysql.initial.sql, I see the default values for created are
1000-01-01 00:00:00.
I ran this SQL to fix it:
alter table users modify created datetime NOT NULL default '1000-01-01
00:00:00';
alter table session modify changed datetime NOT NULL default '1000-01-01
00:00:00',
modify created datetime NOT NULL default '1000-01-01 00:00:00';
Filed:
bin/update.sh fails if sql_mode contains NO_ZERO_IN_DATE,NO_ZERO_DATE
https://github.com/roundcube/roundcubemail/issues/5833
<https://github.com/roundcube/roundcubemail/issues/5833>
bin/update.sh doesn't print SQL errors
https://github.com/roundcube/roundcubemail/issues/5834
<https://github.com/roundcube/roundcubemail/issues/5834>
Paul
_______________________________________________
Roundcube Users mailing list
[email protected]
http://lists.roundcube.net/mailman/listinfo/users
