From bbcdedc4794cda338ae005b4d3361cde4fffd9ce Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Mon, 22 Jan 2018 10:13:27 +0100
Subject: bin/db-update: fix mysql query

---
 bin/db-update | 7 ++-----
 1 file changed, 2 insertions(+), 5 deletions(-)

(limited to 'bin/db-update')

diff --git a/bin/db-update b/bin/db-update
index 343b9d4..1417820 100755
--- a/bin/db-update
+++ b/bin/db-update
@@ -342,7 +342,7 @@ move_packages() {
             "${tmp_dir}/tmp/${package}.to_repo"
         )"
       printf ' WHERE'
-      printf ' `architectures`.`name`=from_base64("%s")' \
+      printf ' `repositories`.`name`=from_base64("%s")' \
         "$(
           base64_encode_each < \
             "${tmp_dir}/tmp/${package}.from_repo"
@@ -364,12 +364,9 @@ move_packages() {
               'pkgver' '\3' \
               'pkgrel' '\4' \
               'sub_pkgrel' '\5'
-            printf ' AND `architectures`.`name`=from_base64("\6")'
+            printf ' AND `architectures`.`name`=from_base64("\\6")'
           )"',
         '
-      printf ' AND `binary_packages`.`%s`=from_base64("%s")' \
-        'epoch' "$(
-        )"
       printf ';\n'
     done < \
       "${tmp_dir}/tmp/${package}.parts"
-- 
cgit v1.2.3-54-g00ecf