SQLSTATE[42S22]: colonne non trouvée: 1054 Colonne inconnue-Laravel
j'utilise le Laravel framework.
j'ai 2 tables (utilisateurs et membres). Quand je veux me connecter, j'obtiens le message d'erreur:
SQLSTATE[42S22]: colonne non trouvé: 1054 Unknown column 'user_email' in 'WHERE clause' (SQL: select * from
members
oùuser_email
= ? limite 1) (fixations: array (0 => 'test@hotmail.com', ))
Table Des Utilisateurs
CREATE TABLE IF NOT EXISTS `festival_aid`.`users` (
`user_id` BIGINT NOT NULL AUTO_INCREMENT,
`user_email` VARCHAR(45) NOT NULL,
`user_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`user_modified` TIMESTAMP NULL,
`user_deleted` TIMESTAMP NULL,
`user_lastlogin` TIMESTAMP NULL,
`user_locked` TIMESTAMP NULL,
PRIMARY KEY (`user_id`),
UNIQUE INDEX `user_email_UNIQUE` (`user_email` ASC),
ENGINE = InnoDB;
Membres De La Table
CREATE TABLE IF NOT EXISTS `festival_aid`.`members` (
`member_id` BIGINT NOT NULL AUTO_INCREMENT,
`member_password` CHAR(32) NOT NULL,
`member_salt` CHAR(22) NOT NULL,
`member_token` VARCHAR(128) NULL,
`member_confirmed` TIMESTAMP NULL,
`user_id` BIGINT NOT NULL,
PRIMARY KEY (`member_id`, `user_id`),
INDEX `fk_members_users1_idx` (`user_id` ASC),
CONSTRAINT `fk_members_users1`
FOREIGN KEY (`user_id`)
REFERENCES `festival_aid`.`users` (`user_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
Migration Utilisateur
public function up()
{
Schema::table('users', function(Blueprint $table)
{
$table->increments('user_id');
$table->string('user_email');
$table->timestamp('user_created');
$table->timestamp('user_modified');
$table->timestamp('user_deleted');
$table->timestamp('user_lastlogin');
$table->timestamp('user_locked');
});
}
Migration Member
public function up()
{
Schema::table('members', function(Blueprint $table)
{
$table->increments('member_id');
$table->string('member_password');
$table->string('member_salt');
$table->string('member_token');
$table->foreign('user_id')
->references('id')->on('users');
//->onDelete('cascade');
$table->timestamp('member_confirmed');
});
}
Modèle De L'Utilisateur
class User extends Eloquent {
protected $table = 'users';
/**
* The primary key for the model.
*
* @var string
*/
protected $primaryKey = 'user_id';
public $timestamps = false;
}
Membre Modèle
use IlluminateAuthUserInterface;
use IlluminateAuthRemindersRemindableInterface;
class Member extends Eloquent implements UserInterface, RemindableInterface {
protected $table = 'members';
/**
* The attributes excluded from the model's JSON form.
*
* @var array
*/
protected $hidden = array('member_password');
/**
* Get the unique identifier for the user.
*
* @return mixed
*/
public function getAuthIdentifier()
{
return $this->getKey();
}
/**
* Get the password for the user.
*
* @return string
*/
public function getAuthPassword()
{
return $this->member_password;
}
/**
* Get the e-mail address where password reminders are sent.
*
* @return string
*/
public function getReminderEmail()
{
return $this->email;
}
/**
* The primary key for the model.
*
* @var string
*/
protected $primaryKey = 'member_id';
public $timestamps = false;
public function users()
{
return $this->hasOne('User');
}
}
le modèle de membre utilise: utiliser IlluminateAuthUserInterface;
<?php namespace IlluminateAuth;
interface UserInterface {
/**
* Get the unique identifier for the user.
*
* @return mixed
*/
public function getAuthIdentifier();
/**
* Get the password for the user.
*
* @return string
*/
public function getAuthPassword();
}
contrôleur
public function store()
{
$input = Input::all();
$rules = array('user_email' => 'required', 'member_password' => 'required');
$v = Validator::make($input, $rules);
if($v->passes())
{
$credentials = array('user_email' => $input['user_email'], 'member_password' => $input['member_password']);
if(Auth::attempt($credentials))
{
return Redirect::to('/home');
} else {
return Redirect::to('login');
}
} else {
return Redirect::to('login')->withErrors($v);
}
}
auth.php
return array(
/*
|--------------------------------------------------------------------------
| Default Authentication Driver
|--------------------------------------------------------------------------
|
| This option controls the authentication driver that will be utilized.
| This drivers manages the retrieval and authentication of the users
| attempting to get access to protected areas of your application.
|
| Supported: "database", "eloquent"
|
*/
'driver' => 'eloquent',
/*
|--------------------------------------------------------------------------
| Authentication Model
|--------------------------------------------------------------------------
|
| When using the "Eloquent" authentication driver, we need to know which
| Eloquent model should be used to retrieve your users. Of course, it
| is often just the "User" model but you may use whatever you like.
|
*/
'model' => 'Member',
/*
|--------------------------------------------------------------------------
| Authentication Table
|--------------------------------------------------------------------------
|
| When using the "Database" authentication driver, we need to know which
| table should be used to retrieve your users. We have chosen a basic
| default value but you may easily change it to any table you like.
|
*/
'table' => 'members',
/*
|--------------------------------------------------------------------------
| Password Reminder Settings
|--------------------------------------------------------------------------
|
| Here you may set the settings for password reminders, including a view
| that should be used as your password reminder e-mail. You will also
| be able to set the name of the table that holds the reset tokens.
|
| The "expire" time is the number of minutes that the reminder should be
| considered valid. This security feature keeps tokens short-lived so
| they have less time to be guessed. You may change this as needed.
|
*/
'reminder' => array(
'email' => 'emails.auth.reminder',
'table' => 'password_reminders',
'expire' => 60,
),
);
Ce que je fais mal?
3 réponses
vous avez configuré le auth.php
et utilisé members
la table pour l'authentification, mais il n'y a pas de user_email
champ members
table afin de, Laravel dit
SQLSTATE[42S22]: colonne non trouvé: 1054 Unknown column 'user_email' in 'where clause' (SQL: select * from membres où user_email = ? limite 1) (Fixations: array ( 0 => 'test@hotmail.com', ))
parce que, il essaie de correspondre au user_email
dans le members
table et elle n'est pas là. En fonction de votre auth
configuration,laravel
utilise members
la table pour l'authentification users
tableau.
Vous n'avez pas un champ nommé user_email
dans la table des membres de
... comme pour pourquoi, je ne suis pas sûr que le code "ressemble" comme il devrait essayer de se joindre sur différents champs
le Auth::tentative méthode effectuer une jointure du schéma?
Exécutez grep -Rl 'class Auth' /path/to/framework
et le attempt
méthode est et ce qu'il fait.
Essayez de changer de où les Membres de la classe
public function users() {
return $this->hasOne('User');
}
return $this->belongsTo('User');