Re: Thumbnail creation and updating of thumbnail database, etc.

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

Re: Thumbnail creation and updating of thumbnail database, etc.

Mark Hayes (Hotmail)


Remco,

Apologies for the delay.

I'm currently using the following:

Kubuntu 11.10
Linux kubuntu64 3.0.0-16-generic #28-Ubuntu SMP Fri Jan 27 17:44:39 UTC
2012 x86_64 x86_64 x86_64 GNU/Linux
KDE version 4.7.4
digikam v 2.1.1 (standard stock install from Kubuntu repositories)

I have updated some packages over the last week - but I'm not sure if
any are related to digikam.  In fact, I couldn't tell you what they
were.  Do you know how to check for the most recently installed packages
by date?  I could then list them out for you.

I did suffer a possible power failure over the weekend whilst I was away
- I don't really know other than I came back to the house on Sunday and
the PC had rebooted, so something definitely went wrong.  Digikam was
open at the time of the crash - maybe that corrupted the database?

No new disks installed/used.  No changes to Digikam made as far as I know.

How can I tell you what external libraries are installed?  Apologies -
but my knowledge is limited there.  If you can supply a command to run,
I can easily post you a list of them.

Sorry that I can't supply more information - but if you can let me know
any commands to run for you - will get right back to you as soon as I can.

Thanks.

Mark.




On 27/02/12 23:30, [hidden email] wrote:

