php forge module:migrate



Installation 1 year ago by gbevanslivecom

Following exception is generated by "php forge module:migrate":

Migrating the Module: Modules / Platform [ Nova \ DATABASE \ QueryException ] SQLSTATE [ 42000 ] : Syntax ERROR OR access violation: 1067 Invalid DEFAULT VALUE FOR 'created_at'( SQL : CREATE TABLE nova_user_tokens( id INT UNSIGNED NOT NULL auto_incr ement PRIMARY KEY, email VARCHAR(255) NOT NULL, token VARCHAR(100) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ) module: MIGRATE [ - - DATABASE [ DATABASE ] ] [ - - pretend ] [ - - seed ] [ - - FORCE ] [ - - ] [ < slug > ]



1 year ago by daveismyname

that means your database does not allow 0000-00-00 as dates so change the default to NULL.


Login to reply.