digiKam 2.1 and database errors
Locked
 
|
I upgraded from 2.0 to 2.1 this morning using Philip Johnsson's PPA and when I tried running it afterwards I got an error about not being able to connect to the database and it would only load without a database.
Fixed it by going to settings -> database and clicking OK.
What are the 2 separate directory settings for though? _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
2011/9/10 Mark Fraser <[hidden email]>
Not sure what you mean. But database points to the db and collections to the locations of your photos, because albums (collections) are actually folders on your drive. I admit that the title in the collection screen is very confusing, I made a bug report about that, and thought it was agreed by Martin, but still not changed, no priority I guess Rinus
_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
digiKam 1.9 => 2.1 upgrade Mysql woes
|
|
In reply to this post by Mark Fraser
I am trying to upgrade DK 1.9 with mysql back-end to DK 2.1 with the DB
migration screen. Existing DBs are digikam and digikam_thumbnails I have created two new DBs digikam21 and digikam_thumbnails21 The "check DB connection" checks all validate I connect to mysql as root, with a password For good measure I run a prior mysql_upgrade The screen action fails: "Error while creating the database schema." Here is the mysql log: ============= 110910 11:07:01 571 Connect root@localhost on digikam 571 Init DB digikam 571 Query SET NAMES utf8 572 Connect root@localhost on digikam21 572 Init DB digikam21 572 Query SET NAMES utf8 572 Query DROP TABLE IF EXISTS AlbumRoots 572 Query DROP TABLE IF EXISTS Albums 572 Query DROP TABLE IF EXISTS Images 572 Query DROP TABLE IF EXISTS ImageHaarMatrix 572 Query DROP TABLE IF EXISTS ImageInformation 572 Query DROP TABLE IF EXISTS ImageMetadata 572 Query DROP TABLE IF EXISTS ImageTagProperties 572 Query DROP TABLE IF EXISTS TagProperties 572 Query DROP TABLE IF EXISTS ImagePositions 572 Query DROP TABLE IF EXISTS ImageComments 572 Query DROP TABLE IF EXISTS ImageCopyright 572 Query DROP TABLE IF EXISTS Tags 572 Query DROP TABLE IF EXISTS ImageTags 572 Query DROP TABLE IF EXISTS ImageProperties 572 Query DROP TABLE IF EXISTS ImageHistory 572 Query DROP TABLE IF EXISTS ImageRelations 572 Query DROP TABLE IF EXISTS Searches 572 Query DROP TABLE IF EXISTS DownloadHistory 572 Query DROP TABLE IF EXISTS Settings 573 Connect root@localhost on digikam21 573 Init DB digikam21 573 Query SET NAMES utf8 573 Query CREATE TABLE IF NOT EXISTS PrivCheck ( id INT, name VARCHAR(35) ) 573 Query ALTER TABLE PrivCheck DROP COLUMN name 573 Query CREATE TRIGGER privcheck_trigger AFTER DELETE ON PrivCheck FOR EACH ROW BEGIN END 573 Query DROP TRIGGER privcheck_trigger 573 Query DROP TABLE PrivCheck 573 Query DROP TABLE IF EXISTS PrivCheck 573 Quit 572 Query select table_name from information_schema.tables where table_type = 'BASE TABLE' 572 Query SELECT value FROM Settings WHERE keyword='DBVersion' 572 Query SELECT value FROM Settings WHERE keyword='DBVersionRequired' 571 Quit 572 Quit ============================== There are several things I don't understand: - what is the point of this PrivCheck business? A table and trigger are creaed, then dropped - what is the point of this [select table_name from information_schema.tables where table_type = 'BASE TABLE'] without a table_schema and a table_name WHERE clause? - the keyword='DBVersionRequired' record does not exist in the DB v5 - the KDE error essage "Error while creating the database schema." is not reflected in the mysql log or the mysql error log Where can I find the upgrade script so that I can execute it manually? Thanks Ignatius _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
In reply to this post by Rinus Bakker
This happened to me too when I started Digikam 2.1 for the first time
but never happened after that first time. Don't know why. /Philip On Sat, Sep 10, 2011 at 11:15 AM, Rinus Bakker <[hidden email]> wrote: > > > 2011/9/10 Mark Fraser <[hidden email]> >> >> I upgraded from 2.0 to 2.1 this morning using Philip Johnsson's PPA and >> when I tried running it afterwards I got an error about not being able to >> connect to the database and it would only load without a database. >> >> >> >> Fixed it by going to settings -> database and clicking OK. >> >> >> >> What are the 2 separate directory settings for though? > > Not sure what you mean. But database points to the db and collections to the > locations of your photos, because albums (collections) are actually folders > on your drive. > I admit that the title in the collection screen is very confusing, I made a > bug report about that, and thought it was agreed by Martin, but still not > changed, no priority I guess > Rinus >> >> _______________________________________________ >> Digikam-users mailing list >> [hidden email] >> https://mail.kde.org/mailman/listinfo/digikam-users >> > > > _______________________________________________ > Digikam-users mailing list > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users > > Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
In reply to this post by Rinus Bakker
On Saturday 10 Sep 2011 10:15:35 Rinus Bakker wrote: > 2011/9/10 Mark Fraser <[hidden email]> > > > ** > > > > I upgraded from 2.0 to 2.1 this morning using Philip Johnsson's PPA and > > when I tried running it afterwards I got an error about not being able to > > connect to the database and it would only load without a database. > > > > > > > > Fixed it by going to settings -> database and clicking OK. > > > > > > > > What are the 2 separate directory settings for though? > > Not sure what you mean. But database points to the db and collections to > the locations of your photos, because albums (collections) are actually > folders on your drive.
Under Database settings:
[ ] Internal Server Type - SQLite or MySQL The location where the database file will be stored on your system. There is one common database file for all root albums. Write access is required to be able to edit image properties.
Note: a remote file system, such as NFS, cannot be used here.
Directory selection box Type - SQLite or MySQL Directory selection box The location where the database file will be stored on your system. This file can grow quite big.
Note: a remote file system, such as NFS, cannot be used here.
_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
I think it looks different here
http://dl.dropbox.com/u/30489651/Schermafdruk-17.png http://dl.dropbox.com/u/30489651/Schermafdruk-18.png Rinus 2011/9/10 Mark Fraser <[hidden email]>
_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
On Saturday 10 Sep 2011 15:23:47 Rinus Bakker wrote: > I think it looks different here > http://dl.dropbox.com/u/30489651/Schermafdruk-17.png > http://dl.dropbox.com/u/30489651/Schermafdruk-18.png
No, mine looks like this: http://imagebin.org/171894
_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
It looks like some component has not been updated, could be either yours or mine, omly expertized people can tell.
Rinus 2011/9/10 Mark Fraser <[hidden email]>
_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
On Saturday 10 Sep 2011 15:51:40 Rinus Bakker wrote: > It looks like some component has not been updated, could be either yours or > mine, omly expertized people can tell. > Rinus
I've seen this on 2 computers one 32 bit the other 64 bit and both from Philip's PPA.
_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
In reply to this post by Philip Johnsson
2011/9/10 Philip Johnsson <[hidden email]>:
> This happened to me too when I started Digikam 2.1 for the first time > but never happened after that first time. Don't know why. > > /Philip > Happend for me to / Jonas _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
In reply to this post by Mark Fraser
I have a fresh install of Philip dk 2.0.0. This looked like mine settingsscreen, just upgraded to 2.1.0. I get the same db error, but can not launch digikam, it crashes in launch proces
Rinus
2011/9/10 Mark Fraser <[hidden email]>
_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
|
|
Hi there,
Am 10.09.2011 16:47, schrieb Rinus Bakker: > I have a fresh install of Philip dk 2.0.0. This looked like mine > settingsscreen, just upgraded to 2.1.0. I get the same db error, but can not > launch digikam, it crashes in launch proces > Rinus > Dito here. bash gives following: digikam(8968)/digikam (core): Error while opening the database. Error details [ QSqlError(-1, "Fehler beim Öffnen der Datenbank", "unable to open database file") ] [... repeated few times] QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in use, all queries will cease to work. QSqlDatabase: driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL3 QMYSQL QSqlDatabase: driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL3 QMYSQL QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-32665712' is still in use, all queries will cease to work. QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-32665712', old connection removed. QSqlQuery::prepare: database not open [... repeated lots of times] QFileSystemWatcher: failed to add paths: /home/spheniscid/.config/ibus/bus digikam: symbol lookup error: digikam: undefined symbol: _ZN11KExiv2Iface14AltLangStrEdit15setLinesVisibleEj Messing with the digikamrc didn't help. Guess time for a bug report tomorrow once I slept over it. > 2011/9/10 Mark Fraser<[hidden email]> > >> ** >> >> On Saturday 10 Sep 2011 15:51:40 Rinus Bakker wrote: >> >>> It looks like some component has not been updated, could be either yours >> or >> >>> mine, omly expertized people can tell. >> >>> Rinus >> >> >> >> I've seen this on 2 computers one 32 bit the other 64 bit and both from >> Philip's PPA. >> >> >> >> _______________________________________________ >> Digikam-users mailing list >> [hidden email] >> https://mail.kde.org/mailman/listinfo/digikam-users >> >> > > > > _______________________________________________ > Digikam-users mailing list > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users -- Andreas Ege 24 The Birches Shobdon Herefordshire HR6 9NG GB Mobile: +44.(0)7526.315292 Tel.: +44.(0)1568.709166 http://spheniscid.net _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
In reply to this post by Rinus Bakker
2011/9/10 Rinus Bakker <[hidden email]>
I was thinking about Marcel of cource
_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
In reply to this post by Mark Fraser
2011/9/10 Mark Fraser <[hidden email]> I tried on a computer where I compiled DigiKam myself and that shows it as per Rinus's images. Could this be a build problem with Philip's PPA?
_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
In reply to this post by Rinus Bakker
On Saturday 10 Sep 2011 15:51:40 Rinus Bakker wrote: > It looks like some component has not been updated, could be either yours or > mine, omly expertized people can tell. > Rinus
Had a look in digikamrc and found this: [Database Settings] Database Connectoptions= Database Hostname= Database Name=/home/mfraser/.kde/share/apps/digikam/ Database Name Thumbnails=/home/mfraser/.kde/share/apps/digikam/ Database Password= Database Port=-1 Database Type=QSQLITE Database Username= Images Connectoptions= Images Hostname= Images Name=/home/mfraser/.kde/share/apps/digikam/ Images Password= Images Port=-1 Images Type=QSQLITE Images Username= Internal Database Server=false Thumbnails Connectoptions= Thumbnails Hostname= Thumbnails Name=/home/mfraser/.kde/share/apps/digikam/digikam4.db Thumbnails Password= Thumbnails Port=-1 Thumbnails Type=QSQLITE Thumbnails Username=
So, is one of those locations for the images database and the other for thumbnails?
_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
In reply to this post by Mark Fraser
Hi Mark,
Thanks for doing so. I planned to trie it myself, no need to now. I send Philip and Gilles a message. I think they are the ones to sort it out. We have to wait for actions been taken. btw. I suppose your self build version start the first time without the db issue? Might be a good idea to others to wait a bit before installing 2.1.0. Rinus 2011/9/11 Mark Fraser <[hidden email]>
_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
In reply to this post by Mark Fraser
2011/9/11 Mark Fraser <[hidden email]>
No, one is for the db storing tags etc, the other for thumbnails. The location for the photoś is not stored in the rc but in the db. Rinus
_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
In reply to this post by Rinus Bakker
About binary packaging, i cannot help more to guide where is the
dysfunction. I don't package, i develop source code. All dysfunction traces that i see in ML, bugzilla, or facebook group are relevant of a broken binary compatibility with libkexiv2. This lib must be recompiled and installed. digiKam must be recompiled against this lib. To be sure, check in Help/Components info dialog after recompilation and installation. The last version of libkexiv2 must be used by digiKam. If it's not the case, multiple instance of lib exist on your computer and cmake don't use the most recent version (or something like that) Note :I don't use ubuntu like distro, i'm working on Mageia, and i recompile all digiKam é co myself. I never use pre-compiled package. Best Gilles Caulier 2011/9/11 Rinus Bakker <[hidden email]>: > Hi Mark, > > Thanks for doing so. I planned to trie it myself, no need to now. > I send Philip and Gilles a message. I think they are the ones to sort it > out. We have to wait for actions been taken. > > btw. I suppose your self build version start the first time without the db > issue? > > Might be a good idea to others to wait a bit before installing 2.1.0. > > Rinus > > 2011/9/11 Mark Fraser <[hidden email]> >> >> 2011/9/10 Mark Fraser <[hidden email]> >>> >>> On Saturday 10 Sep 2011 15:23:47 Rinus Bakker wrote: >>> >>> > I think it looks different here >>> >>> > http://dl.dropbox.com/u/30489651/Schermafdruk-17.png >>> >>> > http://dl.dropbox.com/u/30489651/Schermafdruk-18.png >>> >>> >>> >>> No, mine looks like this: >>> >>> http://imagebin.org/171894 >>> >>> >> >> I tried on a computer where I compiled DigiKam myself and that shows it as >> per Rinus's images. Could this be a build problem with Philip's PPA? >> >> _______________________________________________ >> Digikam-users mailing list >> [hidden email] >> https://mail.kde.org/mailman/listinfo/digikam-users >> > > > _______________________________________________ > Digikam-users mailing list > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users > > Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
Thanks, clear enough!
Just hope Philip reads here before more people run into this. Rinus 2011/9/11 Gilles Caulier <[hidden email]> About binary packaging, i cannot help more to guide where is the _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: digiKam 2.1 and database errors
|
|
In reply to this post by Gilles Caulier-4
On Sunday 11 Sep 2011 10:46:16 Gilles Caulier wrote: > About binary packaging, i cannot help more to guide where is the > dysfunction. I don't package, i develop source code. > > All dysfunction traces that i see in ML, bugzilla, or facebook group > are relevant of a broken binary compatibility with libkexiv2. This lib > must be recompiled and installed. digiKam must be recompiled against > this lib. > > To be sure, check in Help/Components info dialog after recompilation > and installation. The last version of libkexiv2 must be used by > digiKam. If it's not the case, multiple instance of lib exist on your > computer and cmake don't use the most recent version (or something > like that)
Both the PPA and self compiled versions are using libexiv2 0.21.1. Only lib that has an older version in the PPA one is libOpenCV - 2.3.1 instead of 2.1.0. _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
| Free forum by Nabble | Edit this page |