> Send Digikam-users mailing list submissions to
> [hidden email]
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://mail.kde.org/mailman/listinfo/digikam-users
> or, via email, send a message with subject or body 'help' to
> [hidden email]
>
> You can reach the person managing the list at
> [hidden email]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Digikam-users digest..."
>
>
> Today's Topics:
>
>    1. An error occurred during tag creation (Mark Hayes (Hotmail))
>    2. Thumbnail creation and updating of thumbnail database etc.
>       (Mark Hayes (Hotmail))
>    3. Re: Thumbnail creation and updating of thumbnail database
>       etc. (Remco Vi?tor)
>    4. Confused about meta-data templates (Mark Hayes (Hotmail))
>    5. Re: Confused about meta-data templates (Guy Stalnaker)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 27 Feb 2012 21:01:04 +0800
> From: "Mark Hayes (Hotmail)" <[hidden email]>
> To: digiKam - Home Manage your photographs as a professional with the
> power of open source <[hidden email]>
> Subject: [Digikam-users] An error occurred during tag creation
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1
>
>
>
>
> Hi,
>
> I've been having some problems recently, trying to get Digikam set up
> correctly for me...
>
> Over the last two days, I've been having problems adding tags.  A couple
> of days ago, all the thumbnails disappeared, and along with it, a few of
> the tags I'd had in previously.
>
> So I'm trying to add tags back in - but it fails every time.  Here is
> what I've tried:
>
> 1.  Right click on a tag in the tag hierarchy that I have, and choose
> "New Tag"
> 2.  Input a name for my new tag - Asia, press enter or click OK.
>
> The error I get is a small window with the title "Tag creation error -
> digikam"
> The error says, "An error occurred during tag creation:"
> Then it shows the tag path that it was trying to create (shown
> correctly) and an error message next to it that just says, "Failed to
> add tag to database".  However, it doesn't tell me what to do about it -
> or why it failed.
>
> I've also tried using Tag > New... from the menu system - same result.
>
> Why is it that I can no longer create tags?  I mean, I have already
> created some tags - but don't seem to be able to create any more.
>
> Any help is greatly appreciated.
>
> Thanks,
>
> Mark.
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 27 Feb 2012 21:13:30 +0800
> From: "Mark Hayes (Hotmail)" <[hidden email]>
> To: digiKam - Home Manage your photographs as a professional with the
> power of open source <[hidden email]>
> Subject: [Digikam-users] Thumbnail creation and updating of thumbnail
> database etc.
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi,
>
> A couple of days ago, all the thumbnails (and I mean ALL!) disappeared,
> and along with it, a few of the tags I'd had in previously.
>
> So I'm trying to get the thumbnails back - but it seems to not be an
> easy thing to do.
>
> If I right-click on a folder, and choose to rebuild the thumbnails - it
> hangs, takes an awfully long time - and I cannot use Digikam in the
> meantime.  Yesterday, I tried to rebuild the thumbs in a folder with
> three pictures in it.  The first two times, I had to abandon it - and
> abort the process.  Digikam hung, showing 0% completion, and I had to
> agree to kill the process when KDE asked me...  (about 10 minutes later).
>
> I tried again, and left it running overnight - but it still hadn't
> finished when I came back from work tonight (some 20 hours later!)
>
> Somehow now - I have two folders of thumbnails back - with about a total
> of 150 thumbnails.  However, this is not quick, and a real PITA.  Not to
> mention that it seems to need doing for each and every folder (and I
> have a lot).  I still don't know if I'm doing this correctly, and I'm
> sure that I really don't know how or what it going on! :-)
>
> I'm trying again right now - and it's been running over 20 mins for
> rebuilding 48 thumbnails - and still showing 0% complete.  Clicking on
> Abort (the only option) gets me nothing at all.  CPU usage is static at
> 25% - but it really doesn't seem to be doing anything at all...
>
> Please can someone explain to me:
>
> 1.  Why is it taking so long?  Should it?  Am I doing something wrong?
> 2.  How do I properly rebuild my thumbnails?
> 3.  Is there a way to rebuild missing thumbnails from the whole database
> overnight whilst I sleep?  Or do I really need to do this one by one...?
>
> And any other pointers that you might think useful about rebuilding the
> database.
>
> Many thanks,
>
> Mark.
>
>
>
> ------------------------------
>
> Message: 3
> Date: Mon, 27 Feb 2012 15:16:19 +0100
> From: Remco Vi?tor <[hidden email]>
> To: [hidden email]
> Subject: Re: [Digikam-users] Thumbnail creation and updating of
> thumbnail database etc.
> Message-ID: <1729979.XocCYP9Np8@manticore>
> Content-Type: text/plain; charset="us-ascii"
>
> On Monday 27 February 2012 21:13:30 Mark Hayes wrote:
>> Hi,
>>
>> A couple of days ago, all the thumbnails (and I mean ALL!) disappeared,
>> and along with it, a few of the tags I'd had in previously.
> <snipped a lot of text about failed attempts to get them back>
>
> So, first thing would be to think of what would have changed a couple of days
> ago, just before your problems with the thumbnails and tags started.
>
> Some things to check: upgrades (libraries, kernel, ...), new disk, changes in
> Digikam or its settings... Note that those are just a few possiblities.
> Also, it would help if you stated the versions of Digikam, operating system,
> KDE (and perhaps the most important external libraries).
>
> Don't hesitate to give too many details, too few is making life more difficult
> for those trying to figure out the cause of the problem.
>
> Remco
>
>
> ------------------------------
>
> Message: 4
> Date: Mon, 27 Feb 2012 22:40:46 +0800
> From: "Mark Hayes (Hotmail)" <[hidden email]>
> To: digiKam - Home Manage your photographs as a professional with the
> power of open source <[hidden email]>
> Subject: [Digikam-users] Confused about meta-data templates
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi all,
>
> I'm experimenting with Digikam's meta-data templates as a way of
> inputting a lot of metadata early on in my workflow.  I've not played
> with it before, but the whole idea seems fairly intuitive so I presumed
> that I would be able to sort it out fairly easily.  Nevertheless, I'm
> struggling with it - quite a lot really, so wanted to quiz people on how
> they used templates.
>
> Firstly, I usually import pictures with Rapid Photo Downloader.  I find
> it fast, excellent, easy to use, and able to rename and sort according
> to my preferences on import, along with making a simultaneous backup.
> For some reason, I have struggled to do the same with Digikam, in
> particular using the regex renamer - which must make perfect sense to
> coders, but is complete gobbledegook to myself.  The regex renamer seems
> to struggle to remove parts of a filename for me - even when I follow
> the very simple instructions on the Digikam blog etc.  Ho hum...
>
> I hit on a bunch of problems - so I'll try and break them down a little
> to make it more manageable.  Any help you can give on any of these items
> is most welcome.
>
> Firstly, setting up a template.  From a UI point of view, I struggled
> initially.  The 'Add' button didn't seem to open up a dialogue box to
> fill in data - which is what I had expected it to do.  You had to fill
> out the data, including a name for the template, before pressing Add to
> add it into the list of available templates.  This seems a little
> counter-intuitive to me (anyone else too?) and although I eventually
> worked it out, being a little quirky just seemed to make it a little
> more of an effort.
>
> In addition, I had imagined that a template would be a generally minimum
> set of basic "boilerplate" info that you then added to - but how to add
> the additional information seems harder than it should be.  I had
> thought that you would leave a bunch of fields blank - such as location
> and then update them later, when applying the template to the photos.
> But when I came to update/apply the template later, I hit on other
> problems related to that.
>
> Anyway, the Digikam manual/help-file states that templates can be
> applied at downloading.  Since I don't use Digikam to download, this
> means that I need to apply the template later.  It took me a while to
> find out how.  I had tried selecting photos and then editing metadata
> but this doesn't seem to be the right way.  I also looked long and hard
> at the metadata tab on the right hand panel.  In the end, I had to
> Google it and then surf to the Scribbles and Snaps blog to find out how
> to apply it.  Apparently, metadata templates are applied under
> "Captions/Tags" panel and then choosing the "Information" tab on the
> right hand panel.
>
> I realise that Digikam is a hugely complicated program with a lot to it
> - but I really am struggling to understand why template application
> would appear there - and not in and around the metadata tab.  Is there a
> reason behind that?  What is the main notional separation between photo
> metadata and my/your metadata templates that is being applied here?  Why
> would they seem so far apart and stuck in such very different locations?
>
> Anyway, so now I found it - but then I came across another problem.
> When applying a template, you are not able to adjust any data before
> application.  I would have assumed that I could select pictures, select
> a template to base my data on, and then make any adjustments necessary
> (such as a change of location and country, subject matter etc etc) and
> then apply the template with the adjusted data.  But I don't seem to be
> able to do that.  I am not able to change any data or add any more data
> to the basic template before application.  And now that I have 362
> images with the wrong country data (picked up from the template), I am
> unsure as to how I can update/change that.
>
> I must be pressing all the wrong buttons because I can't seem to do
> that.  Please let me know:  what am I doing wrong?
>
> Finally, I am now trying to adjust the 'country' metadata that I have
> now incorrectly embedded in the files.  I have a bunch of photos showing
> that they were took in one country, when in fact they were taken
> elsewhere on holiday.  So I select all the files again, choose Image >
> Metadata > Edit all metadata and I'm presented with a pop-up box with
> loads of metadata options.  The interesting thing about this dialog is
> that it seems to be for changing only one file at a time - starting with
> file number 1 of 362 in this folder, and not a 'template' system that
> allows me to change all of the files en-masse.
>
> Anyway, with my first file being a CR2, I'm not able to edit the
> metadata.  I'm able to choose from the three tabs across the top - Edit
> EXIF, Edit IPTC or Edit XMP - but not able to choose any of the tabs
> down the left hand side of that box to edit them.  Fair enough, given
> that it's a CR2 file, but then if I click on 'Next' to go to the JPG
> version of the same file (in the hopes of changing that metadata), the
> system hangs and I am not able to advance to the second picture.  I am
> unable to Close the box, either by clicking on Close or on the X at the
> top of the window...  Dialogue buttons show no reaction to clicking, but
> clicking on the X seems to bring up a KWin warning about non response
> and asking me if I want to terminate the application and its child
> windows with the loss of all unsaved data.  Humph!!!
>
> It's very repeatable - and I've done it about 10 times tonight trying to
> find out how to get all this to work.  I'm on Kubuntu 11.10 using
> version 2.1.1 of Digikam on KDE 4.7.4
>
> I'm starting to get concerned that I'm pressing all the wrong buttons
> etc.  Thousands of people use Digikam without all the problems that I
> seem to get - and I have been trying on and off to use Digikam for four
> years... but still struggle to get it up and running.  I give up
> frequently but come back just as often because I know that it's great
> software that many people use effortlessly.  So what am I doing wrong????!!!
>
> Grateful if anyone can shed some light on this for me.  It really
> shouldn't seem this hard for me - and yet, honestly (!! :-) ) I am not
> _that_ stupid all of the time...!
>
> Thanks,
>
> Mark.
>
>
> ------------------------------
>
> Message: 5
> Date: Mon, 27 Feb 2012 09:30:27 -0600
> From: Guy Stalnaker <[hidden email]>
> To: "[hidden email]" <[hidden email]>,
> digiKam - Home Manage your photographsas a professional with the power
> of open source <[hidden email]>
> Subject: Re: [Digikam-users] Confused about meta-data templates
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=us-ascii
>
> I too am interested in the answers to these questions. I had given up on using templates completely because the documentation does not adequately describe their use and application ( it is actually incorrect, indicating a preference pane that no longer exists). My own query to this list went unanswered.
>
> Guy Stalnaker
> [hidden email]
> [hidden email]
>
> On Feb 27, 2012, at 8:40 AM, "Mark Hayes (Hotmail)" <[hidden email]> wrote:
>
>> Hi all,
>>
>> I'm experimenting with Digikam's meta-data templates as a way of
>> inputting a lot of metadata early on in my workflow.  I've not played
>> with it before, but the whole idea seems fairly intuitive so I presumed
>> that I would be able to sort it out fairly easily.  Nevertheless, I'm
>> struggling with it - quite a lot really, so wanted to quiz people on how
>> they used templates.
>>
>> Firstly, I usually import pictures with Rapid Photo Downloader.  I find
>> it fast, excellent, easy to use, and able to rename and sort according
>> to my preferences on import, along with making a simultaneous backup.
>> For some reason, I have struggled to do the same with Digikam, in
>> particular using the regex renamer - which must make perfect sense to
>> coders, but is complete gobbledegook to myself.  The regex renamer seems
>> to struggle to remove parts of a filename for me - even when I follow
>> the very simple instructions on the Digikam blog etc.  Ho hum...
>>
>> I hit on a bunch of problems - so I'll try and break them down a little
>> to make it more manageable.  Any help you can give on any of these items
>> is most welcome.
>>
>> Firstly, setting up a template.  From a UI point of view, I struggled
>> initially.  The 'Add' button didn't seem to open up a dialogue box to
>> fill in data - which is what I had expected it to do.  You had to fill
>> out the data, including a name for the template, before pressing Add to
>> add it into the list of available templates.  This seems a little
>> counter-intuitive to me (anyone else too?) and although I eventually
>> worked it out, being a little quirky just seemed to make it a little
>> more of an effort.
>>
>> In addition, I had imagined that a template would be a generally minimum
>> set of basic "boilerplate" info that you then added to - but how to add
>> the additional information seems harder than it should be.  I had
>> thought that you would leave a bunch of fields blank - such as location
>> and then update them later, when applying the template to the photos.
>> But when I came to update/apply the template later, I hit on other
>> problems related to that.
>>
>> Anyway, the Digikam manual/help-file states that templates can be
>> applied at downloading.  Since I don't use Digikam to download, this
>> means that I need to apply the template later.  It took me a while to
>> find out how.  I had tried selecting photos and then editing metadata
>> but this doesn't seem to be the right way.  I also looked long and hard
>> at the metadata tab on the right hand panel.  In the end, I had to
>> Google it and then surf to the Scribbles and Snaps blog to find out how
>> to apply it.  Apparently, metadata templates are applied under
>> "Captions/Tags" panel and then choosing the "Information" tab on the
>> right hand panel.
>>
>> I realise that Digikam is a hugely complicated program with a lot to it
>> - but I really am struggling to understand why template application
>> would appear there - and not in and around the metadata tab.  Is there a
>> reason behind that?  What is the main notional separation between photo
>> metadata and my/your metadata templates that is being applied here?  Why
>> would they seem so far apart and stuck in such very different locations?
>>
>> Anyway, so now I found it - but then I came across another problem.
>> When applying a template, you are not able to adjust any data before
>> application.  I would have assumed that I could select pictures, select
>> a template to base my data on, and then make any adjustments necessary
>> (such as a change of location and country, subject matter etc etc) and
>> then apply the template with the adjusted data.  But I don't seem to be
>> able to do that.  I am not able to change any data or add any more data
>> to the basic template before application.  And now that I have 362
>> images with the wrong country data (picked up from the template), I am
>> unsure as to how I can update/change that.
>>
>> I must be pressing all the wrong buttons because I can't seem to do
>> that.  Please let me know:  what am I doing wrong?
>>
>> Finally, I am now trying to adjust the 'country' metadata that I have
>> now incorrectly embedded in the files.  I have a bunch of photos showing
>> that they were took in one country, when in fact they were taken
>> elsewhere on holiday.  So I select all the files again, choose Image >
>> Metadata > Edit all metadata and I'm presented with a pop-up box with
>> loads of metadata options.  The interesting thing about this dialog is
>> that it seems to be for changing only one file at a time - starting with
>> file number 1 of 362 in this folder, and not a 'template' system that
>> allows me to change all of the files en-masse.
>>
>> Anyway, with my first file being a CR2, I'm not able to edit the
>> metadata.  I'm able to choose from the three tabs across the top - Edit
>> EXIF, Edit IPTC or Edit XMP - but not able to choose any of the tabs
>> down the left hand side of that box to edit them.  Fair enough, given
>> that it's a CR2 file, but then if I click on 'Next' to go to the JPG
>> version of the same file (in the hopes of changing that metadata), the
>> system hangs and I am not able to advance to the second picture.  I am
>> unable to Close the box, either by clicking on Close or on the X at the
>> top of the window...  Dialogue buttons show no reaction to clicking, but
>> clicking on the X seems to bring up a KWin warning about non response
>> and asking me if I want to terminate the application and its child
>> windows with the loss of all unsaved data.  Humph!!!
>>
>> It's very repeatable - and I've done it about 10 times tonight trying to
>> find out how to get all this to work.  I'm on Kubuntu 11.10 using
>> version 2.1.1 of Digikam on KDE 4.7.4
>>
>> I'm starting to get concerned that I'm pressing all the wrong buttons
>> etc.  Thousands of people use Digikam without all the problems that I
>> seem to get - and I have been trying on and off to use Digikam for four
>> years... but still struggle to get it up and running.  I give up
>> frequently but come back just as often because I know that it's great
>> software that many people use effortlessly.  So what am I doing wrong????!!!
>>
>> Grateful if anyone can shed some light on this for me.  It really
>> shouldn't seem this hard for me - and yet, honestly (!! :-) ) I am not
>> _that_ stupid all of the time...!
>>
>> Thanks,
>>
>> Mark.
>> _______________________________________________
>> 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
>
>
> End of Digikam-users Digest, Vol 81, Issue 31
> *********************************************
>

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Thumbnail creation and updating of thumbnail database, etc.

