我正在Laravel 5中创建一个简单的身份验证系统。我有用Laravel 4编写的身份验证代码,我正在使用它作为基础。
我的问题是
SQLSTATE[42S22]:未找到列:1054中的未知列"已确认"where子句"(SQL:从
users
中选择*,其中confirmed
=1极限1)
看起来Laravel正在查看我的电子邮件是否经过验证。但我不需要为这个应用程序执行注册和验证过程。我的问题是,我如何告诉laravel不要担心电子邮件确认?
我的身份验证代码如下:
public function postAuthenticate()
{
// Fetch posted credentials
$email = 'Request::input('email');
$password = 'Request::input('password');
$remember = 'Request::has('_remember');
$credentials = [
'email' => $email,
'password' => $password,
'confirmed' => 1
];
// Attempt to log in user
if ('Auth::attempt($credentials, $remember))
{
return 'Redirect::intended('dashboard');
}
// If this code was reached, it means that the user failed to authenticated.
// In this case, redirect back to the login page with errors.
$messages = new Illuminate'Support'MessageBag;
$messages->add('Authentication Error', 'Sign in failed.');
return 'Redirect::to('/login')
->withInput()
->with('errors', $messages);
}
我的用户模型看起来像:
<?php namespace App;
use Illuminate'Auth'Authenticatable;
use Illuminate'Database'Eloquent'Model;
use Illuminate'Auth'Passwords'CanResetPassword;
use Illuminate'Contracts'Auth'Authenticatable as AuthenticatableContract;
use Illuminate'Contracts'Auth'CanResetPassword as CanResetPasswordContract;
class User extends Model implements AuthenticatableContract, CanResetPasswordContract {
use Authenticatable, CanResetPassword;
/**
* The database table used by the model.
*
* @var string
*/
protected $table = 'users';
/**
* The attributes that are mass assignable.
*
* @var array
*/
protected $fillable = ['name', 'email', 'password'];
/**
* The attributes excluded from the model's JSON form.
*
* @var array
*/
protected $hidden = ['password', 'remember_token'];
}
最后,我的用户表迁移是:
<?php
use Illuminate'Database'Schema'Blueprint;
use Illuminate'Database'Migrations'Migration;
class CreateUsersTable extends Migration {
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('users', function(Blueprint $table)
{
$table->increments('id');
$table->string('name');
$table->string('email')->unique();
$table->string('password', 60);
$table->rememberToken();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('users');
}
}
谢谢!
您必须从$credentials
中删除'confirmed' => 1
例如:
$credentials = [
'email' => $email,
'password' => $password
];