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 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