'SQLSTATE [3D000]：无效的目录名称：1046从Laravel密码提醒返回后没有选择数据库

Question

This is my home page route, where I get a random member:

Route::get('/', function()
{
    $member = User::orderBy(DB::raw('RAND()'))->first();
    return View::make('landing', compact('member'));
});

When the RemindersController's postRemind method sends the email, I'm doing this:

case Password::REMINDER_SENT:
    return Redirect::to('/')->with('flash_message', 'Whatever message...');

And the home page returns:

Illuminate \ Database \ QueryException
SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected (SQL: select * from `users` order by RAND() asc limit 1)

If I refresh the page right there, it fixes itself.. I'm using getenv() and .env.php files to fill the database connection values. If I switch from that to hard code them in, it fixes the problem. And if I go back to using getenv() it works too. However, as soon as I restart WAMP, I'm back to square 1.

What's going on?

Answer 1

I had this problem when I replaced the hard coded values in database.php by using getenv().

Are you sure that is loading the correct environment? you can check it in the terminal going to the route of your project and doing

php artisan env

If is not the correct one, you can fix it in the file start.php

For example, if your local environment file (in the root of your project) is called ".env.local.php" in the file start.php you should have something like

$env = 'yourHostName.local'