AbhayPatani97 AbhayPatani97 - 1 month ago 10
MySQL Question

Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'usertype' in 'field list''

I tried to implement the following code onto my website, but this error appeared:


Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'usertype' in 'field list'' in /home/multive2/public_html/superdonate/ajax/login.php:63 Stack trace: #0 /home/multive2/public_html/superdonate/ajax/login.php(63): PDOStatement->execute(Array) #1 {main} thrown in /home/multive2/public_html/superdonate/ajax/login.php on line 63"


Why this is happening? Sorry about my English/ code.

if(curl_errno($curl)){
array_push($pageError, getLangString("process-request-error"));
array_push($pageError, curl_errno($curl));
} else {
$returnedDecoded = json_decode($returned, true);
if(isset($returnedDecoded['success'])){
if($returnedDecoded['success'] === true){
$moveOn = true;
} else {
array_push($pageError, getLangString("retry-captcha"));
}
} else {
array_push($pageError, getLangString("process-request-error"));
}
}

} else {
$moveOn = true;
}

if($moveOn === true) {
if($_POST['login-type'] == "login"){
$username = $_POST['username'];
$password = $_POST['password'];
$sql = $dbcon->prepare("SELECT password, usertype FROM users WHERE username=:username");
$value = array(':username' => $username);
$sql->execute($value); -----------------------------> Line 63, Error.
$result = $sql->fetchAll(PDO::FETCH_NUM);
$count = 0;
foreach ($result as $key => $value) {
$count = $count + 1;
}
if($count < 1){
array_push($pageError, getLangString("incorrect-login"));
} else {
if(password_verify($password, $result[0][0]) == true){
$_SESSION['username'] = $username;
if($result[0][1] === 'admin'){
$_SESSION['admin'] = TRUE;
}
} else {
array_push($pageError, getLangString("incorrect-login"));
}
}
} elseif ($_POST['login-type'] == "register"){
$username = $_POST['username'];
$password = $_POST['password'];
$confirmpassword = $_POST['confirm-password'];
$email = $_POST['email'];
$uservalid = FALSE;
$passvalid = FALSE;
$emailvalid = FALSE;
$sql = $dbcon->prepare("SELECT password FROM users WHERE username=:username");
$value = array(':username' => $username);
$sql->execute($value);
$result = $sql->fetchAll(PDO::FETCH_NUM);
$count = 0;
foreach ($result as $key => $value) {
$count = $count + 1;
}
if($count > 0){
array_push($pageError, getLangString("username-taken"));
} else {
if($password === $confirmpassword){
if(strlen($username) < 6 OR strlen($username) > 32){
array_push($pageError, getLangString("username-length-error"));
} else {
$uservalid = TRUE;
}
if(strlen($password) < 8){
array_push($pageError, getLangString("password-length-error"));
} else {
$passvalid = TRUE;
}

$url = $sdonateapiurl;
$data = array('action' => 'validateemail', 'apikey' => $sdonateapi, 'email' => $_POST['email']);
$options = array(
'http' => array(
'header' => "Content-type: application/x-www-form-urlencoded",
'method' => 'POST',
'content' => http_build_query($data),
),
);
$context = stream_context_create($options);
$result = file_get_contents($url, false, $context);

if($result === FALSE){
array_push($pageError, getLangString("process-request-error"));
} elseif($result === "apiproblem") {
array_push($pageError, getLangString("api-key-problem"));
} elseif($result === "EMAILINVALID") {
array_push($pageError, getLangString("invalid-email-error"));
} elseif($result === "EMAILVALID") {
$emailvalid = true;
}

if($uservalid === TRUE AND $passvalid === TRUE AND $emailvalid === true){
$hashed = password_hash($password, PASSWORD_DEFAULT);
if($hashed === FALSE){
array_push($pageError, getLangString("account-registration-error"));
} else {
$sql = $dbcon->prepare("INSERT INTO users(username, email, password, usertype) VALUES(:username, :email, :password, :usertype)");
$values = array(':username' => $username, ':email' => $email, ':password' => $hashed, ':usertype' => 'user');
$sql->execute($values);
$_SESSION['username'] = $username;
}
}
} else {
array_push($pageError, getLangString("password-mismatch-error"));
}
}
} elseif($_POST['login-type'] == "resetpassword"){

$key = $_POST['reset-password-key'];
$username = $_POST['username'];
$password = $_POST['password'];
$confirmpassword = $_POST['confirmpassword'];

$sql = $dbcon->prepare("SELECT * FROM resetpassword WHERE username=:username AND resetkey=:resetkey");
$values = array(':username' => $username, ':resetkey' => $key);
$sql->execute($values);
$results = $sql->fetchAll(PDO::FETCH_ASSOC);
$resultscount = $sql->rowCount();

if($resultscount > 0){
if(strtotime($results[0]['expires']) > time() - 86400){
if($password === $confirmpassword){
if(strlen($password) > 7){
$hashed = password_hash($password, PASSWORD_DEFAULT);
if($hashed === FALSE){
array_push($pageError, getLangString("password-change-error"));
} else {
$sql = $dbcon->prepare("UPDATE users SET password=:password WHERE username=:username");
$values = array(':password' => $hashed, ':username' => $username);
$sql->execute($values);
$sql = $dbcon->prepare("DELETE FROM resetpassword WHERE username=:username AND resetkey=:resetkey");
$values = array(':username' => $username, ':resetkey' => $key);
$sql->execute($values);
}
} else {
array_push($pageError, getLangString("password-length-error"));
}
} else {
array_push($pageError, getLangString("password-mismatch-error"));
}
} else {
array_push($pageError, getLangString("password-link-expired-error"));
}
} else {
array_push($pageError, getLangString("password-link-invalid-error"));
}
} else {
array_push($pageError, getLangString("invalid-request-error"));
}
}
} else {
array_push($pageError, getLangString("retry-captcha"));
}
}

if(count($pageError) > 0){
foreach ($pageError as $key => $value) {
print('<span>' . $value . '</span><br>');
}
}


Sorry about this

DESCRIBE users

Answer

Posting as a community wiki. (no rep should come of this).

The error is clear, the usertype column does not exist.

Either you create it, or remove it from the queries.