Forgot Password page issue
Hello,
Basic wizard created password retrieval page is giving an error
" Unknown column 'UserEmail' in 'field list "
if(isset($_POST["ForgotPassword_submit"])){
//WA SecurityAssist Email object="mail"
$WA_Auth_Parameter = array(
"connection" => $MySQLcmhi,
"database" => $database_MySQLcmhi,
"tableName" => "tblretailer",
"filterColumn" => "retailerid",
"filterEncryption" => "",
"columnValue" => "".((isset($_POST["Forgot_Password_group_Email"]))?$_POST["Forgot_Password_group_Email"]:"") ."",
"columnType" => "int",
"usernameColumn" => "retaileremail",
"usernameEncryption" => "",
"passwordColumn" => "UserPassword",
"passwordEncryption" => "",
"selectColumns" => array("UserEmail","UserPassword","retaileremail","retailerid"),
"sessionVariables" => array(""),
"successRedirect" => "access.php?emailedPassword=1",
"failRedirect" => "forgotpassword.php?notFound=1",
"keepQueryString" => TRUE,
"toAddressColumn" => "retailerid",
"toAddressEncryption" => "",
"fromAddress" => "Administration@domain.org",
"fromAddressDisplay" => "Administration",
"subject" => "Forgotten Password",
"mailBody" => "webassist/security_assist/email/forgotpassword_email2.php",
"emailFunction" => "WA_SecurityAssist_Email_1_SendMail"
);
WA_Auth_ForgotPassword($WA_Auth_Parameter);
}
In the SecurityAssist: Email Password panel under DataBase tab the Lookup Value is:
<?php echo ((isset($_POST["Forgot_Password_group_Email"]))?$_POST["Forgot_Password_group_Email"]:""); ?>
I'm thinking of creating a recordset based on the user email address and then using that as the lookup value but would like to better understand the extensions requirements before I deviate to hand coding.