Laravel - Array to string conversion error on Model::create or Model->save()

Question

I'm performing a simple insert which I've done many times without any issues and for some odd reason it's not working and I get this error message:

error: {type: "ErrorException", message: "Array to string conversion",…}
file: "C:\wamp\www\studentreg2\vendor\laravel\framework\src\Illuminate\Database\Grammar.php"
  line: 33
  message: "Array to string conversion"
  type: "ErrorException"

Here's my code:

$advisorCheck = AdvisorCheck::create([
            'status'         => Input::get('status'),
            'application_id' => Input::get('id'),
            'user_id'        => Auth::id()
        ]);

The migration for the advisor_check table which AdvisorCheck model uses seems fine, all foreign keys are unsigned and show the relations correctly in phpmyadmin, all values from the Input::get are strings, the model has the correct fields set as fillable (status, application_id, user_id).

I've even tried doing this in php artisan tinker like this:

AdvisorCheck::create([ 'status' => 'returned', 'application_id' => '3', 'user_id' => '4']);

and I get this response: Array to string conversion

I've also tried this method and get the same error:

$advisorCheck                 = new AdvisorCheck;
$advisorCheck->status         = Input::get('status');
$advisorCheck->application_id = Input::get('id');
$advisorCheck->user_id        = Auth::id();
$advisorCheck->save();

Model code:

<?php

class AdvisorCheck extends \Eloquent {

    protected $fillable = ['status', 'application_id', 'user_id'];

    protected $table = ['advisor_check'];
}

If you need to see more code please ask.

Many thanks to anyone who can help!

I've got a feeling it's because I put the $table before $fillable, all my other models have $fillable first - giving it a shot now — haakym
– haakym, Commented Dec 17, 2014 at 11:57
Nope wasn't it - didn't make any sense for it to be that I guess? I'll post the model code — haakym
– haakym, Commented Dec 17, 2014 at 11:58

lukasgeiter · Accepted Answer · 2014-12-17 12:13:51Z

27

As you can see in the example that's shown in the Laravel docs the table property is a string and not an array

protected $table = 'advisor_check';

Which makes total sense if you think about it, since Eloquent models don't support multiple tables natively.

answered Dec 17, 2014 at 12:13

lukasgeiter

154k29 gold badges349 silver badges280 bronze badges

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

Comments

nilobarp · Accepted Answer · 2014-12-17 12:14:18Z

2

$table should be a string not array

<?php

   class AdvisorCheck extends \Eloquent {

   protected $fillable = ['status', 'application_id', 'user_id'];

   protected $table = 'advisor_check';
}

answered Dec 17, 2014 at 12:14

nilobarp

4,1322 gold badges34 silver badges38 bronze badges

Comments

Kinjal Suryavanshi · Accepted Answer · 2021-12-31 07:42:33Z

0

if we give table name in laravel model like array:

 protected $table = ['thoughts'];

then it will generate error.

so you should give table name as string like :

protected $table = 'thoughts';

answered Dec 31, 2021 at 7:42

Kinjal Suryavanshi

415 bronze badges

Collectives™ on Stack Overflow

Laravel - Array to string conversion error on Model::create or Model->save()

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related