Level 6
Do you know what column and/or migration this is about? And could you post the exact error given by MySQL?
Jan 12, 2016
5
Level 2
mysql gives error that there can only be one TIMESTAMP column while doing migration
i installed a fresh copy of laravel this morning, on migration, mysql throws up an error that there can only be on TIMESTAMP column, migration works just fine the first time i used laravel, what has changed?
Level 2
its the timestamps column that's causing the error, created_at and updated_at, this is the error message i returned by terminal
[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 1293 Incorrect table definition; there can
be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE
clause (SQL: create table tasks (id int unsigned not null auto_increme
nt primary key, name varchar(255) not null, created_at timestamp defaul
t CURRENT_TIMESTAMP not null, updated_at timestamp default CURRENT_TIMEST
AMP not null) default character set utf8 collate utf8_unicode_ci)
[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 1293 Incorrect table definition; there can
be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE
clause (SQL: create table tasks (id int unsigned not null auto_increme
nt primary key, name varchar(255) not null, created_at timestamp defaul
t CURRENT_TIMESTAMP not null, updated_at timestamp default CURRENT_TIMEST
AMP not null) default character set utf8 collate utf8_unicode_ci)
thanks in advance...
Level 5
Level 2
@kingabel, thanks alot, i went through the solutions given, i adjusted the tables manually which worked fine but the problem is that i want laravel to create my tables with the right columns. thats where the problem is. how can i fix the problem from laravel...thanks
Level 41
I'm guessing you're using an older version of MySQL. Try updating that to 5.6.5.
Please or to participate in this conversation.