Laravel Base table or view not found: 1146 Table

‘table’ doesn’t exist (SQL: select * from `permissions`)

Panjeh
1 min readNov 18, 2019

You may encounter such error after doing

php artisan migrate

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 find the exact description.

Before you continue with the rest of this tutorial, I would like to introduce two packages for Laravel that I have recently developed: Laravel Pay Pocket, a modern multi-wallet package, and Laravel Failed Jobs, a UI for the Laravel Failed Jobs Table. I hope they may be of help to you.

https://github.com/HPWebdeveloper/laravel-pay-pocket
https://github.com/HPWebdeveloper/laravel-failed-jobs

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.

--

--

Panjeh
Panjeh

Written by Panjeh

Posting about Python and Laravel

No responses yet