Cipfahim / larastarter

A laravel starter kit for web artisans.
79 stars 31 forks source link

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; #8

Open MaheKarim opened 4 years ago

MaheKarim commented 4 years ago

When i command "php artisan migrate" this error show

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'after id, connection text not null, queue text not null, payload longtex' at line 1 (SQL: create table failed_jobs (id bigint unsigned not null auto_increment primary key, uuid varchar(255) null after id, connection text not null, queue text not null, payload longtext not null, exception longtext not null, failed_at timestamp default CURRENT_TIMESTAMP not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

kbtonmoy commented 4 years ago

Go to: Migrations -> create_failed_jobs_table and replace the Schema with

Schema::create('failed_jobs', function (Blueprint $table) {
            $table->id();
            $table->text('connection');
            $table->text('queue');
            $table->longText('payload');
            $table->longText('exception');
            $table->timestamp('failed_at')->useCurrent();
        });