I have uploaded my site from a homestead enviroment to production ready digital ocean droplet via Laravel Forge. When ssh into the commandline and run

php artisan october:up

i get an interesting error

[Illuminate\Database\QueryException]
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for
'created_at' (SQL: create table `deferred_bindings` (`id` int unsigned not null
auto_increment primary key, `master_type` varchar(255) not null, `master_field` v 
archar(255) not null, `slave_type` varchar(255) not null, `slave_id` varchar(255) 
not null, `session_key` varchar(255) not null, `is_bind` tinyint(1) not null def  
ault '1', `created_at` timestamp default 0 not null, `updated_at` timestamp defau  
lt 0 not null) default character set utf8 collate utf8_unicode_ci engine = InnoDB  
)     

and

 [PDOException] 
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 
'created_at'    

Has anyone encountered this error and how did you solve it?

I dont seem to be able to access mySql config file and i suspect it is strict mysql being run, it wont accept a "0" as a default value.

Last updated 8 years ago

Any luck? I'm trying to get october setup on my Digital Ocean/Forge and am having a headache trying to do it.

Yes, sorry for late answer.

Open the "my.ini" file within the MySQL installation directory and look for something like...

Set the SQL mode to strict

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Replace with:

Set the SQL mode to none strict

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

use sudo nano /etc/mysql/my.cnf

to edit the file

Last updated 8 years ago