Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql_mode error during "php artisan migrate" #2

Open
jonesluster opened this issue Apr 2, 2017 · 0 comments
Open

sql_mode error during "php artisan migrate" #2

jonesluster opened this issue Apr 2, 2017 · 0 comments

Comments

@jonesluster
Copy link

Received this error. Looks like this code was written in a style that is no longer allowed by MySQL.

[Exception]
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'creat
ed_at' (SQL: create table users (id int unsigned not null auto_increment primary key
, name varchar(32) not null, username varchar(32) not null, email varchar(320) not
null, password varchar(64) not null, created_at timestamp default 0 not null, upda ted_at timestamp default 0 not null) default character set utf8 collate utf8_unicode_ci
) (Bindings: array (
))

There appear to be some workarounds, but it would be nice to have this very good example source updated.

Best regards,

Kevin

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant