Open niirii opened 8 years ago
I manually created the "roles" table following the structure from the RolesAndUserSeeder.php file and the output of the error message.
When I run the seed again a new error comes up for "role_user" table or view.
[Illuminate\Database\QueryException]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mydb.role_user' doesn't exist (SQL: insert into role_user
(created_at
, role_ id
, updated_at
, user_id
) values (2015-11-12 20:01:44, 0, 2015-11-12 20:01:44, 1))
Well, I manually created the role_user table too and now the seed works. I finally figured out what page to navigate to but there is an error about an "articles" table.
ErrorException in Connection.php line 651:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mydb.articles' doesn't exist (SQL: select count(*) as aggregate from articles
where type
= post) (View: /var/www/html/customer/vendor/pingpong/admin/src/views/index.blade.php)
Obviously something did not work correctly during the install as I am sure all of the database tables should have been created by the package.
I created a brand new Laravel project (Laravel 5.1.11). It is up and running with no built-in user authentication pages, etc.
I followed the Wiki to install "pingpong/admin" which grabs "Using version ^2.1 for pingpong/admin" and then I update the Laravel configurations accordingly.
NOTE The documentation is not updated to use the new "::class" attributes in the configurations.
When I attempt to seed the database it throws an error that the base table or view is not found.
[Illuminate\Database\QueryException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mydb.roles' doesn't exist (SQL: insert into
roles
(name
,slug
,description
,created_at
,updated_at
) values (Admin, admin, The one who manage the site, 2015-11-12 19:38:13, 2015-11-12 19:38:13))