#425 SQL Schema - invalid DATETIME default value

[Anonymous]

# mysql -u root -p phpipam < db/SCHEMA.sql
Enter password: 
ERROR 1067 (42000) at line 20: Invalid default value for 'lastSeen'

Modified 'lastSeen' to: '1000-01-01 00:00:00'

Reference: http://dev.mysql.com/doc/refman/5.7/en/datetime.html

The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.

[Anonymous]

Had the same error trying to install with mysql 5.7.9.

[Miha Petkovsek]

Hi, replace default lastSeen value from ''0000-00-00 00:00:00 to '1000-01-01 00:00:00' or disable mysql strict mode. Will be fixed for 1.3

[Anonymous]

[Anonymous]

[Anonymous]