On Jun 30, 2017, at 7:56 PM, Noel Butler <noel.butler@ausics.net> 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

bin/update.sh doesn't print SQL errors
https://github.com/roundcube/roundcubemail/issues/5834


Paul