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

classic Classic list List threaded Threaded
99 messages Options
12345
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #20 from Gandalf Lechner <gandalf lechner univie ac at>  2010-05-11 10:18:32 ---
This is how it works for me now:

Starting from scratch (no database, no settings), I set my path in the welcome
dialog, but then have to set it again after the first run wizard is completed.
Scanning seems to work ok and does not get stuck anymore, but then, there are
no albums visible in digikam afterwards.

--
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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Gilles Caulier-4
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #21 from Gilles Caulier <caulier gilles gmail com>  2010-05-11 10:34:01 ---
Just starting to test. I follow Gandalf comment there to ask than progress bar
in scan dialog is always set to 100%. scanning still under progress there...
Wait and see.

Note : I starting agin from scratch too. Not DB, no settings. To set 1th root
album and DB path in first run wizard, digiKam do not ask me again root
collection paths with setup collection page.

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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Gilles Caulier-4
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #22 from Gilles Caulier <caulier gilles gmail com>  2010-05-11 10:35:21 ---
Marcel,

Result is the same there : no physical album can be seen in left sidebar after
than scan is complete.

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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Gilles Caulier-4
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #23 from Gilles Caulier <caulier gilles gmail com>  2010-05-11 10:37:14 ---
Created an attachment (id=43460)
 --> (http://bugs.kde.org/attachment.cgi?id=43460)
digikamrc file from Gilles Caulier computer

--
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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Gilles Caulier-4
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #24 from Gilles Caulier <caulier gilles gmail com>  2010-05-11 10:38:34 ---
Created an attachment (id=43461)
 --> (http://bugs.kde.org/attachment.cgi?id=43461)
lead sqlite DB file from Gilles Caulier computer

--
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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Gilles Caulier-4
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #25 from Gilles Caulier <caulier gilles gmail com>  2010-05-11 10:39:22 ---
Created an attachment (id=43462)
 --> (http://bugs.kde.org/attachment.cgi?id=43462)
thumbs sqlite DB file from Gilles Caulier computer

--
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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Gilles Caulier-4
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #26 from Gilles Caulier <caulier gilles gmail com>  2010-05-11 16:25:27 ---
Marcel,

I updated my 2nd computer my svn trunk. I can see the same dysfunction.

I removed all settings and DB files from my computer and restarted from
scratch.

I will attach files to hack...

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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Gilles Caulier-4
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #27 from Gilles Caulier <caulier gilles gmail com>  2010-05-11 16:26:42 ---
Created an attachment (id=43473)
 --> (http://bugs.kde.org/attachment.cgi?id=43473)
digikamrc file from 2nd Gilles Caulier computer

--
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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Gilles Caulier-4
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #28 from Gilles Caulier <caulier gilles gmail com>  2010-05-11 16:27:41 ---
Created an attachment (id=43474)
 --> (http://bugs.kde.org/attachment.cgi?id=43474)
lead sqlite DB file from 2nd Gilles Caulier computer

--
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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Gilles Caulier-4
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #29 from Gilles Caulier <caulier gilles gmail com>  2010-05-11 16:28:15 ---
Created an attachment (id=43475)
 --> (http://bugs.kde.org/attachment.cgi?id=43475)
thumbs sqlite DB file from 2nd Gilles Caulier computer

--
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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Gilles Caulier-4
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #30 from Gilles Caulier <caulier gilles gmail com>  2010-05-11 17:20:10 ---
Marcel,

Same problem on my last computer. Same configuration, same settings...

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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Gilles Caulier-4
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #31 from Gilles Caulier <caulier gilles gmail com>  2010-05-11 17:22:52 ---
Created an attachment (id=43476)
 --> (http://bugs.kde.org/attachment.cgi?id=43476)
digikamrc file from 3th Gilles Caulier computer

--
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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Gilles Caulier-4
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #32 from Gilles Caulier <caulier gilles gmail com>  2010-05-11 17:23:38 ---
Created an attachment (id=43477)
 --> (http://bugs.kde.org/attachment.cgi?id=43477)
lead sqlite DB file from 3th Gilles Caulier computer

--
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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Gilles Caulier-4
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #33 from Gilles Caulier <caulier gilles gmail com>  2010-05-11 17:24:17 ---
Created an attachment (id=43478)
 --> (http://bugs.kde.org/attachment.cgi?id=43478)
thumbs sqlite DB file from 3th Gilles Caulier computer

--
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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Marcel Wiesweg
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #34 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-05-11 18:00:02 ---
Gilles, sorry for making you test this on many machines. This has been not a
single bug but an accumulation of at least four or five different problems,
three of them now fixed. I can reproduce the problem that no albums are visible
after the initial scan in a fresh installation. Will fix it.

--
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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Bugzilla from Julien@narboux.fr
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928


Julien Narboux <[hidden email]> changed:

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




--- Comment #35 from Julien Narboux <Julien narboux fr>  2010-05-12 19:58:34 ---
Using svn version of today, i get the following error message at startup and
Digikam is stuck.

No album library path has been found in the configuration file. Giving up the
schema updating process. Please try with an empty database, or repair your
configuration.

Here is console output :
digikam(9512)/digikam (core) Digikam::AlbumManager::setDatabase:
DatabaseParameters: [ Type "QSQLITE", Name "/home/jnarboux/Images/digikam4.db"
(Thumbnails Name "/home/jnarboux/Images/thumbnails-digikam.db");
ConnectOptions: "", Host Name and Port: "" -1; Username and Password: "", ""]
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in
use, all queries will cease to work.
digikam(9512)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater
update
digikam(9512)/digikam (core) Digikam::SchemaUpdater::startUpdates: Have a
database structure version  "4"
digikam(9512)/digikam (core) Digikam::SchemaUpdater::makeUpdates: makeUpdates
4  to  5
digikam(9512)/digikam (core) Digikam::SchemaUpdater::updateV4toV5: updateV4toV5
digikam(9512)/digikam (core) Digikam::SchemaUpdater::updateV4toV5: Moved tables
digikam(9512)/digikam (core) Digikam::SchemaUpdater::updateV4toV5: Dropped
triggers
digikam(9512)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig:
"/usr/share/kde4/apps/digikam/database/dbconfig.xml"
digikam(9512)/digikam (core): Album library path from config file is empty.
Aborting update.
digikam(9512)/digikam (core) Digikam::DatabaseCoreBackend::prepareQuery:
Prepare failed!
digikam(9512)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "DELETE FROM Albums WHERE albumRoot=?;"
Error messages: "no such column: albumRoot Unable to execute statement" 1 2 "no
such column: albumRoot" "Unable to execute statement" QSqlError(-1, "", "")
Bound values:  ()
digikam(9512)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "DELETE FROM Albums WHERE albumRoot=?;"
Error messages: " Parameter count mismatch" -1 2 "" "Parameter count mismatch"
QSqlError(-1, "", "")
Bound values:  (QVariant(int, 0) )
digikam(9512)/digikam (core) Digikam::DatabaseCoreBackend::prepareQuery:
Prepare failed!
digikam(9512)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "SELECT Albums.id, Albums.relativePath, Albums.albumRoot from Albums; "
Error messages: "no such column: Albums.relativePath Unable to execute
statement" 1 2 "no such column: Albums.relativePath" "Unable to execute
statement" QSqlError(-1, "", "")
Bound values:  ()
digikam(9512)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "SELECT Albums.id, Albums.relativePath, Albums.albumRoot from Albums; "
Error messages: "No query Unable to fetch row" -1 1 "No query" "Unable to fetch
row" QSqlError(-1, "", "")
Bound values:  ()
QMetaMethod::invoke: Unable to handle unregistered datatype
'DatabaseErrorAnswer*'
digikam(9512)/digikam (core): Failed to invoke DatabaseErrorHandler. Aborting
all queries.
digikam(9512)/digikam (core) Digikam::IccSettingsPriv::scanDirectories:
("/usr/share/color/icc")
Time elapsed: 127 ms
Time elapsed: 4 ms
Model: Time elapsed: 166 ms
TextureColorizer: Time elapsed: 90 ms
digikam(9512)/digikam (core) Digikam::SearchTextBar::setModel: Got new model
Digikam::AbstractCheckableAlbumModel(0x32204e0)








Trying again I get this output :





digikam(9558)/digikam (core) Digikam::AlbumManager::setDatabase:
DatabaseParameters: [ Type "QSQLITE", Name "/home/jnarboux/Images/digikam4.db"
(Thumbnails Name "/home/jnarboux/Images/thumbnails-digikam.db");
ConnectOptions: "", Host Name and Port: "" -1; Username and Password: "", ""]
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in
use, all queries will cease to work.
digikam(9558)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater
update
digikam(9558)/digikam (core) Digikam::SchemaUpdater::startUpdates: Have a
database structure version  "4"
digikam(9558)/digikam (core) Digikam::SchemaUpdater::makeUpdates: makeUpdates
4  to  5
digikam(9558)/digikam (core) Digikam::SchemaUpdater::updateV4toV5: updateV4toV5
digikam(9558)/digikam (core) Digikam::SchemaUpdater::updateV4toV5: Moved tables
digikam(9558)/digikam (core) Digikam::SchemaUpdater::updateV4toV5: Dropped
triggers
digikam(9558)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig:
"/usr/share/kde4/apps/digikam/database/dbconfig.xml"
digikam(9558)/digikam (core): Album library path from config file is empty.
Aborting update.
QInotifyFileSystemWatcherEngine::addPaths: inotify_add_watch failed: Aucun
fichier ou dossier de ce type
QFileSystemWatcher: failed to add paths: /home/jnarboux/.config/ibus/bus
Bus::open: Can not get ibus-daemon's address.
IBusInputContext::createInputContext: no connection to ibus-daemon

--
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
Reply | Threaded
Open this post in threaded view
|

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

Jasper
Using an 'external' mysql server worked amazingly well, with the fantastic migration tool working as expected. Nice!
  The thumbnails didn't seem to migrate all the same, as evident by rebuild all thumbnails -> scan, rethumbnailing every one.

 The internal server option did not work at all, error connecting dialogue indefinatley.

Jasper
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Marcel Wiesweg
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #36 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-05-13 15:30:33 ---
SVN commit 1126263 by mwiesweg:

Don't forget to order counting of total-files-to-scan in case the progress
dialog is shown at first start

CCBUG: 235928

 M  +1 -1      scancontroller.cpp  


WebSVN link: http://websvn.kde.org/?view=rev&revision=1126263

--
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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Marcel Wiesweg
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #37 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-05-13 15:44:35 ---
SVN commit 1126273 by mwiesweg:

Some polishing.
Streamline legacyAndDefaultChecks().
Do not remove old entries in legacyAndDefaultChecks(), the "Album Path" is used
by SchemaUpdater.

CCBUG: 235928

 M  +42 -35    databaseparameters.cpp  
 M  +4 -1      databaseparameters.h  


WebSVN link: http://websvn.kde.org/?view=rev&revision=1126273

--
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
Reply | Threaded
Open this post in threaded view
|

[Bug 235928] digikam fails to open database at startup

Marcel Wiesweg
In reply to this post by Bugzilla from gandalf.lechner@univie.ac.at
https://bugs.kde.org/show_bug.cgi?id=235928





--- Comment #38 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-05-13 15:44:41 ---
SVN commit 1126274 by mwiesweg:

Fix bug where logic was reverted.
As there is no such thing as a null QSqlQuery, pass only the query text
and the last error to the error handler.

CCBUG: 235928

 M  +5 -5      digikam/databaseguierrorhandler.cpp  
 M  +2 -2      digikam/databaseguierrorhandler.h  
 M  +3 -3      libs/database/databaseerrorhandler.h  


WebSVN link: http://websvn.kde.org/?view=rev&revision=1126274

--
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
12345