Laravel: PHP Artisan Tinker 'SQLSTATE[23000]' error

Question

So I am going through a series of intro videos to laravel and I am at the Database migration part and am struggling with a few things...

Here is the error...

I have a) no idea what it means or is referring to as this is my first foray into real command prompt usage and b) how to fix it.

Any help would be much appreciated.

regards.

EDIT-1: Here is my migration file...

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateCardsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('cards', function (Blueprint $table) {
            $table->increments('id');
            $table->string('title');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('cards');
    }
}

EDIT 2: Here is my command prompt, it is working with the answer below, but now with the original laracast tutorial.

Something is missing in the migration file. Did you copy some source code directly? I suspect that later in the course, you'll add some logic to tie cards to users, so in another migration file, that column will be added. I think your source is beyond the step in the course that you're following. — rdiz
– rdiz, Commented Jul 25, 2016 at 14:30
here is my resource: laracasts.com/series/laravel-5-from-scratch/episodes/… play from 9:00 — Jethro Hazelhurst
– Jethro Hazelhurst, Commented Jul 25, 2016 at 14:32
You might have some leftovers, that should definitely work. Try php artisan migrate:refresh, then the original command again. — rdiz
– rdiz, Commented Jul 25, 2016 at 14:35

rdiz · Accepted Answer · 2016-07-25 14:25:09Z

2

It means that you have to supply a user-id as your schema dictates that a card belongs to a user. Add ['user_id'=>some user id] to your array.

Alternatively, create a cards relation on your User-model:

class User extends \Illuminate\Database\Eloquent\Model
{
    public function cards()
   {
      return $this->hasMany(Card::class);
   }
}

This way, you can create a card like so (assuming you have a user variable, fx. by calling User::first(), User::find($id) etc.):

$user->cards()->create([...])

edited Jul 25, 2016 at 14:25

answered Jul 25, 2016 at 14:22

rdiz

6,1961 gold badge31 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

13 Comments

Jethro Hazelhurst Over a year ago

trying that now, what gets me is that I followed the instructor to the letter (in their 2016 up-to-date course) and get this error.

rdiz Over a year ago

It seems a bit strange that they use DateTime as well; normally, you'd use the extended Carbon package. That's what Eloquent casts its own date fields to. Which course are you following? I guess I'm questioning the quality a bit.

Jethro Hazelhurst Over a year ago

This is coming straight from laracasts 101 laravel course and I am just following along... here is my command... DB::table('cards')->insert(['user_id'=> 1, 'title' => 'My new Card', 'created_at' => new DateTime, 'updated_at' => new DateTime]);

Jethro Hazelhurst Over a year ago

It seems to have worked, just testing a little further

rdiz Over a year ago

If it's Laracasts, it's definitely good quality. That code you posted should work.

|

Collectives™ on Stack Overflow

Laravel: PHP Artisan Tinker 'SQLSTATE[23000]' error

1 Answer 1

13 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

13 Comments

Your Answer

Sign up or log in

Post as a guest

Related