How to fix error Base table or view not found 1146 Table laravel relationship table

Question

I am a new of laravel I try to create relationship many to many between table My problem when I am insert data in to database I got errors  QueryException in Connection php line 713  SQLSTATE 42S02   Base table or view not found  1146 Table  learn category posts  doesn t exist  SQL  insert into category posts  category id  posts id  values  4      can anyone help me pls   and here below is my migrate and code   2016 08 04 131009 create table posts php  public function up         Schema  create  posts   function  Blueprint  table             table- gt increments  id             table- gt text  title             table- gt text  body             table- gt timestamps                2016 08 04 131053 create table categories php  public function up         Schema  create  categories   function  Blueprint  table             table- gt increments  id             table- gt string  name             table- gt timestamps                2016 08 04 131413 create table category posts php  public function up         Schema  create  category post   function  Blueprint  table             table- gt increments  id             table- gt integer  category id  - gt unsigned             table- gt integer  post id  - gt unsigned             table- gt foreign  category id  - gt references  id  - gt on  categories  - gt onUpdate  cascade  - gt onDelete  cascade             table- gt foreign  post id  - gt references  id  - gt on  posts  - gt onUpdate  cascade  - gt onDelete  cascade             table- gt timestamps                and my model Posts php    lt  php  namespace App   use Illuminate Database Eloquent Model   class Posts extends Model       protected  table    posts        public function categories                 return  this- gt belongsToMany  App Category              Category php   lt  php  namespace App   use Illuminate Database Eloquent Model   class Category extends Model       protected  table    categories         public function posts                 return  this- gt belongsToMany  App Posts                 My PostsController php  public function create          categories   Category  all        return view  create  compact  categories        public function store Request  request        post   new Posts      post- gt title    request- gt title      post- gt body    request- gt body      post- gt categories  - gt attach  request- gt categories id        return redirect  - gt route  posts index        My View create blade php     Form  open array  route    gt   store    method    gt   POST              Form  text  title     lt br gt        Form  textarea  body     lt br gt       lt select name  categories id  multiple gt           foreach   categories as  category               lt option value      category- gt id     gt     category- gt name    lt  option gt           endforeach      lt  select gt       lt br gt        Form  submit  submit         Form  close

User · Accepted Answer

It seems Laravel is trying to use category posts table  because of many-to-many relationship   But you don t have this table  because you ve created category post table  Change name of the table to category posts

User · Answer

try checking in the app if you are using the tables before it s created such as appServiceProvider php  you might be calling the table without being created it  if you are  comment it then run php artisan migrate

User · Answer

This problem occur due to wrong spell or undefined database name  Make sure your database name  table name and all column name is same as from phpmyadmin

User · Answer

You can add this in Post Model  public function categories      return  this- gt belongsToMany  App Category   category post   post id   category id                        category post indicate the table you want to use  post id indicate the column where you want to store the posts id  category id indicate the column where you want to store the categories id

User · Answer

For solving your Base Table or view not found error you can do As  Alexey Mezenin said that change table name category post to category posts   but if you don t want to change the name like in my case i am using inventory table so i don t want to suffix it by s so i will provide table name in model as protected  table    Table name as you want  and then there is no need to change table name   Change your Model of the module in which you are getting error for example    lt  php  namespace App   use Illuminate Database Eloquent Model   class Inventory extends Model       protected  table    inventory        protected  fillable              supply    order              you have to provide table name in model then it will not give error

User · Answer

If you re facing this error but your issue is different and you re tired of searching for a long time then this might help you  If you have changed your database and updated  env file and still facing same issue then you should check C  xampp htdocs your-project-name  bootstrap cache config php file and replace or remove the old database name and other changed items

User · Answer

The simplest thing to do is  change the default table name assigned for the model  Simply put following code  protected  table    category posts   instead of protected  table    posts   then it ll do the trick   However  if you refer Laravel documentation you ll find the answer  Here what it says      By convention  the  snake case   plural name of the class model  will be used as the table name unless another name is explicitly specified   Better to you use artisan command to make model and the migration file at the same time  use the following command   php artisan make model Test --migration  This will create a model class and a migration class in your Laravel project  Let s say it created following files   Test php  2018 06 22 142912 create tests table php  If you look at the code in those two files you ll see   2018 06 22 142912 create tests table php files  up function    public function up            Schema  create  tests   function  Blueprint  table           table- gt increments  id           table- gt timestamps                   Here it automatically generated code with the table name of  tests  which is the plural name of that class which is in Test php file

User · Answer

The main problem for causing your table unable to migrate  is that you have running query on your  AppServiceProvider php  try to check your serviceprovider and disable code for the meantime  and run php artisan migrate

User · Answer

Laravel tries to guess the name of the table  you have to specify it directly so that it does not give you that error    Try this   class NameModel extends Model       public  table    name exact of the table     I hope that helps

User · Answer

Schema  table is to modify an existing table  use Schema  create to create new

User · Answer

You should change add in your PostController   and change PostsController to PostController   public function create          categories   Category  all        return view  create  compact  categories        public function store Request  request         post   new Posts       post- gt title    request- gt get  title       CHANGE THIS      post- gt body    request- gt get  body       CHANGE THIS      post- gt save       ADD THIS      post- gt categories  - gt attach  request- gt get  categories id        CHANGE THIS      return redirect  - gt route  posts index       PS ON THIS ONE     PS  using route   means you have named your route as such  Route  get  example    ExampleController getExample  - gt name  getExample      UPDATE  The comments above are also right  change your  Posts  Model to  Post

[laravel] How to fix error Base table or view not found: 1146 Table laravel relationship table?

Examples related to laravel

Examples related to laravel-5

Examples related to laravel-5.2