Unable to add new column due to invalid datetime default value
<p>In my table, I have two columns along with others. These two columns are of <code>DATETIME</code> type, and their value is set to <code>0000-00-00 00:00:00</code> by the previous programmer. Now I just want to add columns with int datatype. However everytime I click save in phpMyAdmin, it says the previous two table are of invalid default value.</p>

<p>So I click on one of them to set the default to none namely <code>registerDate</code> and <code>LastLoginDate</code> columns. Whenever I click save on <code>registerDate</code>, it says <code>LastLoginDate</code> has invalid default value, and whenever I click save on <code>LastLoginDate</code>, it says <code>registerDate</code> has invalid default value. Basically I'mm just unable to change the default value in these two columns, also unable to add any other column.</p>

<p>I did refer to these, but they somehow don't help to solve my issue:</p>

<p><a href="https://stackoverflow.com/questions/13063980/mysql-default-datetime-through-phpmyadmin">MySQL default datetime through phpmyadmin</a></p>

<p><a href="https://stackoverflow.com/questions/3384668/mysql-cannot-insert-null-value-in-column-but-i-have-a-default-value-specified">MySQL - Cannot insert NULL value in column, but I have a default value specified?</a></p>

<p><a href="https://stackoverflow.com/questions/9005766/invalid-default-value-for-dateadded">Invalid default value for &#39;dateAdded&#39;</a></p>