From b8a0ed85a347f35a6c34723f80b4a7355f577785 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 1 Feb 2018 10:09:11 +0100 Subject: bin/build-master-status: bugfix --- bin/build-master-status | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'bin/build-master-status') diff --git a/bin/build-master-status b/bin/build-master-status index 2477e3b..1672789 100755 --- a/bin/build-master-status +++ b/bin/build-master-status @@ -538,22 +538,23 @@ if ${web}; then # update todos # shellcheck disable=SC2016 while read -r file line desc; do - printf 'UPDATE TABLE `todos`' + printf 'UPDATE `todos`' printf ' SET `todos`.`line`=from_base64("%s")' \ "${line}" printf ' WHERE `todos`.`file`=from_base64("%s")' \ "${file}" - printf ' AND `todos`.`desc`=from_base64("%s");\n' \ + printf ' AND `todos`.`description`=from_base64("%s");\n' \ "${desc}" - printf 'UPDATE TABLE `todos`' - printf ' SET `todos`.`desc`=from_base64("%s")' \ + printf 'UPDATE `todos`' + printf ' SET `todos`.`description`=from_base64("%s")' \ "${desc}" printf ' WHERE `todos`.`file`=from_base64("%s")' \ "${file}" printf ' AND `todos`.`line`=from_base64("%s");\n' \ "${line}" - done | \ + done < \ + "${tmp_dir}/todos" | \ ${mysql_command} # insert unfound todos # shellcheck disable=SC2016 -- cgit v1.2.3