[Bug 235928] New: digikam fails to open database at startup

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





--- Comment #79 from Bruno Friedmann <brunofr ioda net>  2010-10-09 22:14:37 ---
Sorry Quallenauge, I don't know (nor think I have all the dev package to build
it quickly) about the gsoc branch.

Can someone build it on obs.opensuse.org ? or explain me how to get the
necessary source code, so I can ask to experiment builder to make me a testing
rpm ...

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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





--- Comment #80 from Gilles Caulier <caulier gilles gmail com>  2010-11-24 09:08:12 ---
digiKam 1.6.0 is out:

http://www.digikam.org/drupal/node/550

Please update and check if this entry still valid.

Thanks in advance

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

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.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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





--- Comment #82 from Gilles Caulier <caulier gilles gmail com>  2010-12-02 13:59:31 ---
Marcel your viepoint about patch from #81 ?

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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





--- Comment #83 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-12-06 15:00:30 ---
According to Holger, by private mail, the necessary patches are included in the
GSoc branch for testing, but seem to work quite well. Should be backport the
relevant commits?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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





--- Comment #84 from Gilles Caulier <caulier gilles gmail com>  2010-12-06 15:12:13 ---
If it work, i agree...

Gilles

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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





--- Comment #85 from Gilles Caulier <caulier gilles gmail com>  2011-04-29 11:33:35 ---
Marcel,

This file can be closed now ?

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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


Marcel Wiesweg <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED




--- Comment #86 from Marcel Wiesweg <marcel wiesweg gmx de>  2011-04-30 18:09:06 ---
Yes, as it seems to be fixed with 2.0. If not, anyone feel free to reopen /
create a new report.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Version Fixed In|                            |2.0.0

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #87 from [hidden email] ---
(In reply to Quallenauge from comment #71)
> I've checked in some changes related to this
> problem into the gsoc branch.
>
> Can you please try if this fixes the problem with the following steps:
>
> Delete your (internal) digikam database files
> rm ~/.kde4/share/apps/digikam/db*
> rm ~/.kde4/share/apps/digikam/mysql*
>

I'm facing a exact similar problem. But I'm unable to locate digikam internal
DB files. I receive this output in Konsole:
swati@swati-HP-Pavilion-15-Notebook-PC:~$ cd .kde/share/apps/digikam
bash: cd: .kde/share/apps/digikam: No such file or directory

> Then modify the database template which is located on
> /usr/share/apps/digikam/database/mysql-global.conf
> and enabled the following setting:
> #default_storage_engine=innodb
>
> After that switch to the internal mysql method
> via config dialog and see if it works.
>
> If this is also true for you, we can enable it as default.

Please help through this.
Regards
Swati

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

Maik Qualmann <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #88 from Maik Qualmann <[hidden email]> ---
(In reply to swatilodha27 from comment #87)

> I'm facing a exact similar problem. But I'm unable to locate digikam
> internal DB files. I receive this output in Konsole:
> swati@swati-HP-Pavilion-15-Notebook-PC:~$ cd .kde/share/apps/digikam
> bash: cd: .kde/share/apps/digikam: No such file or directory

For digiKam5 look in $HOME/.local/share/digikam/

Maik

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

--- Comment #89 from [hidden email] ---
(In reply to Maik Qualmann from comment #88)
> (In reply to swatilodha27 from comment #87)
>
> > I'm facing a exact similar problem. But I'm unable to locate digikam
> > internal DB files. I receive this output in Konsole:
> > swati@swati-HP-Pavilion-15-Notebook-PC:~$ cd .kde/share/apps/digikam
> > bash: cd: .kde/share/apps/digikam: No such file or directory
>
> For digiKam5 look in $HOME/.local/share/digikam/
>
Should I remove all these files and try again?
swati@swati-HP-Pavilion-15-Notebook-PC:~/.local/share/digikam$ ls
db_misc  file_db_data  mysql.conf

> Maik

Swati

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

--- Comment #90 from [hidden email] ---
yes, sure, you can remove or rename all dir safety.

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

--- Comment #91 from [hidden email] ---
Removed all the database files and still receiving the same error.

Swati

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

--- Comment #92 from [hidden email] ---
Removed all the database files and still receiving the same error.

Swati

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

--- Comment #93 from [hidden email] ---
Receiving this as error (if that helps):

An error occurred during the internal server start.
Details: Database process exited unexpectedly during initial connection.
Executable: /usr/sbin/mysqld
”
Process error: Unknown error

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

--- Comment #94 from [hidden email] ---
/usr/sbin/mysqld exist on your system ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

--- Comment #95 from [hidden email] ---
Yes it does.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Database                    |Database-Scan

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