diff options
| -rw-r--r-- | app/Models/TagDAO.php | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/app/Models/TagDAO.php b/app/Models/TagDAO.php index 8c0b94c46..a89c04695 100644 --- a/app/Models/TagDAO.php +++ b/app/Models/TagDAO.php @@ -57,15 +57,16 @@ SQL; public function updateTagName(int $id, string $name) { // No category of the same name $sql = <<<'SQL' -UPDATE `_tag` SET name=? WHERE id=? -AND NOT EXISTS (SELECT 1 FROM `_category` WHERE name = ?) +UPDATE `_tag` SET name = :name1 WHERE id = :id +AND NOT EXISTS (SELECT 1 FROM `_category` WHERE name = :name2) SQL; $name = mb_strcut(trim($name), 0, FreshRSS_DatabaseDAO::LENGTH_INDEX_UNICODE, 'UTF-8'); $stm = $this->pdo->prepare($sql); if ($stm !== false && $stm->bindValue(':id', $id, PDO::PARAM_INT) && - $stm->bindValue(':name', $name, PDO::PARAM_STR) && + $stm->bindValue(':name1', $name, PDO::PARAM_STR) && + $stm->bindValue(':name2', $name, PDO::PARAM_STR) && $stm->execute()) { return $stm->rowCount(); } else { |