( ! ) Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

エラーメッセージ

エラー原因

実際に遭遇したエラー原因具体例

public function updateStripe($stripeUserId, $stripeRefreshToken,$id)

{

  $now = new DateTime();      

  $sql = "UPDATE user SET stripe_user_id=:stripe_user_id, stripe_refresh_token=:stripe_refresh_token,update_datetime =update_datetime WHERE id=:id";

  $stmt = $this->execute($sql, array(

      ':stripe_user_id'    => $stripeUserId,

      ':stripe_refresh_token'    => $stripeRefreshToken,

      ':update_datetime'    => $now->format('Y-m-d H:i:s'),

      ':id'       => $id,

  ));

}

public function updateStripe($stripeUserId, $stripeRefreshToken,$id)

{

  $now = new DateTime();      

  $sql = "UPDATE user SET stripe_user_id=:stripe_user_id, stripe_refresh_token=:stripe_refresh_token,update_datetime =:update_datetime WHERE id=:id";

  $stmt = $this->execute($sql, array(

      ':stripe_user_id'    => $stripeUserId,

      ':stripe_refresh_token'    => $stripeRefreshToken,

      ':update_datetime'    => $now->format('Y-m-d H:i:s'),

      ':id'       => $id,

  ));

}