| Summary: | MYSQL : try to access to database from two computers and collections get lost | ||
|---|---|---|---|
| Product: | [Applications] digikam | Reporter: | Messie <roggen.dorf> |
| Component: | Database-Multiusers | Assignee: | Digikam Developers <digikam-bugs-null> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | caulier.gilles, e.longuemare, metzpinguin |
| Priority: | NOR | ||
| Version: | 2.8.0 | ||
| Target Milestone: | --- | ||
| Platform: | Ubuntu | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | 8.0.0 | |
| Sentry Crash Report: | |||
|
Description
Messie
2012-11-14 16:49:16 UTC
Hello, should you look at mysql what is in your AlbumRoots table: SELECT * FROM digikam.AlbumRoots; when you start from the first computer and after from the second. Greatings, Eric Thank you for the quick response. Here ist is: first on computer 1: mysql> SELECT * FROM digikam.AlbumRoots; +----+-------+--------+------+-----------------------------------------------------+--------------+ | id | label | status | type | identifier | specificPath | +----+-------+--------+------+-----------------------------------------------------+--------------+ | 15 | Fotos | 0 | 1 | volumeid:?uuid=5caa86b6-395e-42f8-bc50-41b1bf9b62eb | /Daten/Fotos | +----+-------+--------+------+-----------------------------------------------------+--------------+ after starting digikam on computer 2: mysql> SELECT * FROM digikam.AlbumRoots; +----+-------+--------+------+-----------------------------------------------------+--------------+ | id | label | status | type | identifier | specificPath | +----+-------+--------+------+-----------------------------------------------------+--------------+ | 15 | Fotos | 0 | 1 | volumeid:?uuid=5caa86b6-395e-42f8-bc50-41b1bf9b62eb | /Daten/Fotos | +----+-------+--------+------+-----------------------------------------------------+--------------+ after settings / add new collection on computer 2: mysql> SELECT * FROM digikam.AlbumRoots; +----+-------+--------+------+-----------------------------------------------------+----------------------+ | id | label | status | type | identifier | specificPath | +----+-------+--------+------+-----------------------------------------------------+----------------------+ | 16 | Fotos | 0 | 1 | volumeid:?uuid=e46888da-6ac1-4870-8365-dbc13a82942f | /mnt/Server2TB/Fotos | +----+-------+--------+------+-----------------------------------------------------+----------------------+ again on computer 1 and after settings / add new collection: mysql> SELECT * FROM digikam.AlbumRoots; +----+-------+--------+------+-----------------------------------------------------+--------------+ | id | label | status | type | identifier | specificPath | +----+-------+--------+------+-----------------------------------------------------+--------------+ | 17 | Fotos | 0 | 1 | volumeid:?uuid=5caa86b6-395e-42f8-bc50-41b1bf9b62eb | /Daten/Fotos | +----+-------+--------+------+-----------------------------------------------------+--------------+ But the definition of the path is "/mnt/Server2TB/Daten/Fotos" and not like in specificPath. On computer 2 both are same. Hello, I think this not a bug. I use digikam 2.8.0 on a network share (Nas) without problem (except this : https://bugs.kde.org/show_bug.cgi?id=283323). I don't have the problem because my share is mounted the same way (I use Xubuntu 12.04 for my desktops). In your case the Id change, so digikam think that they are two different collections. Should you give /etc/fstab files from both computers ? Greatings, Eric I forget, Normally when you connect the 2 nd computer, you don't have to had a new collection. I think you should try to "bypass", cancel adding the collection in digikam, then configure your mysql in digikam option and restart. Greatings, Eric Here : The databse is not valid: The setting "DBThumbnailVersion" is not existing. The current version of the database scheme cannot be checked. Try to start new with an empty database It's another problem. Here is my config for the shared collection :
> SELECT * FROM digikam.AlbumRoots
+ ------- + ---------- + ----------- + --------- + --------------- + ----------------- +
| id | label | status | type | identifier | specificPath |
+ ------- + ---------- + ----------- + --------- + --------------- + ----------------- +
| 1 | Diskphotos | 0 | 3 | networkshareid:?mountpath=%2Fmedia%2FDiskphotos | / |
| NULL | NULL | NULL | NULL | NULL | NULL |
+ ------- + ---------- + ----------- + --------- + --------------- + ----------------- +
2 rows
Here : after settings / add new collection on computer 2: mysql> SELECT * FROM digikam.AlbumRoots; +----+-------+--------+------+-----------------------------------------------------+----------------------+ | id | label | status | type | identifier | specificPath | +----+-------+--------+------+-----------------------------------------------------+----------------------+ | 16 | Fotos | 0 | 1 | volumeid:?uuid=e46888da-6ac1-4870-8365-dbc13a82942f | /mnt/Server2TB/Fotos | +----+-------+--------+------+-----------------------------------------------------+----------------------+ the uuis is the one of your sda6 on computer 2. Should you use /media/... for mounting your shared disk. I montioned the errormessage "The databse is not valid: The setting "DBThumbnailVersion..." only for the possibility, that it could be related to the other problem. I'll give your proposals a try, but I can't do that tonight (there is a nice redwine from South Africa and some guests...) Hi Eric, type and identifier are different at your computer. How is your nas mounted? Through fstab? Could you give me the line from fstab, so that I can find out differences? Thanks Matthias Computer 1 is writing to AlbumRoots / identifier the UUID of sdb1, the second Harddisk on that machine. Computer 2 is writing the UUID from sda6, where the program digikam is installed. Maybe computer 2 cannot access or see or find out UUID from computer 1? How can I tell digikam to write the mountpath /mnt/Server2TB... to the identifier instead of the UUID? Greetings Matthias I found a workaround: In "AlbumRoots" fill in the field "identifier" the path: "volumeid:?path=/mnt..." If the mounted path on all computers is the same (this is a matter of fstab) digikam works fine on all computers (see comment 32 in bug-report 175923). It's definitely a bug, that digikam takes a UUID, which is working on one coumputer and not on others. Hello, sorry, your mail was put in my spam folder. The link to the bug on uuid problem is here : https://bugs.kde.org/show_bug.cgi?id=175923 I think that when you use networkshare in add collection from digikam, the problem doesn't occure. I'm mounting the NAS in fstab with CIFS : this is my fstab line : //192.168.1.16/photos /media/Diskphotos cifs username=*********,password=*********,iocharset=utf8 0 0 Greatings, Eric Thank you for the bug report. As this report hasn't seen any changes in 5 years or more, we ask if you can please confirm that the issue still persists. If this bug is no longer persisting or relevant please change the status to resolved. Git commit 6a630aeab30849225015826aa185cc8a8516cc74 by Maik Qualmann. Committed on 16/07/2022 at 15:14. Pushed by mqualmann into branch 'master'. add support for alternate network paths in the collection view Related: bug 384820 FIXED-IN: 8.0.0 M +3 -1 NEWS M +4 -0 core/libs/database/collection/collectionlocation.h M +6 -3 core/libs/database/collection/collectionmanager.h M +5 -3 core/libs/database/collection/collectionmanager_location.cpp M +7 -2 core/libs/database/collection/collectionmanager_p.cpp M +2 -3 core/libs/database/collection/collectionmanager_p.h M +206 -17 core/utilities/setup/collections/setupcollectionview.cpp M +21 -8 core/utilities/setup/collections/setupcollectionview.h https://invent.kde.org/graphics/digikam/commit/6a630aeab30849225015826aa185cc8a8516cc74 |