[Digikam-devel] [Bug 235928] digikam fails to open database at startup

[Bruno Friedmann]

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





--- Comment #81 from Bruno Friedmann <brunofr ioda net>  2010-12-02 13:58:01 ---
Hi Gilles, sorry take me some times to get the new 4.6b1 and digikam 1.6 up and
running.

Well the bad new : the index are wrong in 1.6x like they where in 1.4 & 1.5
version

Here's how you can correct this ( I made the patch this time, and my
explanation before wasn't understand nor applyied ! )

diff -u dbconfig.xml.original dbconfig.xml
--- dbconfig.xml.original       2010-12-02 13:53:39.969326075 +0100
+++ dbconfig.xml        2010-12-02 13:55:19.766326076 +0100
@@ -554,7 +554,7 @@
                             caption LONGTEXT CHARACTER SET utf8,
                             collection LONGTEXT CHARACTER SET utf8,
                             icon INTEGER,
-                            UNIQUE(albumRoot, relativePath(332)));</statement>
+                            UNIQUE(albumRoot, relativePath(254)));</statement>
             <statement mode="plain">CREATE TABLE Images
                             (id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
                             album INTEGER,
@@ -564,7 +564,7 @@
                             modificationDate DATETIME,
                             fileSize INTEGER,
                             uniqueHash VARCHAR(32),
-                            UNIQUE (album, name(332)));</statement>
+                            UNIQUE (album, name(254)));</statement>
             <statement mode="plain">CREATE TABLE ImageHaarMatrix
                             (imageid INTEGER PRIMARY KEY,
                             modificationDate DATETIME,
@@ -648,7 +648,7 @@
                             (imageid  INTEGER NOT NULL,
                             property LONGTEXT CHARACTER SET utf8    NOT NULL,
                             value    LONGTEXT CHARACTER SET utf8    NOT NULL,
-                            UNIQUE (imageid, property(332)));</statement>
+                            UNIQUE (imageid, property(254)));</statement>
             <statement mode="plain">CREATE TABLE IF NOT EXISTS Searches
                             (id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
                             type INTEGER,
@@ -664,7 +664,7 @@
             <statement mode="plain">CREATE TABLE IF NOT EXISTS Settings
                             (keyword LONGTEXT CHARACTER SET utf8 NOT NULL,
                             value LONGTEXT CHARACTER SET utf8,
-                            UNIQUE(keyword(333)));</statement></dbaction>
+                            UNIQUE(keyword(254)));</statement></dbaction>


             <!-- Indizes for V5 -->
@@ -872,12 +872,12 @@
                 <statement mode="query">CREATE TABLE FilePaths
                             (path LONGTEXT CHARACTER SET utf8,
                             thumbId INTEGER,
-                            UNIQUE(path(333)))
+                            UNIQUE(path(254)))
                 </statement>
                 <statement mode="query">CREATE TABLE Settings
                             (keyword LONGTEXT CHARACTER SET utf8 NOT NULL,
                             value LONGTEXT CHARACTER SET utf8,
-                            UNIQUE(keyword(333)))
+                            UNIQUE(keyword(254)))
                 </statement>
             </dbaction>
             <!-- Thumbnails Indexes DB -->

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.