Level 47
Try running php artisan migrate.
Mar 31, 2016
7
Level 10
Base table or view not found: 1146 Table doesn't exist
I followed this tutorial and started to build an application ( https://github.com/nasirkhan/laravel-5-starter-application ). but the problem is when i try to create a new instance from this project it shows an error and could not complete the installation. i run composer install and the error was following,
[Illuminate\Database\QueryException]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel-5-starter.permissions' doesn't exist (SQL: select * from `permissions`)
[PDOException]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel-5-starter.permissions' doesn't exist
Script php artisan clear-compiled handling the post-install-cmd event returned with an error
[RuntimeException]
Error Output:
install [--prefer-source] [--prefer-dist] [--dry-run] [--dev] [--no-dev] [--no-plugins] [--no-custom-installers] [--no-autoloader] [--no-scripts] [--no-progress] [-v|vv|vvv|--verbose] [-o|--optimize-autoloader] [-a|--classmap-authoritative] [--ignore-platform-reqs] [--] [<packages>]...
Level 10
thanks for the prompt reply. I tried that too and got the same error. my main question is why am i getting an error on the very first composer install command.
Level 47
It may be because of the way you registered the AuthServiceProvider. Try changing out the getPermissions method with this one:
protected function getPermissions()
{
try {
return Permission::with('roles')->get();
} catch (\Exception $e) {
return [];
}
}
13 likes
Level 10
thanks for your solution. the issue is resolved and the installation was completed without the error.
Though i follow the tutorial ( https://laracasts.com/series/whats-new-in-laravel-5-1/episodes/16 ) and it is causing the error.
Level 6
@zachleigh Thank you so much for that answer! I knew what the problem was but I just couldn't think of a solution. Your solution works great.
1 like
Level 2
@zachleigh and @nasirkhan have you tried doing testing on it? Test always fail while in the browser it works. You can see my problem here: https://laracasts.com/discuss/channels/testing/got-this-action-is-unauthorised-error-when-testing-a-page-even-if-the-user-is-authorised
Level 1
@zachleigh Thank you so much. Your solution is saving my life.
Please or to participate in this conversation.