Laravel table * has no column named * Laravel table * has no column named * sqlite sqlite

Laravel table * has no column named *


I found the issue. It is because of the ridiculous limitation that sqlite has of not having multiple add column statements in one table call as seen here.

When I separate out the migration as below it works:

Schema::table('loan_details', function(Blueprint $table){    $table->integer('start_month')->unsigned()->after('interest_only')->default(0);});Schema::table('loan_details', function(Blueprint $table){    $table->decimal('balloon_percent',4,3)->after('term')->nullable();});Schema::table('loan_details', function(Blueprint $table){    $table->integer('balloon_month')->after('balloon_percent')->nullable();});Schema::table('loan_details', function(Blueprint $table){    $table->dropColumn('ordinal_rank');});


To check SQLite DB records here

There are many other useful built-in dot commands -- see the documentation at http://www.sqlite.org/sqlite.html, section Special commands to sqlite3.

also, check DB schema