[mysql] Invalid default value for 'dateAdded'

I got a stupid problem with SQL that I can't fix.

ALTER TABLE  `news` 
 ADD  `dateAdded` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AUTO_INCREMENT ,
 ADD PRIMARY KEY (  `dateAdded` )

Error:

(#1067)Invalid default value for 'dateAdded'

Can somebody help me?

I solved mine by changing DATE to DATETIME

mysql version 5.5 set datetime default value as CURRENT_TIMESTAMP will be report error you can update to version 5.6 , it set datetime default value as CURRENT_TIMESTAMP

Also do note when specifying DATETIME as DATETIME(3) or like on MySQL 5.7.x, you also have to add the same value for CURRENT_TIMESTAMP(3). If not it will keep throwing 'Invalid default value'.

CURRENT_TIMESTAMP is version specific and is now allowed for DATETIME columns as of version 5.6.

See MySQL docs.

I had the same issue, following fix solved my problem.

• Select Type as 'TIMESTAMP'

• DON'T ENTER ANYTHING IN LENGTH/VALUES FIELD. KEEP IT BLANK

• Select CURRENT_TIMESTAMP as Default value.

I am using MySQL ver 5.5.56

Change the type from datetime to timestamp and it will work! I had the same issue for mysql 5.5.56-MariaDB - MariaDB Server Hope it can help... sorry if depricated

I have mysql version 5.6.27 on my LEMP and CURRENT_TIMESTAMP as default value works fine.