X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate75.py;h=d152d6495a38eb411fcc4b48c51aed6336a2ae34;hb=38414180941de27a33450cd192aba8bff6d0c1ac;hp=e66843374fee87158d1f2363eb386de8c7d1df35;hpb=09a1a20566dcf84ca229b4339bd8f8080eb59afd;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 || '/%'""")