[Bug 226853] New: No images shown after upgrading from previous version image database

classic Classic list List threaded Threaded
21 messages Options
12
Reply | Threaded
Open this post in threaded view
|

[Bug 226853] New: No images shown after upgrading from previous version image database

Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853

           Summary: No images shown after upgrading from previous version
                    image database
           Product: digikam
           Version: 1.1.0
          Platform: openSUSE RPMs
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
        AssignedTo: [hidden email]
        ReportedBy: [hidden email]


Version:           1.1.0 (using KDE 4.4.0)
Compiler:          gcc
OS:                Linux (i686) release 2.6.25.20-0.5-pae
Installed from:    openSUSE RPMs

After updating digikam from version 0.9.3, to 1.1.0 and launching the
application the welcome wizard appears asking for album and database file
locations.

Both were kept previously at the same location on a mounted NFS4 share with
properly set-up file locking (lockd) so the SQLite engine ran flawlessly with
version 0.9.3. (took me a few days to get it working trying it with NFS3 in
unsuccessfully). I tried all the below on a local drive as well just to make
sure and the same thing happens.

After entering the locations the wizard recognized the previous database file
and asked to choose between upgrading it or creating a new DB. As I had lots of
tags/ratings I decided to go for the upgrade. It started crunching the files,
it was 60+ GB so it took a while but finished successfully.

After the upgrade I could not see any images in the browser window.

The followings work properly:
- all albums were shown properly
- Creating/deleting new albums works properly
- all my old tags were imported properly
- all import/export functions, bulk tools saw all images, the OpenGL image
viewer displayed the slideshow properly

The following does not work:
- None of the original images are shown in the browser window
- Selecting "Scan for new images" scans all the images but still nothing is
shown
- Making a change on the file system (renaming an album folder) and then "Scan
for new images" scans all the images and properly detects the change in the
album structure but no images are shown
- Selecting "Rebuild Thumbnails" starts rebuilding thumbnails but after
completing still no images/thumbnails are shown

The following scenario I carried over might help to tackle the issue:
- Creating a new album named Test - success
- Importing an image file from a memory card a.jpg works and the newly imported
image's thumbnail shows properly. All image related functions work properly
(tried: editing, saving, emailing, assigning tags, modifying EXIF data)
- mv a.jpg b.jpg - digikam detects the change and the image is displayed
correctly
- cp b.jpg c.jpg - digikam detects the change and both images are displayed
correctly
- cp ../Existing_album/existing_file.jpg ./d.jpg - the new image d.jpg is not
shown (../Existing_album/existing_file.jpg was in the old DB so subject to the
upgrade process)
- mv d.jpg e.jpg - nothing changes only b.jpg and c.jpg are displayed (same
image)
- mv e.jpg c.jpg - whoops, digikam detects the change and the second thumbnail
is replaced with the new content
- cd ../Existing_album
- touch * - nothing happens, still no images are displayed


This is where I stopped. Somewhere the watching algorithm for directory content
changes an the DB upgrade output mess up with each other I suspect, knowing
virtually nothing of digikam internals.

--
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 226853] No images shown after upgrading from previous version image database

Bugzilla from Klaus.Weidenbach@gmx.net
https://bugs.kde.org/show_bug.cgi?id=226853


Klaus Weidenbach <[hidden email]> changed:

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




--- Comment #1 from Klaus Weidenbach <Klaus Weidenbach gmx net>  2010-02-14 18:36:08 ---
This sounds exactly like the problem I posted yesterday in digikam-devel. I can
confirm this. I use KDE 4.3.4 and upgrading from digiKam 0.9.6.

I can add these observations to the ones already in the report:
Calender view only shows the numbers of video and sound files in parentheses
and I can see these videos items there only, no pictures. The same for Timeline
view. Tags view shows the correct numbers of all items in parentheses, but I
just see videos. If I go to Searches and search for something I see the
pictures that fit to my search!

--
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 226853] No images shown after upgrading from previous version image database

Bugzilla from kretebe@freemail.hu
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|general                     |Database




--- Comment #2 from doma <kretebe freemail hu>  2010-02-14 18:41:59 ---
I can confirm Klaus' observations it is the same with me, videos show
correctly, with proper thumbnails.

--- Comment #3 from Gilles Caulier <caulier gilles gmail com>  2010-02-14 18:42:01 ---
Marcel,

KIOSlave or Database relevant ?

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 226853] No images shown after upgrading from previous version image database

Gilles Caulier-4
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|general                     |Database




--- Comment #2 from doma <kretebe freemail hu>  2010-02-14 18:41:59 ---
I can confirm Klaus' observations it is the same with me, videos show
correctly, with proper thumbnails.

--- Comment #3 from Gilles Caulier <caulier gilles gmail com>  2010-02-14 18:42:01 ---
Marcel,

KIOSlave or Database relevant ?

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 226853] No images shown after upgrading from previous version image database

Bugzilla from kretebe@freemail.hu
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853





--- Comment #4 from doma <kretebe freemail hu>  2010-02-14 18:45:39 ---
When choosing "Create new Database" (this is how I use it for now) digikam does
a full rebuild from scratch - everything works properly.

This tells to me that nor KIOSlave neither Database is likely to be of any
relevance. This must be something to to with the upgrade itself.

