From df9efe0dba918da8c19f9cdd187ede7244702925 Mon Sep 17 00:00:00 2001
From: Banana <mail@bananas-playground.net>
Date: Sat, 2 Jan 2021 21:25:07 +0100
Subject: [PATCH] mariadb did not like this.

---
 TODO                                           | 1 +
 webclient/lib/managecollectionfields.class.php | 2 +-
 2 files changed, 2 insertions(+), 1 deletion(-)

diff --git a/TODO b/TODO
index 76ad323..9f9887f 100644
--- a/TODO
+++ b/TODO
@@ -7,3 +7,4 @@
 * delete of a collection
 * sort by filter for collection display
 * responsive and breakpoints
+* tag management. Edit, update and unused ones.
diff --git a/webclient/lib/managecollectionfields.class.php b/webclient/lib/managecollectionfields.class.php
index 4bb8615..4dfa5d9 100644
--- a/webclient/lib/managecollectionfields.class.php
+++ b/webclient/lib/managecollectionfields.class.php
@@ -170,7 +170,7 @@ class ManageCollectionFields {
 						$queryStr .= "($v,$k),";
 					}
 					$queryStr = trim($queryStr, ",");
-					$queryStr .= " AS newEntry(fid,s) ON DUPLICATE KEY UPDATE `sort`=s";
+					$queryStr .= " ON DUPLICATE KEY UPDATE `sort` = VALUES(`sort`)";
 
 					if(QUERY_DEBUG) error_log("[QUERY] ".__METHOD__." query: ".var_export($queryStr,true));
 					$q2 = $this->_DB->query($queryStr);
-- 
2.39.5