[Digikam-devel] [digikam] [Bug 355831] MySQL Schema Improvements

[via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=355831

--- Comment #59 from caulier.gilles at gmail.com ---
Richard, i tested your patch #95928, and i can see a lots of dupplicates tags
created with the same name when i create a new database (mysql internal).

My collection of image :

digikam version 5.0.0-beta3
Images: 
JP2: 10
JPG: 1549
PGF: 7
PNG: 141
PPM: 2
RAW-ARW: 13
RAW-CR2: 45
RAW-CRW: 5
RAW-DCR: 2
RAW-DNG: 18
RAW-MRW: 18
RAW-NEF: 19
RAW-ORF: 4
RAW-PEF: 7
RAW-RAF: 10
RAW-RAW: 1
RAW-RWL: 1
RAW-X3F: 2
TIFF: 28
total: 1882
: 
Videos: 
MOV: 6
total: 6
: 
Total Items: 1888
Albums: 164
Tags: 90
: 
Database backend: QMYSQL
Database internal server: Yes
Database internal server Path: /mnt/data

While importing collection in DB, i can see also these warning, about
versionning metadata imported from XMP :

digikam.dimg: "/mnt/data/TEST_IMAGES/splashs/showfoto-splash.png"  : PNG file
identified
digikam.database: Adding new item
"/mnt/data/TEST_IMAGES/splashs/showfoto-splash.png"
digikam.metaengine: DateTime => Exif.Photo.DateTimeOriginal => 
QDateTime(2010-12-29 00:00:00.000 CET Qt::TimeSpec(LocalTime))
digikam.metaengine: DateTime => Exif.Photo.DateTimeOriginal => 
QDateTime(2010-12-29 00:00:00.000 CET Qt::TimeSpec(LocalTime))
digikam.metaengine: "/mnt/data/TEST_IMAGES/splashs/showfoto-splash.png"  ==>
Read Iptc Keywords:  ()
digikam.database: Pick Label found :  0
digikam.database: Cannot find Pick Label Tag for :  0
digikam.database: Color Label found :  0
digikam.database: Cannot find Color Label Tag for :  0
digikam.metaengine: Loading image history  ""
digikam.database: Scanning took 3 ms
digikam.database: Finishing took 1 ms
digikam.database: Folder does not exist or is not readable: 
"/mnt/data/lost+found"
digikam.database: Attempt to create tag properties for tag id 0
digikam.database: items to tag (2, 178, 184, 1199, 1383, 1450, 1543, 1563,
1567, 1568, 1806, 1814, 1837, 1838, 1843, 1844, 1846, 1849, 1850, 1854, 1858,
1859, 1860, 1861, 1864, 1865, 1869)
digikam.database: Broken history: Same file referred by different entries.
Refusing to add a loop.
digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 2 UUID: e8ff0e... }"

digikam.database: Graph with 2 vertices: 
"{ Ids: () UUID: a7150e... } -> { Id: 178 UUID: a00753... }"

digikam.database: Image 178 type QFlags(0x8)
digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 184 }"

digikam.database: Graph with 2 vertices: 
"{ Ids: () UUID: fcac8f... } -> { Id: 1199 UUID: c9fecb... }"

digikam.database: Image 1199 type QFlags(0x8)
digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1383 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1450 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1543 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1563 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1567 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1568 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1806 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1814 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1837 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1838 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1843 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1844 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1846 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1849 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1850 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1854 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1858 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1859 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1860 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1861 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1864 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1865 }"

digikam.database: Graph with 1 vertices: 
"Unconnected: { Id: 1869 }"

digikam.database: Complete scan took: 31320 msecs.

Gilles

-- 
You are receiving this mail because:
You are the assignee for the bug.