diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2023-11-09 23:59:43 +0100 |
|---|---|---|
| committer |  GitHub <noreply@github.com>
| 2023-11-09 23:59:43 +0100 |
| commit | d918ab8bc80a31f31ac0e7102096e251d4fd5144 (patch) | |
| tree | a283768c6586a1ca763f9f1ffe98e1de6309342c | |
| parent | 68aa9f335e9b8fd5d322f219e50fdc741b827cca (diff) | |
Fix updateTagName (#5842)
fix https://github.com/FreshRSS/FreshRSS/issues/5840
Regression from https://github.com/FreshRSS/FreshRSS/pull/5328
| -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 { |