jawainc / simplecontact

Contact Us plugin for October CMS
6 stars 13 forks source link

can't install #21

Open raskrial opened 7 years ago

raskrial commented 7 years ago

hey, there's an error when installing the plugin :

"SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'created_at' (SQL: create table zainab_simplecontact_contact (id int unsigned not null auto_increment primary key, name varchar(255) null, email varchar(255) null, phone varchar(255) null, subject varchar(255) null, message text null, is_new tinyint(1) not null default '1', created_at timestamp default 0 not null, updated_at timestamp default 0 not null) default character set utf8 collate utf8_unicode_ci engine = InnoDB)" on line 662 of C:\wamp\www\vendor\laravel\framework\src\Illuminate\Database\Connection.php

jawainc commented 7 years ago

it is because of your database sql_modes.

try to remove sql_modes NO_ZERO_IN_DATE, NO_ZERO_DATE

let me know if you are still having problems

vojtasvoboda commented 7 years ago

Fixed by #35

vojtasvoboda commented 7 years ago

Should be now at market, @raskrial can you test it please?