Laravel - SQLSTATE[42S02]: Base table or view not found: 1146 Table

Question

I'm setup homestead in my pc then i'm try to access my files via local domain. But when i'm trying to connect with DB then showing me this error. I can't access my others projects too. I setup everything very well. But i don't know why showing me this error.

Note: I'm using windows 8.1

Here is my setup code:

Homestead.yaml

ip: "192.168.10.10"

memory: 2048

cpus: 1

provider: virtualbox

authorize: ~/.ssh/id_rsa.pub

keys:

- ~/.ssh/id_rsa

folders:

- map: F:/xampp/htdocs/Projects
  to: /home/vagrant/Projects

sites:

- map: govt-university.dev
  to: /home/vagrant/Projects/govt-university/public

- map: voyager.dev
  to: /home/vagrant/Projects/voyager/public

- map: evaluationplus.dev
  to: /home/vagrant/Projects/laravel-evaluationplus/public

- map: laravel-university.dev
  to: /home/vagrant/Projects/laravel-evaluationplus/public

databases: - homestead

Host file

192.168.10.10 govt-university.dev

192.168.10.10 voyager.dev

192.168.10.10 evaluationplus.dev

192.168.10.10 laravel-university.dev

ENV file

APP_NAME= Laravel

APP_ENV=local

APP_KEY=base64:nmcR0V2cbq+26H3EBdLmYRQN5bkiOryROTxHpvUzuvA=

APP_DEBUG=true

APP_LOG_LEVEL=debug

APP_URL=http://voyager.dev

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=voyager

DB_USERNAME=homestead

DB_PASSWORD=secret

Error Image:

Please help me to solve this problem. Thanks

it is showing that there is no tables in your database. check your database again or try to migrate/seed tables. — スージン
Are you 100% sure that you migrated this database in Homestead and not on your local machine? — Marcin Nabiałek
What's your table name and whats the corresponding model name ? — partho

Manzurul Manzurul · Accepted Answer · 2017-10-05T18:26:25

You need to ssh into Vagrant and then run artisan command to migrate database. Once you do this will be fixed.

Laravel - SQLSTATE[42S02]: Base table or view not found: 1146 Table

2 Answers