Can't start Laravel, I get "Base table or view not found" error
If you encounter with this problem and if it's not caused by migration files then most probably it happens because of 2 possible reasons.
- Check ServiceProviders' boot function if it contains queries that are querying tables that don't exist.
- Check if you've created custom helper function and autoloaded that helper function in composer.json file. If custom helper function contains queries that are querying tables that don't exist it will cause this error.
Since ServiceProviders' boot functions and autoloaded custom helper functions are loaded first when laravel is started all the php artisan commands will generate "Base table or view not found" error.
At this point what you should do is comment out those queries that are querying nonexistent tables and run php artisan serve then run php artisan migrate. Then uncomment those lines, save it and everything should work fine.
As @devk suggested it's better to check laravel log files which points exactly to where the problem happens. It led me to find a solution. For this don't forget to Turn on debug mode.
When you've rolled back these migrations, you've deleted categories and articles tables. So just run migrate command again:
php artisan migrate
For me, this error was occurring because of a scheduled task in laravel that involved a database lookup. By commenting out that lookup in laravel/app/Console/Kernel.php from my scheduled task, I was able to migrate my database again.