--
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 226853] No images shown after upgrading from previous version image database

Marcel Wiesweg
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853


Marcel Wiesweg <[hidden email]> changed:

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




--- Comment #5 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-02-14 22:45:58 ---
Gilles, it's not the ioslaves, because new pictures are displayed. Klaus will
send me his database. Currently I dont know what's wrong here.

--
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 226853] No images shown after upgrading from previous version image database

Marcel Wiesweg
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853





--- Comment #6 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-02-15 19:42:22 ---
Ok, this is an interaction between a change in the ImageScanner (to not
overwrite the rating on rescan) and the schema update. Noone has tested schema
update recently.

The only problem is that there is no entry in the ImageInformations table. The
ImageScanner now uses UPDATE instead of REPLACE.

It is almost fortunate that anyone hit by this bug will notice instantly ;-)

--
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 226853] No images shown after upgrading from previous version image database

Marcel Wiesweg
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853





--- Comment #7 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-02-15 21:05:38 ---
SVN commit 1090694 by mwiesweg:

For now just add the ImageInformation entry when schema upgrading.

A better solution (update or insert) in the Image scanner leads to
the SQL "upsert" problem, for which I found no good solution for SQLite.

CCBUG: 226853

 M  +9 -0      schemaupdater.cpp  


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

--
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 226853] No images shown after upgrading from previous version image database

Marcel Wiesweg
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853





--- Comment #8 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-02-15 21:06:20 ---
Klaus or doma, can you test current SVN? Remove your digikam4.db and
re-upgrade. I hope it works then.

--
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 226853] No images shown after upgrading from previous version image database

Bugzilla from kretebe@freemail.hu
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853





--- Comment #9 from doma <kretebe freemail hu>  2010-02-15 23:16:08 ---
Am checking it out from SVN, takes a decent while.

I may not have a proper build environment but will give it a try.

In the meanwhile are you basically saying that a

"REPLACE INTO ImageInformation (imageId) SELECT id FROM Images;"

query will do the trick after the conversation as a quick workaround?

--
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 226853] No images shown after upgrading from previous version image database

Bugzilla from Klaus.Weidenbach@gmx.net
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853





--- Comment #10 from Klaus Weidenbach <Klaus Weidenbach gmx net>  2010-02-15 23:39:55 ---
I couldn't test SVN yet. Have to prepare some things first. But I patched 1.1.0
sources and it is not working there: "The schema updating process from version
4 to 5 failed, caused by an error that we did not expect...."
But the SVN file also looks bit different, so I will try with SVN next, but I
don't think I can do it before next weekend.

--
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 226853] No images shown after upgrading from previous version image database

Bugzilla from kretebe@freemail.hu
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853





--- Comment #11 from doma <kretebe freemail hu>  2010-02-16 00:23:07 ---
Did the conversion again.

Then executed:

REPLACE INTO ImageInformation (imageId) SELECT id FROM Images;

Now it works flawlessly thanks.

Compiling from source is beyond my possibilities now.

Thanks again.

--
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 226853] No images shown after upgrading from previous version image database

Marcel Wiesweg
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853





--- Comment #12 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-02-16 18:22:21 ---
Doma, you will probably not have got your ratings and comments from the old db
now (the statement need to be executed at a certain point during the conversion
process)

--
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 226853] No images shown after upgrading from previous version image database

Marcel Wiesweg
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853





--- Comment #13 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-02-16 18:30:28 ---
SVN commit 1091099 by mwiesweg:

Hope this works now.

CCBUG: 226853

 M  +1 -5      schemaupdater.cpp  


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

--
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 226853] No images shown after upgrading from previous version image database

Marcel Wiesweg
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853





--- Comment #14 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-02-16 18:31:19 ---
Klaus: patching 1.1.0 is sufficient. Please try with this corrected patch.

--
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 226853] No images shown after upgrading from previous version image database

Bugzilla from Klaus.Weidenbach@gmx.net
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853





--- Comment #15 from Klaus Weidenbach <Klaus Weidenbach gmx net>  2010-02-16 22:51:03 ---
The new patch against 1.1.0 seems to work. The import was successful and I can
see now all pictures in all views. Tags and ratings seem to be there, too.
As far as I can see this bug is fixed. Thank you very much!

--
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 226853] No images shown after upgrading from previous version image database

Gilles Caulier-4
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |[hidden email]
         Resolution|                            |FIXED




--
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 226853] No images shown after upgrading from previous version image database

Bugzilla from kretebe@freemail.hu
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853





--- Comment #16 from doma <kretebe freemail hu>  2010-02-17 13:56:05 ---
I backed up the tables changed after my initial conversion, chechked out from
SVN, compiled and did the conversion again. I can confirm it works for all
items. Thanks.

--
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 226853] No images shown after upgrading from previous version image database

Marcel Wiesweg
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853


Marcel Wiesweg <[hidden email]> changed:

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




--- Comment #17 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-03-15 20:50:01 ---
*** Bug 230606 has been marked as a duplicate of 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
Reply | Threaded
Open this post in threaded view
|

[Bug 226853] No images shown after upgrading from previous version image database

Gilles Caulier-4
In reply to this post by Bugzilla from kretebe@freemail.hu
https://bugs.kde.org/show_bug.cgi?id=226853

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Version Fixed In|                            |1.2.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
12