Bug #1317
closedmove fails for properties when new file exists
Description
When performing a MOVE the properties database is adjusted with an )"UPDATE properites SET resource = "new" WHERE resource ="old"). This however fails if there is properties for the new file since there now would be two records with the exactly same columns and sqlite fails the call.
Now I do not know SQL that well, but I think that the UPDATE call should by prefixed with a ("DELETE FROM properties where resource="new"). This worked when I did it offline using the sqlite3 utility.
Besides failing when there is an new file, the current situation also means that we inherit the properties from the existing new file.
-- henrik.holst2
Updated by HenrikHolst about 17 years ago
I have tested the patch against 1.5.x and it works so please consider this for inclusion for both 1.4.x and 1.5.x since MOVE operation without this patch fails horribly when there is metadata properties.
Updated by stbuehler about 16 years ago
- Target version changed from 1.4.20 to 1.4.21
Updated by icy almost 16 years ago
- Target version changed from 1.4.21 to 1.4.22
- Patch available set to No
Updated by stbuehler over 15 years ago
- Target version changed from 1.4.22 to 1.4.23
Updated by stbuehler over 15 years ago
- Target version changed from 1.4.23 to 1.4.24
Updated by stbuehler about 15 years ago
- Status changed from New to Fixed
- % Done changed from 0 to 100
Applied in changeset r2630.
Also available in: Atom