From 1deab93a1407341d134d61faf8cf634349ba040e Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Thu, 18 Sep 2014 14:40:12 +0200 Subject: [PATCH] Preventing issues with parallel requests assigning users --- .../moderation/queue/ModerationQueueManager.class.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/wcfsetup/install/files/lib/system/moderation/queue/ModerationQueueManager.class.php b/wcfsetup/install/files/lib/system/moderation/queue/ModerationQueueManager.class.php index 86c2fd4032..27a209096f 100644 --- a/wcfsetup/install/files/lib/system/moderation/queue/ModerationQueueManager.class.php +++ b/wcfsetup/install/files/lib/system/moderation/queue/ModerationQueueManager.class.php @@ -272,9 +272,9 @@ class ModerationQueueManager extends SingletonFactory { * @param array $assignments */ public function setAssignment(array $assignments) { - $sql = "INSERT INTO wcf".WCF_N."_moderation_queue_to_user - (queueID, userID, isAffected) - VALUES (?, ?, ?)"; + $sql = "INSERT IGNORE INTO wcf".WCF_N."_moderation_queue_to_user + (queueID, userID, isAffected) + VALUES (?, ?, ?)"; $statement = WCF::getDB()->prepareStatement($sql); WCF::getDB()->beginTransaction(); -- 2.20.1