php - PDO 无效参数号错误信息

Question

我正在运行这个 PDO SQL 查询:

$stmt = $pdo_conn->prepare("INSERT into ticket_updates (ticket_seq, notes, datetime, updatedby, customer, internal_message) values (:ticket_seq, :notes, :datetime, :updatedby, :customer, :internal_message) ");
                $stmt->execute(array(':ticket_seq' => $ticketnumber, 
                ':notes' => addslashes($message), 
                ':datetime' => date("Y-m-d H:i:s"),  
                ':updateedby' => $last_updated_by, 
                ':customer' => 'Y', 
                ':internal_message' => 'no'));

但出现此错误:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY093]: Invalid parameter number: parameter was not defined' in /home/integra/public_html/autocheck/support_emails.php:479 Stack trace: #0 /home/integra/public_html/autocheck/support_emails.php(479): PDOStatement->execute(Array) #1 {main} thrown in /home/integra/public_html/autocheck/support_emails.php on line 479

我不确定是什么问题，所有其他查询都正常

Answer 1

在准备中你调用这个参数updatedby但是在绑定(bind)中你有updateedby修复这个并且也许它解决了你的错误。