PDOException：:(“SQLSTATE [42S22]：未找到列：1054'字段列表'中的未知列'问题'”）

Question

After php artisan db:seed I am getting error:

1   PDOException::("SQLSTATE[42S22]: Column not found: 1054 Unknown column 'question' in 'field list'")
      F:\Projects\phpealtimeApp\vendor\laravel\framework\src\Illuminate\Database\Connection.php:452

2   PDO::prepare("insert into `replies` (`body`, `question`, `user_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?)")"

Here is my Github repo: https://github.com/hevzy86/realtimeApp

Answer 1

In your replies table migration, you create a field called question_id:

Schema::create('replies', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->text('body');
            $table->integer('question_id')->unsigned(); // <--- here

            $table->timestamps();
        });

However, in your migration, which depends on the Factory you have created for replies, you are setting the field to question:

$factory->define(Reply::class, function (Faker $faker) {
    return [
        'body' => $faker->text,
        'question' => function(){  // <--- here
            return Question::all()->random();
        },
        'user_id' => function(){
            return \App\User::all()->random();
        },
    ];

Change the question in your factory to call an id (figure out which questions are already in the db, and just pull a random id) and name it correctly according to the field (question_id)