Remco Viëtor

On Tuesday 28 February 2012 21:01:01 Mark Hayes wrote:

>

> Remco,

>

> Apologies for the delay.

>

> I'm currently using the following:

>

> Kubuntu 11.10

> Linux kubuntu64 3.0.0-16-generic #28-Ubuntu SMP Fri Jan 27 17:44:39 UTC

> 2012 x86_64 x86_64 x86_64 GNU/Linux

> KDE version 4.7.4

> digikam v 2.1.1 (standard stock install from Kubuntu repositories)

>

> I have updated some packages over the last week - but I'm not sure if

> any are related to digikam. In fact, I couldn't tell you what they

> were. Do you know how to check for the most recently installed packages

> by date? I could then list them out for you.

>

> I did suffer a possible power failure over the weekend whilst I was away

> - I don't really know other than I came back to the house on Sunday and

> the PC had rebooted, so something definitely went wrong. Digikam was

> open at the time of the crash - maybe that corrupted the database?

>

> No new disks installed/used. No changes to Digikam made as far as I know.

>

 

Ok, that helps. A power failure could indeed corrupt things.

http://scribblesandsnaps.wordpress.com/2011/12/19/check-and-optimize-digikams-databases/ gives you a few commands to check and correct your databases (copy those databases to a safe place before trying this!).You probably will have to install a few extra packages, the link I gave tells you which ones.

 

