I tried generate migration and run, but I get following error:
1528326136.2545: ALTER TABLE `activities` MODIFY `end_time` TIMESTAMP AFTER `start_time`ERROR: SQLSTATE[42000]: Syntax error or access
violation: 1067 Invalid default value for 'end_time'
Some information about phalcon
Phalcon DevTools (3.4.0)
Environment:
OS: Windows NT SHUTLAP_V2 6.1 build 7601 (Windows 7 Professional N Edition Service Pack 1) i586
PHP Version: 7.2.1
PHP SAPI: cli
PHP Bin: D:\Program Files\xampp\php\php.exe
PHP Extension Dir: C:\php\ext
PHP Bin Dir: C:\php
Loaded PHP config: D:\Program Files\xampp\php\php.ini
Versions:
Phalcon DevTools Version: 3.4.0
Phalcon Version: 3.3.1
AdminLTE Version: 2.3.6
EDIT: I turned on the query preview during migration and this query is don't correct
ALTER TABLE activities MODIFY end_time TIMESTAMP AFTER start_time
MySQL version: 5.7.22
EDIT2:
Okay,
sql_mode = "ALLOW_INVALID_DATES"
in my.cnf
solve the problem.