digiKam 2.1 and database errors

[Mark Fraser]

On Sunday 11 Sep 2011 10:36:37 Rinus Bakker wrote:

> 2011/9/11 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

> >

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

>

> 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

 

In the one I compiled on Kubuntu Oneiric digikamrc only has:

 

[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=

Internal Database Server=false

 

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[davidvj]

CONTENTS DELETED

The author has deleted this message.

[Rinus Bakker]

You mean that it ran fine while it created it''s own new db, but failed where it was confronted with the existing one?

2011/9/11 davidvj <[hidden email]>

I did a fresh install on a clean computer and all went smoothly but when I
did a re-install on my main system it failed to start following the db error
message.

I tried renaming the db files and deleted the old menu item so as to avoid
any confusion but DK on my system is now dead.

Frustrating!

I think it will solve over time or else, assumed that you still have a db (copy) around that is intact you can download here digikam 2.0.

                                            http://sourceforge.net/projects/digikam/files/digikam/2.0.0/digikam-2.0.0.tar.bz2/download           
to be build by yourself and all will be back to normal.

Rinus

David

--
View this message in context: http://digikam.1695700.n4.nabble.com/digiKam-2-1-and-database-errors-tp3803538p3805591.html
Sent from the digikam-users mailing list archive at Nabble.com.

_______________________________________________
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

[Rinus Bakker]

Hi David,
BTW, maybe you did not read my message about that, In my case digkam tried to reconnect to the db and because of that was meant to be forever, I clicked cancel, at that point dk crashed.
But after a reinstall process, I rebooted the computer before starting digikam. After this it did not die at my cancelation but continued to start.
Hope that helps!
Best,
Rinus

2011/9/11 davidvj <[hidden email]>

I did a fresh install on a clean computer and all went smoothly but when I
did a re-install on my main system it failed to start following the db error
message.

I tried renaming the db files and deleted the old menu item so as to avoid
any confusion but DK on my system is now dead.

Frustrating!

David

--
View this message in context: http://digikam.1695700.n4.nabble.com/digiKam-2-1-and-database-errors-tp3803538p3805591.html
Sent from the digikam-users mailing list archive at Nabble.com.

_______________________________________________
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

[Rinus Bakker]

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?

I finaly got mine to run, it has exactly the same issues as Philips, and the settings view same as yours. Luckily I got my Ubunt in VM to run so notthing messed up.

Even though we are still nowhere, thank for trying to sort it out.

Best regards,
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

[davidvj]

CONTENTS DELETED

The author has deleted this message.

[Andreas K. Huettel]

Everyone,

there is a biggish problem with the 2.1 release in many distros and the
current source tarball on sourceforge. (FWIW, Gentoo is fixed by now.) The
details are at https://bugs.kde.org/show_bug.cgi?id=281767

People are working on it, and it will be fixed. Maybe postpone updating for a
few days if you still can.

Andreas
(not a digikam developer, but the Gentoo digikam maintainer)


On Montag 12 September 2011 01:14:59 David Vincent-Jones wrote:
> I have spent just too much time thrashing with 2.1 ... now reverted to
> the 1.9 repository version. Hopefully, with time, things will stabilize.
>
> David
>

--

Andreas K. Huettel
Gentoo Linux developer
[hidden email]
http://www.akhuettel.de/


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[davidvj]

CONTENTS DELETED

The author has deleted this message.

[Ignatius Reilly]

Hi,

I' still stuck...

Can anybody help me find the mysql upgrade scripts so that I can execute
them manually?

Cheers
Ignatius



Ignatius Reilly thus spake on 10/09/11 12:40:

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

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[AT Ege]

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
>
Same here.
If I use digikam --database-directory /home/spheniscid/bilder/ to point
it to the db, I manage half a start. It goes through checking the
collection, then crashes. :-P

bash output is following:
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is
still in use, all queries will cease to work.
QInotifyFileSystemWatcherEngine::addPaths: inotify_add_watch failed:
Datei oder Verzeichnis nicht gefunden
QFileSystemWatcher: failed to add paths: /home/spheniscid/.config/ibus/bus
digikam: symbol lookup error: digikam: undefined symbol:
_ZN11KExiv2Iface14AltLangStrEdit15setLinesVisibleEj

Looks like their is a "in use flag" set?

> 2011/9/10 Mark Fraser <[hidden email]
> <mailto:mfraz74%[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] <mailto:[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: [phone]
                 Tel.: [phone]
                 http://spheniscid.net
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users