the first two commands are the important ones here:

- sqlite3 -line digikam4.db 'pragma integrity_check;'
- sqlite3 -line thumbnails-digikam.db 'pragma integrity_check;'

 

If you get a message 'integrity_check = ok', the problem is elsewhere, anything else and your database is probably corrupted.

 

Let's try this first, and see what we get.

 

> Sorry that I can't supply more information - but if you can let me know

> any commands to run for you - will get right back to you as soon as I can.

>

> Thanks.

>

> Mark.

>

NP :)

 

But, please remove any non-relevant quoted text, it makes helping you faster and more pleasant for your readers

 


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Thumbnail creation and updating of thumbnail database, etc.

Mark Hayes (Hotmail)
Remco,

Thanks - I installed sqlite3, and ran the commands.

I got 'integrity_check = ok' for both of them.  This would indicate that the databases are OK.

Then I ran the second set of commands and got errors.  I got the following:  Error: database or disk is full

The disk is not full - I checked using the partition editor - no partitions are full at all.  And database sizes are a mere 21.5MB for the digikam database and 86.0MB for the thumbnail database.

Now I'm really confused again - because the database seems OK, but I still have very few thumbnails (and leaving the thumbnail re-creation on for another 20 hours again last night, it was still showing 0% again when I came back to it this evening).

Any other ideas?

Thanks,

Mark.

P.S.  I just tried adding a tag in again - and it failed.  I've expanded all trees and I've definitely 'lost' some tags - that are no longer showing up etc (as well as all my thumbnails).
 

>

 

Ok, that helps. A power failure could indeed corrupt things.

http://scribblesandsnaps.wordpress.com/2011/12/19/check-and-optimize-digikams-databases/ gives you a few commands to check and correct your databases (copy those databases to a safe place before trying this!).You probably will have to install a few extra packages, the link I gave tells you which ones.

 

the first two commands are the important ones here:

- sqlite3 -line digikam4.db 'pragma integrity_check;'
- sqlite3 -line thumbnails-digikam.db 'pragma integrity_check;'

 

If you get a message 'integrity_check = ok', the problem is elsewhere, anything else and your database is probably corrupted.

 

Let's try this first, and see what we get.

 

> Sorry that I can't supply more information - but if you can let me know

> any commands to run for you - will get right back to you as soon as I can.

>

> Thanks.

>

> Mark.

>

NP :)

 

But, please remove any non-relevant quoted text, it makes helping you faster and more pleasant for your readers

 



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