未配置数据库连接 [用户]

Question

使用 Laravel Auth 提交注册表时，我收到InvalidArgumentException Database connection [users] not configured. http://127.0.0.1:8000/register错误。我的 Laravel 版本是 6.17.1.env 文件DB_CONNECTION=mysqlDB_HOST=127.0.0.1DB_PORT=3306DB_DATABASE=laravelDB_USERNAME=rootDB_PASSWORD=Auth/RegisterController.php 文件<?phpnamespace App\Http\Controllers\Auth;use App\Http\Controllers\Controller;use App\Providers\RouteServiceProvider;use App\User;use Illuminate\Foundation\Auth\RegistersUsers;use Illuminate\Support\Facades\Hash;use Illuminate\Support\Facades\Validator;class RegisterController extends Controller{    /*    |--------------------------------------------------------------------------    | Register Controller    |--------------------------------------------------------------------------    |    | This controller handles the registration of new users as well as their    | validation and creation. By default this controller uses a trait to    | provide this functionality without requiring any additional code.    |    */    use RegistersUsers;    /**     * Where to redirect users after registration.     *     * @var string     */    protected $redirectTo = RouteServiceProvider::HOME;    /**     * Create a new controller instance.     *     * @return void     */    public function __construct()    {        $this->middleware('guest');    }    /**     * Get a validator for an incoming registration request.     *     * @param  array  $data     * @return \Illuminate\Contracts\Validation\Validator     */    protected function validator(array $data)    {        return Validator::make($data, [            'name' => ['required', 'string', 'max:20'],            'surname' => ['required', 'string', 'max:30'],            'age' => ['required', 'integer', 'max:100'],            'email' => ['required', 'string', 'email', 'max:255', 'unique:users.email'],            'password' => ['required', 'string', 'min:6'],            'confirm' => ['required', 'string', 'same:password']        ]);    }}

Answer 1

我有同样的错误，它是由于错误的验证角色而发生的。

我收到了这个错误：

{

"message": "Database connection [users] not configured.",

"exception": "InvalidArgumentException", ... 

}

再次检查您的验证规则，尤其是在 [unique] 规则上。

我的错误代码：

$rules = [

         'username'  => 'required|min:8|unique:users.username,'.$request->input('user-id')

];

正确的：

$rules = [

         'username'  => 'required|min:8|unique:users,username,'.$request->input('user-id')

];

您在“Auth/RegisterController.php”中有同样的问题：替换这个：

protected function validator(array $data)

{

    return Validator::make($data, [

        'name' => ['required', 'string', 'max:20'],

        'surname' => ['required', 'string', 'max:30'],

        'age' => ['required', 'integer', 'max:100'],

        'email' => ['required', 'string', 'email', 'max:255', 'unique:users.email'],

        'password' => ['required', 'string', 'min:6'],

        'confirm' => ['required', 'string', 'same:password']

    ]);

}

有了这个 ：

    protected function validator(array $data)

{

    return Validator::make($data, [

        'name' => ['required', 'string', 'max:20'],

        'surname' => ['required', 'string', 'max:30'],

        'age' => ['required', 'integer', 'max:100'],

        'email' => ['required', 'string', 'email', 'max:255', 'unique:users,email'],

        'password' => ['required', 'string', 'min:6'],

        'confirm' => ['required', 'string', 'same:password']

    ]);

}

Answer 2

我在 Laravel 8.x 上遇到了同样的错误，为了解决您的问题，您必须将电子邮件输入的验证规则从更改unique:users.email为unique:users,email：

protected function validator(array $data)

{

    return Validator::make($data, [

        'name' => ['required', 'string', 'max:20'],

        'surname' => ['required', 'string', 'max:30'],

        'age' => ['required', 'integer', 'max:100'],

        'email' => ['required', 'string', 'email', 'max:255', 'unique:users,email'],

        'password' => ['required', 'string', 'min:6'],

        'confirm' => ['required', 'string', 'same:password']

    ]);

}

Answer 3

首先运行php artisan config:cache & php artisan cache:clear并重试。如果问题仍然存在，您可以在用户模型中手动指定数据库连接：

<?php

namespace App;

use Illuminate\Contracts\Auth\MustVerifyEmail;

use Illuminate\Foundation\Auth\User as Authenticatable;

use Illuminate\Notifications\Notifiable;

class User extends Authenticatable

{

    use Notifiable;

    # database connection

    protected $connection = 'mysql';

    /**

     * The attributes that are mass assignable.

     *

     * @var array

     */

    protected $fillable = [

        'name', 'surname', 'age', 'email', 'password', 'code', 'ban', 'ban_reason', 'created_at', 'image', 'role', 'confirmed'

    ];

    /**

     * The attributes that should be hidden for arrays.

     *

     * @var array

     */

    protected $hidden = [

        'password', 'code', 'confirmed'

    ];

    /**

     * The attributes that should be cast to native types.

     *

     * @var array

     */

    protected $casts = [

        'email_verified_at' => 'datetime',

    ];

}

通常这不是必需的，因为您的应用程序mysql用作默认连接，尽管我不知道您的环境。问题可能在任何地方。希望这可以帮助。

Answer 4

尝试改变

DB_CONNECTION=mysql

至

DB_CONNECTION=localhost