Comment 5 for bug 676011

Path is given precedence as well, so we'll have to fix them first. At least it's updated to the new path once it's properly matched up.

SQL for cleaning up broken paths: https://pastebin.canonical.com/41276/