From 5d4ee96c75951a99060497c484fe605cee638135 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 6 Jun 2018 09:41:43 +0200 Subject: lib/mysql-functions: fix mysql queries --- lib/mysql-functions | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'lib/mysql-functions') diff --git a/lib/mysql-functions b/lib/mysql-functions index 1c8a3f0..d159fe9 100755 --- a/lib/mysql-functions +++ b/lib/mysql-functions @@ -874,7 +874,7 @@ mysql_cleanup() { printf ');\n' # remove jobs from build slaves that are not on the build-list if [ "${operator}" = 'DELETE' ]; then - printf 'UPDATE `repositories`' + printf 'UPDATE `binary_packages_in_repositories`' else printf 'SELECT COUNT(DISTINCT `build_slaves`.`id`) FROM `binary_packages_in_repositories`' fi @@ -887,7 +887,7 @@ mysql_cleanup() { printf ' SET `build_slaves`.`currently_building`=NULL' fi printf ' WHERE `build_slaves`.`currently_building` IS NOT NULL' - printf ' AND `repositories`.`id` IS NULL;\n' + printf ' AND `binary_packages_in_repositories`.`id` IS NULL;\n' # remove build orders from build slaves which have not connected within 1h if [ "${operator}" = 'DELETE' ]; then printf 'UPDATE `build_slaves`' -- cgit v1.2.3