Comment 12 for bug 1209085

update-smart-drivedb was dropped in 6.4+svn4214-1:

smartmontools (6.4+svn4214-1) unstable; urgency=medium
...
  [ Jonathan Dowland ]
...
  * Get rid of update-smart-drivedb. Closes: #783317, #804299, #706909.
...
 -- Jonathan Dowland <email address hidden> Thu, 04 Feb 2016 23:21:58 +0000

So the last ubuntu release that is still supported and has this bug is trusty. As others have pointed out, adding -L to curl's command line fixes that case:
--- a/update-smart-drivedb.in
+++ b/update-smart-drivedb.in
@@ -155,7 +155,7 @@ download()

   case $tool in
     curl)
- vrun curl ${q:+-s} -f --max-redirs 0 \
+ vrun curl ${q:+-s} -f -L --max-redirs 0 \