In phpMyAdmin creating of a new column in _users structure leads to an error #1067

Question

If I insert anything new column it shows the error #1067. If I delete last six column then I can add but again can't enter the 6 column back.

Check [this](http://stackoverflow.com/questions/13063980/mysql-default-datetime-through-phpmyadmin) for reference. — Yash, Jun 08 '16 at 06:41

score 0 · Accepted Answer · answered Jun 08 '16 at 06:48

0

In your table registerDate column you have to remove default value. because its not correct format for the given type

answered Jun 08 '16 at 06:48

Mani

Thanks, I change default to current_timestamp now it's working – Awwab Jun 08 '16 at 07:11

1 Answers1