SQLSTATE 42S22 Column not found 1054 Unknown column id in where clause SQL select from songs where id 5 limit 1

Question

I am trying to get specific data from the database by using column SongID when a user clicks a link but I am getting this error       SQLSTATE 42S22   Column not found  1054 Unknown column  id  in  where   clause   SQL  select   from songs where id   5 limit 1    The Controller Class    lt  php namespace App Http Controllers   use App Http Requests  use App Http Controllers Controller   use Illuminate Http Request  use DB   class SongsController extends Controller       public function index                  name    this- gt getName             songs   DB  table  songs  - gt get            return view  songs index   compact  songs   name               public function show  id                 name    this- gt getName             song   DB  table  songs  - gt find  id           return view  songs show   compact  song   name                private function getName                  name    Tupac Amaru Shakur           return  name            Migration       public function up                     Schema  create  songs   function  table                                 table- gt increments  SongID                     table- gt string  SongTitle  - gt index                     table- gt string  Lyrics  - gt nullable                     table- gt timestamp  created at

User · Accepted Answer

When you use find    it automatically assumes your primary key column is going to be id   In order for this to work correctly  you should set your primary key  in your model   So in Song php  within the class  add the line     protected  primaryKey    SongID     If there is any possibility of changing your schema  I d highly recommend naming all your primary key columns id  it s what Laravel assumes and will probably save you from more headaches down the road

User · Answer

Just Go to Model file of the corresponding Controller and check  the  primary key filed name  such as   protected  primaryKey    info id     here info id is field name available in database  table  More info can be found at  Primary Keys  section of the docs

User · Answer

I am running laravel 5 8 and i experienced the same problem  The solution that worked for me is as follows     I used bigIncrements  id   to define my primary key    I used  unsignedBigInteger  user id   to define the foreign referenced key       Schema  create  generals   function  Blueprint  table             table- gt bigIncrements  id             table- gt string  general name             table- gt string  status             table- gt timestamps                  Schema  create  categories   function  Blueprint  table             table- gt bigIncrements  id             table- gt unsignedBigInteger  general id             table- gt foreign  general id  - gt references  id  - gt on  generals             table- gt string  category name             table- gt string  status             table- gt timestamps               I hope this helps out

User · Answer

protected  primaryKey    SongID     After adding to my model to tell the primary key because it was taking id SongID  by default

User · Answer

song   DB  table  songs  - gt find  id     here you use method find  id   for Laravel  if you use this method  you should have column named  id  and set it as primary key  so then you ll be able to use method find    otherwise use where  SongID    id  instead of find  id

[php] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause' (SQL: select * from `songs` where `id` = 5 limit 1)

Examples related to php

Examples related to mysql

Examples related to laravel

Examples related to laravel-5