.. I don't think this forum was created to do work for others without you explaining what you have tried etc ..
Nov 6, 2016
6
Level 1
QueryException in Connection.php line 763: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'body' in 'field list' (SQL: insert into `posts` (`body`, `user_id`, `updated_at`, `created_at`) values (test project, 6, 2016-11-06 13:32:50, 2016-11-06 13:
i experience this error when i press create post button
QueryException in Connection.php line 763: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'body' in 'field list' (SQL: insert into `posts` (`body`, `user_id`, `updated_at`, `created_at`) values (test project, 6, 2016-11-06 13:32:50, 2016-11-06 13:32:50))
in Connection.php line 763
at Connection->runQueryCallback('insert into `posts` (`body`, `user_id`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('test project', '6', '2016-11-06 13:32:50', '2016-11-06 13:32:50'), object(Closure)) in Connection.php line 719
at Connection->run('insert into `posts` (`body`, `user_id`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('test project', '6', '2016-11-06 13:32:50', '2016-11-06 13:32:50'), object(Closure)) in Connection.php line 480
at Connection->statement('insert into `posts` (`body`, `user_id`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('test project', '6', '2016-11-06 13:32:50', '2016-11-06 13:32:50')) in Connection.php line 434
at Connection->insert('insert into `posts` (`body`, `user_id`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('test project', '6', '2016-11-06 13:32:50', '2016-11-06 13:32:50')) in Processor.php line 32
at Processor->processInsertGetId(object(Builder), 'insert into `posts` (`body`, `user_id`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('test project', '6', '2016-11-06 13:32:50', '2016-11-06 13:32:50'), 'id') in Builder.php line 2142
at Builder->insertGetId(array('body' => 'test project', 'user_id' => '6', 'updated_at' => '2016-11-06 13:32:50', 'created_at' => '2016-11-06 13:32:50'), 'id')
at call_user_func_array(array(object(Builder), 'insertGetId'), array(array('body' => 'test project', 'user_id' => '6', 'updated_at' => '2016-11-06 13:32:50', 'created_at' => '2016-11-06 13:32:50'), 'id')) in Builder.php line 1441
at Builder->__call('insertGetId', array(array('body' => 'test project', 'user_id' => '6', 'updated_at' => '2016-11-06 13:32:50', 'created_at' => '2016-11-06 13:32:50'), 'id')) in Model.php line 1607
at Builder->insertGetId(array('body' => 'test project', 'user_id' => '6', 'updated_at' => '2016-11-06 13:32:50', 'created_at' => '2016-11-06 13:32:50'), 'id') in Model.php line 1607
at Model->insertAndSetId(object(Builder), array('body' => 'test project', 'user_id' => '6', 'updated_at' => '2016-11-06 13:32:50', 'created_at' => '2016-11-06 13:32:50')) in Model.php line 1576
at Model->performInsert(object(Builder)) in Model.php line 1472
at Model->save() in HasOneOrMany.php line 225
at HasOneOrMany->save(object(post)) in PostController.php line 15
at PostController->postCreatePost(object(Request))
at call_user_func_array(array(object(PostController), 'postCreatePost'), array(object(Request))) in Controller.php line 55
at Controller->callAction('postCreatePost', array(object(Request))) in ControllerDispatcher.php line 44
at ControllerDispatcher->dispatch(object(Route), object(PostController), 'postCreatePost') in Route.php line 190
at Route->runController() in Route.php line 144
at Route->run(object(Request)) in Router.php line 642
at Router->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
at Pipeline->then(object(Closure)) in Router.php line 644
at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 618
at Router->dispatchToRoute(object(Request)) in Router.php line 596
at Router->dispatch(object(Request)) in Kernel.php line 267
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
at Pipeline->then(object(Closure)) in Kernel.php line 149
at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 116
at Kernel->handle(object(Request)) in index.php line 54
app\Http\Controllers\PostController.php
<?php
namespace App\Http\Controllers;
use App\Http\Controllers\Controller;
//namespace routes;
use App\Post;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
class PostController extends Controller
{
public function postCreatePost(Request $request)
{
// Validation
$post = new Post();
$post->body = $request['body'];
$request->user()->posts()->save($post);
return redirect()->route('dashboard');
}
}
database\migrations\2016_11_05_203649_create_posts_table.php
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreatePostsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('posts', function (Blueprint $table) {
$table->increments('id');
$table->timestamps();
$table->text('body');
$table->integer('user_id');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('posts');
}
}
Level 5
Since the migration clearly has the 'body' field and the sql error says that 'body' column doesn't exist in the database, it seems like the migration might not have been run. Can you do 'artisan migrate:refresh' to make sure the migration has been run? Otherwise I don't see what could be causing the problem.
Please or to participate in this conversation.