From a873c43098e087bcf12ad822b4eae58cc6f38a0e Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 29 Mar 2018 13:55:52 +0200 Subject: lib/mysql-functions: fix column name --- lib/mysql-functions | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/mysql-functions b/lib/mysql-functions index 418f15b..440ba6f 100755 --- a/lib/mysql-functions +++ b/lib/mysql-functions @@ -904,7 +904,7 @@ mysql_cleanup() { printf 'SELECT * FROM `files` PARTITION (p%s)' \ "${partition}" printf ' WHERE `files`.`id`=`file_providers`.`file`' - printf ' AND `files`.`name_hash`=`file_providers`.`name_hash`' + printf ' AND `files`.`name_hash`=`file_providers`.`file_name_hash`' printf ');\n' # remove obsolete files printf '%s FROM `files` PARTITION (p%s)' \ @@ -913,7 +913,7 @@ mysql_cleanup() { printf 'SELECT * FROM `file_providers` PARTITION (p%s)' \ "${partition}" printf ' WHERE `files`.`id`=`file_providers`.`file`' - printf ' AND `files`.`name_hash`=`file_providers`.`name_hash`' + printf ' AND `files`.`name_hash`=`file_providers`.`file_name_hash`' printf ');\n' done } | \ -- cgit v1.2.3-70-g09d2