X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate75.py;fp=dak%2Fdakdb%2Fupdate75.py;h=d152d6495a38eb411fcc4b48c51aed6336a2ae34;hb=368f71cb16139abf72d1c351b1fe64c5470365cf;hp=e66843374fee87158d1f2363eb386de8c7d1df35;hpb=80a6a79b8b82ec9bda2fa68f69ce611048a4d110;p=dak.git

diff --git a/dak/dakdb/update75.py b/dak/dakdb/update75.py
index e6684337..d152d649 100644
--- a/dak/dakdb/update75.py
+++ b/dak/dakdb/update75.py
@@ -54,7 +54,7 @@ def _track_files_per_archive(cnf, c):
        FROM files f
        JOIN location l ON f.location = l.id""", (archive_id,))
 
-    c.execute("""UPDATE files f SET filename = substring(f.filename FROM '/(.*)')
+    c.execute("""UPDATE files f SET filename = substring(f.filename FROM c.name || '/(.*)')
       FROM location l, component c
       WHERE f.location = l.id AND l.component = c.id
         AND f.filename LIKE c.name || '/%'""")