harristars's avatar

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');
    }
}
0 likes
6 replies
DirkZz's avatar

.. I don't think this forum was created to do work for others without you explaining what you have tried etc ..

harristars's avatar

@DirkZz read my question clearly read this question and stop complain .i experience this error when i press create post button?

jeffdavis's avatar
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.

harristars's avatar

@jeffdavis i have run the command php artisan make:migration add_user_id_to_posts but the user_id does not show up in the post table.i have added body manually in the database.

harristars's avatar

@jeffdavis after running php artisan migrate:refresh it have worked thanks you very much.user_id have been added to post table

Please or to participate in this conversation.