Question: 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?

Answer: 
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