Database Error: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'date'

SQL: ALTER TABLE `comments` CHANGE `date` `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `status` The error has been logged in /anchor/errors.log

Uncaught Exception

Uncaught Exception

Database Error: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'date'

SQL: ALTER TABLE `comments` CHANGE `date` `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `status`

Origin

system/database/connector.php on line 75

Trace

#0 [internal function]: System\database\connector->ask('ALTER TABLE `co...')
#1 /home/host1233889/dogfaq.ru/htdocs/www/system/database.php(107): call_user_func_array(Array, Array)
#2 /home/host1233889/dogfaq.ru/htdocs/www/anchor/migrations/21_alter_comments_date.php(12): System\database::__callStatic('ask', Array)
#3 /home/host1233889/dogfaq.ru/htdocs/www/anchor/migrations/21_alter_comments_date.php(12): System\database::ask('ALTER TABLE `co...')
#4 /home/host1233889/dogfaq.ru/htdocs/www/anchor/libraries/migrations.php(64): Migration_alter_comments_date->up()
#5 /home/host1233889/dogfaq.ru/htdocs/www/anchor/libraries/anchor.php(126): migrations->up(220)
#6 /home/host1233889/dogfaq.ru/htdocs/www/anchor/libraries/anchor.php(42): anchor::migrations()
#7 /home/host1233889/dogfaq.ru/htdocs/www/anchor/run.php(45): anchor::setup()
#8 /home/host1233889/dogfaq.ru/htdocs/www/system/start.php(28): require('/home/host12338...')
#9 /home/host1233889/dogfaq.ru/htdocs/www/index.php(37): require('/home/host12338...')
#10 {main}