VideoTable not updated when relocating library
Submitted by an unknown user
Link to original bug (#719106)
Description
---- Reported by shotwell-maint@gnome.bugs 2013-11-10 09:07:00 -0800 ----
Original Redmine bug id: 7678
Original URL: http://redmine.yorba.org/issues/7678
Searchable id: yorba-bug-7678
Original author: Teo Romera
Original description:
Hello,
I have been using ShotWell on Ubuntu for a few months to store videos and pictures.
I was storing my database and my pictures/videos on an external hard drive (TranscendBa).
Library path was /media/TranscendBa/RTWLib/
Pictures stored in /media/TranscendBA/RTWPicsAndVideos/
I used to start ShotWell like this shotwell -d /media/TranscendBa/RTWLib/
No problems ever.
Now I changed my operating system from Ubuntu to Debian and it is automatically mounting the external hard drive on a different mount point, it adds the username after /media/.
New mount point for the external hard drive is
/media/teo/TranscendBa/RTWLib/
I opened Shotwell telling him where the data for the library was shotwell -d /media/teo/TranscendBa/RTWLib/
Obviously Shotwell could not find the pictures/videos and all of them appeared as missing files.
In order to make Shotwell aware of the new location for the pictures/videos I
did as suggested in the FAQ, went to Edit -> Preferences and chose the new
path /media/teo/TranscendBA/RTWPicsAndVideos/
I waited for a few minutes while Shotwell rebuilt the library.
When it finished, I checked and all the pictures were found and located again. But absolutely all the video files were still in missing files.
I checked the photo.db
file with SQLiteBrowser and I found that the
filename
field in PhotoTable
table had been successfully updated for every
record. But the VideoTable
table records had not been updated and the
filename
field was still holding the old value (see screenshots attached).
I am now running ShotWell 0.14.1 on Debian Sid and this is the instance that failed to update the database table.
I cannot remember what version I was using in Ubuntu, but I guess that is not so important.
Thanks.
Related issues: duplicates shotwell - 7462: Videos not moved out of Missing Files when re-imported (Fixed)
---- Additional Comments From shotwell-maint@gnome.bugs 2013-11-16 05:49:00 -0800 ----
History
Comment 1
Updated by Teo Romera 11 days ago
I got it fixed and my videos are again located by Shotwell by running this query from SQLitebrowser:
UPDATE VideoTable SET filename = replace( filename, '/media/TranscendBa/RTWPicsAndVideos/', '/media/teo/TranscendBa/RTWPicsAndVideos/' ) WHERE filename LIKE '/media/%';
Comment 2
Updated by Jim Nelson 10 days ago
- Status changed from Open to Duplicate
What you're describing is #7462, which was fixed in 0.15.
Comment 3
Updated by Teo Romera 5 days ago
Sorry about that. Great to know it is fixed.
--- Bug imported by chaz@yorba.org 2013-11-25 21:59 UTC ---
This bug was previously known as bug 7678 at http://redmine.yorba.org/show_bug.cgi?id=7678 Imported an attachment (id=262687) Imported an attachment (id=262688)
Unknown Component Using default product and component set in Parameters Unknown version " in product shotwell. Setting version to "!unspecified". Unknown milestone "unknown in product shotwell. Setting to default milestone for this product, "---". Setting qa contact to the default for this product. This bug either had no qa contact or an invalid one.
Resolution: RESOLVED DUPLICATE