[Bug 277242] New: After SQLite --> MySQL conversion, digikam reports error regarding DBThumbnailsVersion on start up.

[Francesco Riosa-2]

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





--- Comment #18 from Francesco Riosa <francesco+kde pnpitalia it>  2011-07-31 16:52:12 ---
(In reply to comment #17)
> Migration: splitted mysql database fixes

I've discovered with some surprise that the content of the thumbnail database
is not migrated at all from the procedure.

Now thinking at it may make sense, dump and reload of that heavy data is slow
and asking the user to re-generate the database could make sense, she/he/them
will also benefit from a clean database without thumbnails for deleted images.

RFC

should be migrate the data, or should be warn the user that re-building all the
thumbnails will be needed?

after the decision I'll fix and close definitely this bug

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


Sune Kloppenborg Jeppesen <[hidden email]> changed:

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




--- Comment #19 from Sune Kloppenborg Jeppesen <jaervosz gentoo org>  2011-07-31 19:55:46 ---
I guess regenerating my collection of 27k images over slow Wifi and NFS would
be substantially slower than just migrating the data in the database. OTOH it
would probably be less error prone to force a regeneration of the thumbnail 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

[Francesco Riosa-2]

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


Francesco Riosa <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever Confirmed|0                           |1




--- Comment #20 from Francesco Riosa <francesco+kde pnpitalia it>  2011-07-31 20:31:27 ---
(In reply to comment #19)
> I guess regenerating my collection of 27k images over slow Wifi and NFS would
> be substantially slower than just migrating the data in the database. OTOH it
> would probably be less error prone to force a regeneration of the thumbnail DB.

I guess there is a lot of people in this situation, if nothing else because the
need to a mysql database arise with big collections.

If your thumbnail db is empty, In the meantime could you test the following?

sqlite3 thumbnails-digikam.db .dump\
| sed -n -e 's:^INSERT INTO "\([^"]*\)":INSERT IGNORE INTO `\1`:p' \
| mysql -u"$digikam_user" -p"$digikam_pass" "$digikam_database"

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

[Francesco Riosa-2]

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





--- Comment #21 from Francesco Riosa <francesco+kde pnpitalia it>  2011-08-01 23:51:38 ---
Git commit d9afaa0084b2a35bd2baa2ab365a54cd4a19ab4c by Francesco Riosa.
Committed on 02/08/2011 at 01:37.
Pushed by riosa into branch 'sql/2.0'.

Split of settings/migration for images/thumbs DB

This is the first step in really managing the Image metadata database
and the Thumbnail cache database as different entities.

Only changes in the gui are included and as is the code is not
functional, still need to be done:

1) change the structure of digikamrc and it's migration
2) define interaction between widgets in the new migration dialog
3) port and possibly unify "Settings -> database migration" with
"Settings -> configure digikam -> database settings"
4) add a "Backup" button

CCBUG: 277242
GUI: some new strings, work in progress

M  +2    -2    digikam/utils/albumsettings.h
M  +141  -38   libs/dialogs/migrationdlg.cpp
M  +2    -2    utilities/setup/setupdatabase.cpp
M  +4    -4    libs/widgets/common/databasewidget.h
M  +3    -3    libs/database/databaseparameters.cpp
M  +4    -1    libs/dialogs/migrationdlg.h
M  +8    -8    digikam/utils/albumsettings.cpp
M  +38   -35   libs/widgets/common/databasewidget.cpp

http://commits.kde.org/digikam/d9afaa0084b2a35bd2baa2ab365a54cd4a19ab4c

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

[Francesco Riosa-2]

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


Francesco Riosa <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|After SQLite --> MySQL      |Using different databases
                   |conversion, digikam reports |for images metadata and
                   |error regarding             |thumbnail cache is broken
                   |DBThumbnailsVersion on      |
                   |start up.                   |




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

[Francesco Riosa-2]

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


Francesco Riosa <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Using different databases   |Using different MySQL
                   |for images metadata and     |databases for images
                   |thumbnail cache is broken   |metadata and thumbnail
                   |                            |cache is broken




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

[Francesco Riosa-2]

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





--- Comment #22 from Francesco Riosa <francesco+kde pnpitalia it>  2011-08-03 12:20:53 ---
here there is another one:

http://quickgit.kde.org/?p=digikam.git&a=commit&h=9fa4b617ec1b195b9f966bb8fc5f712d6bb0b515

Don't try this at home, is broken ATM

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

[Geoff King-4]

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


Geoff King <[hidden email]> changed:

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




--- Comment #23 from Geoff King <gsking1 gmail com>  2011-08-24 18:29:21 ---
hello,
I'm testing out digikam 2.0.0 using the fedora 15 kde-unstable packages and ran
into this problem.

Failed to initialize thumbnail  ..
Error Message: The database is not valid: the "DBThumbnailsVersion" setting
does not exist. The current database schema version cannot be verified. Try to
start with an empty database.

The error message was displayed, but the program appeared to operate okay.   I
also did get an error after initial load of images, but didn't write that down.
 This was with a new mysql database and not using the migration assistant.

Following the guidance above the following sql statements into mysql seem to
fix the problem.  

insert into digikamthumb.Settings(keyword,value)
VALUES('DBThumbnailsVersionRequired','1');
insert into digikamthumb.Settings(keyword,value)
VALUES('DBThumbnailsVersion','2');

Looks like you already have seen this, but thought I'd mention it anyway..

Geoff

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

[Francesco Riosa-2]

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





--- Comment #24 from Francesco Riosa <francesco+kde pnpitalia it>  2011-09-05 22:39:19 ---
Git commit 37f5f5d59f174bcedc86438365f9a7270a1bd677 by Francesco Riosa.
Committed on 06/09/2011 at 00:29.
Pushed by riosa into branch 'master'.

Split "images" and "thumbnails" databases.

This commit splits the configure options of the images and thumbnail
databases, will then be possible use different database servers.
Also the migration dialog is now more flexible.

GUI: migrationdlg.cpp databasewidget.cpp
CCBUG: 277242

M  +1    -1    databaseserver/databaseserver.cpp
M  +35   -22   digikam/album/albummanager.cpp
M  +6    -1    digikam/album/albummanager.h
M  +7    -7    digikam/database/databaseguierrorhandler.cpp
M  +1    -1    digikam/database/dbstatdlg.cpp
M  +18   -3    digikam/main/digikamapp.cpp
M  +110  -39   digikam/utils/albumsettings.cpp
M  +39   -18   digikam/utils/albumsettings.h
M  +1    -1    digikam/utils/componentsinfo.h
M  +3    -0    digikam/utils/config-digikam.h.cmake
M  +14   -14   libs/database/databasecorebackend.cpp
M  +1    -1    libs/database/databaseoperationgroup.cpp
M  +422  -200  libs/database/databaseparameters.cpp
M  +44   -30   libs/database/databaseparameters.h
M  +5    -5    libs/database/schemaupdater.cpp
M  +1    -1    libs/database/thumbnailschemaupdater.cpp
M  +2    -0    libs/dialogs/migrationdlg.cpp
M  +1    -0    libs/dialogs/migrationdlg.h
M  +363  -152  libs/widgets/common/databasewidget.cpp
M  +40   -19   libs/widgets/common/databasewidget.h
M  +2    -2    utilities/nepomuk/digikamnepomukservice.cpp
M  +65   -34   utilities/setup/setupdatabase.cpp

http://commits.kde.org/digikam/37f5f5d59f174bcedc86438365f9a7270a1bd677

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

[brad]

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





--- Comment #25 from brad <bkn ithryn net>  2011-10-04 00:53:07 ---
This bug appears to have been fixed (Thanks Francesco) as of code sync from Oct
3rd. if no one else objects i will close this bug as fixed in the coming days.

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

[Francesco Riosa-2]

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





--- Comment #26 from Francesco Riosa <francesco+kde pnpitalia it>  2011-10-04 08:15:41 ---
(In reply to comment #25)
> This bug appears to have been fixed (Thanks Francesco) as of code sync from Oct
> 3rd. if no one else objects i will close this bug as fixed in the coming days.

Hi, there are other changes needed to have all properly working, some of them
were considered not yet ready for release and reverted, so please leave this
bug open.
I've not yet an exact ETA for this bug, being rather under pressure at work,
but this is high in priority.

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


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Using different MySQL       |MYSQL : using different
                   |databases for images        |databases for images
                   |metadata and thumbnail      |metadata and thumbnail
                   |cache is broken             |cache is broken




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

[Sven Heithecker]

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

Sven Heithecker <[hidden email]> changed:

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

--- Comment #27 from Sven Heithecker <[hidden email]> ---
Hi,
I am running Digikam 2.5.0, with the same DB schemata for Thumbnails and
Images. I also ran into this bug ... I dont know whether it should have been
fixed already.
BTW even though I have a couple of thousands images at stage, the Thumbnails
table is empty...

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|MYSQL : using different     |MySQL : using different
                   |databases for images        |databases for images
                   |metadata and thumbnail      |metadata and thumbnail
                   |cache is broken             |cache is broken

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|MySQL : using different     |MYSQL : using different
                   |databases for images        |databases for images
                   |metadata and thumbnail      |metadata and thumbnail
                   |cache is broken             |cache is broken

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

--- Comment #28 from Gilles Caulier <[hidden email]> ---
New digiKam 4.11.0 is available with official PKG installer for OSX.

https://www.digikam.org/node/740

Can you reproduce the problem with this release ?

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

[brad]

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

brad <[hidden email]> changed:

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

--- Comment #29 from brad <[hidden email]> ---
On my installation the thumbnails databases populated is functioning correctly.

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Version Fixed In|                            |4.12.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=277242

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Platform|Compiled Sources            |MacPorts Packages

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

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Database                    |Database-Mysql

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