Base table or view not found 1146 Table Laravel 5

Question

Im getting this error when I try to save data to mysql using Laravel 5  other forms and save   methods work fine but this one   SQLSTATE 42S02   Base table or view not found  1146 Table  sistemal5 cotizacions  doesn t exist  SQL  insert into  cotizacions    customer id    total    updated at    created at   values  1501  150 69  2015-05-11 03 16 25  2015-05-11 03 16 25     Here is my Controller store method   public function store CotFormRequest  request                     quote   new Cotizacion           quote- gt customer id   Input  get  data clientid             quote- gt total   Input  get  data totalAftertax                 quote- gt save                And here is my model    lt  php namespace App Models Cotizacion   use Illuminate Database Eloquent Model    class Cotizacion extends Model        I must be overlooking something really obvious cause i cant understand why Laravel is adding an  S  the table is cotizacion not cotizacions   How can i troubleshoot this

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  Thank You

User · Answer

I also had this problem when doing migration    after performing php artisan migrate refresh --seed command   Base table or view not found  1146 Table posts do not exist  and I solved it  I was using  soft deletes  in a separate migration file  and my original migration for  posts  table which was responsible for creating the  posts  table was performing after the  soft deletes  migration in the database migration folder  I simply needed to rename the  posts  migration file name and put it before  softdeletes  migration to perform sooner   the do the migration again    php artisan migrate refresh --seed  it s done

User · Answer

I faced this problem too in laravel 5 2 and if declaring the table name doesn t work it is probably because you have some wrong declaration or mistake in validation code in Request  If you are using one

User · Answer

When you are passing the custom request in the controller method  and your request file doesn t follow the proper syntax or table name is changed  then laravel through this type of exception  I ll show you in Example   My Request code       public function rules                         return                    name    gt   required unique posts max 50                    description    gt   required                             But my table name is todos not posts so that s why it through  Base table or view not found  1146 Table Laravel 7       I forgot to change the table name in first index       public function rules                         return                    name    gt   required unique todos max 50                    description    gt   required

User · Answer

If your error is not related to the issue of      Laravel can t determine the plural form of the word you used for your   table name    with this solution  and still have this error  try my approach  you should find the problem in the default  AppServiceProvider php  or other  ServiceProviders defined for that application specifically or even in Kernel php in App Console  This error happened for me and I solved it temporary and still couldn t figure out the exact origin and description    In my case the main problem for causing my table unable to migrate  is that I have running code query on my  PermissionsServiceProvider php  in the boot   method   In the same way  maybe  you defined something in boot   method of AppServiceProvider php or in the Kernel php  So first check your Serviceproviders and disable code for a while  and run php artisan migrate and then undo changes in your code

User · Answer

I m guessing Laravel can t determine the plural form of the word you used for your table name   Just specify your table in the model as such   class Cotizacion extends Model      public  table    cotizacion

User · Answer

Just run the command   php artisan migrate refresh --seed

User · Answer

Check your migration file  maybe you are using Schema  table  like this   Schema  table  table name   function   table                      If you want to create a new table you must use Schema  create   Schema  create  table name   function   table

[php] Base table or view not found: 1146 Table Laravel 5

Examples related to php

Examples related to mysql

Examples related to laravel