Why Eloquent changes column name?

Question

My book table's primary key is called ISBN.

But when I try to update others columns using the ISBN I get the following error:

I can fix it changing the eloquent query, but I want to know why this mistake appears.

Thanks in advance!

In your `BookModel` write this line if you haven't written. `protected $primaryKey = 'ISBN';` — Akhtar Munir, May 13 '20 at 19:06
Another point is Laravel uses camelCase means when you write a function or id like `ISBN` in capital letters laravel will assume it `i_s_b_n` — Akhtar Munir, May 13 '20 at 19:12

score 6 · Accepted Answer · answered May 13 '20 at 19:50

6

Laravel automatically converts the names of relationships from camelCase to snake_case when the model is converted to an array (toArray()) or json (toJson()).

to avoid this changes write this line in your model:

public static $snakeAttributes = false;

see:

https://stackoverflow.com/a/44794070/10573560

answered May 13 '20 at 19:50

OMR

11,736
5
20
35

1

It doesn't work. I'm still having the same error. I tried to write the line you give me and the primary key in the model. – Álvaro May 14 '20 at 12:54
please write the query witch made the error in your question – OMR May 14 '20 at 12:56
sorry to be late, after long research, it was obvious that it's laravel convention, so tweak it would take some effort, – OMR May 16 '20 at 20:51
you had to make you own model class, like in this answer: https://stackoverflow.com/a/33710995/10573560 – OMR May 16 '20 at 20:51

Why Eloquent changes column name?

1 Answers1