mysql 2053_php – MySql一般错误：2053

我收到了错误：

ERROR: SQLSTATE[HY000]: General error: 2053

我不知道为什么会发生这种情况,因为代码工作正常并且数据库已更新,但它仍然会返回此错误.

这是我的代码：

header("Content-Type: application/json; charset=UTF-8");

require 'UHCauth.php';

try {

$conn = new PDO("mysql:host=$mysql_serv;dbname=$mysql_db", $mysql_user, $mysql_pass);

$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$conn->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

if(isset($_GET['d6518e47'])) {

$USERNAME = $_GET['d6518e47'];

$stmt = $conn->prepare(

"UPDATE $mysql_table

SET KILLS = KILLS+1 WHERE USERNAME = :USERNAME"

);

$stmt->execute(array('USERNAME' => $USERNAME));

$row = $stmt->fetch(PDO::FETCH_ASSOC);

echo json_encode($row);

} else {

$stmt = $conn->prepare(

"SELECT * FROM $mysql_table

ORDER BY

McVersion DESC,

ModVersion DESC

LIMIT 1"

);

$stmt->execute();

$row = $stmt->fetch(PDO::FETCH_ASSOC);

echo json_encode($row);

}

} catch(PDOException $e) {

echo 'ERROR: ' . $e->getMessage();

}

?>