1

Topic: 1292, Incorrect datetime value: when adding domain in iredadmin

0.9.6 MYSQL edition.
Ubuntu 16.04.2 LTS
Nginx

I've migrated from an old very stable iredmail installation to most recent version.

When adding a new domain in iredadmin, I get error 
     Error: (1292, "Incorrect datetime value: '0000-00-00 00:00:00' for column 'modified' at row 1")

Any help gratefully received.
Matt

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: 1292, Incorrect datetime value: when adding domain in iredadmin

joyma wrote:

0.9.6 MYSQL edition.
Ubuntu 16.04.2 LTS
Nginx

I've migrated from an old very stable iredmail installation to most recent version.

When adding a new domain in iredadmin, I get error 
     Error: (1292, "Incorrect datetime value: '0000-00-00 00:00:00' for column 'modified' at row 1")

Any help gratefully received.
Matt

3

Re: 1292, Incorrect datetime value: when adding domain in iredadmin

Changing sql_mode in mysqld.cnf fixed this error, but is this correct and are there any side effects of this?

[mysqld]
sql_mode=""

4

Re: 1292, Incorrect datetime value: when adding domain in iredadmin

This has been fixed in iRedMail-0.9.6, and mentioned in iRedMail upgrade tutorial:
http://www.iredmail.org/docs/upgrade.ir … nd-special