bin/build-master-status: bugfix

1 files changed, 6 insertions, 5 deletions

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