Wrong date in all photos

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

Re: Wrong date in all photos

Gilles Caulier-4
Dotan,

Can you give me some pictures sample to test here.

Note than i can't reproduce the problem with my pictures...

Gilles

2007/3/15, Dotan Cohen <[hidden email]>:
On 15/03/07, Arnd Baecker <[hidden email]> wrote:
> You can quite easily install everything to a separate place,
> see for example http://www.digikam.org/?q=download/svn
> (and as you would do this as a normal user, and not as root,
> there is no danger of breaking anything; fortunately this
> is linux ;-)
>
> Arnd

I'd rather use the stable (yes, I know that it's beta) versions as
this is the wifey machine and I don't need any unforeseen problems or
surprises. Thanks for the suggestion, though.

Dotan Cohen

http://lyricslist.com/lyrics/lyrics/48/402/pink_floyd/pulse.html
http://chridstmas.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
Reply | Threaded
Open this post in threaded view
|

Re: Wrong date in all photos

Dotan Cohen
On 15/03/07, Gilles Caulier <[hidden email]> wrote:
> Dotan,
>
> Can you give me some pictures sample to test here.
>
> Note than i can't reproduce the problem with my pictures...
>
> Gilles
>

Sent off-list as the picture is 1 MB in size.

Dotan Cohen

http://what-is-what.com/what_is/bug.html
http://lyricslist.com/lyrics/artist_albums/633/wohlstandskinder.html
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Wrong date in all photos

Gilles Caulier-4
In reply to this post by Gilles Caulier-4
Like i cannot reproduce this problem on my computer with you rpicture sample, we need to investiguate better.

Question : can you give me the root album library path where are stored your pictures. Are you used a network shared path ?

Gilles

2007/3/15, Gilles Caulier <[hidden email]>:
Dotan,

Can you give me some pictures sample to test here.

Note than i can't reproduce the problem with my pictures...

Gilles

2007/3/15, Dotan Cohen <[hidden email]>:
On 15/03/07, Arnd Baecker < [hidden email]> wrote:
> You can quite easily install everything to a separate place,
> see for example <a href="http://www.digikam.org/?q=download/svn" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"> http://www.digikam.org/?q=download/svn
> (and as you would do this as a normal user, and not as root,
> there is no danger of breaking anything; fortunately this
> is linux ;-)
>
> Arnd

I'd rather use the stable (yes, I know that it's beta) versions as
this is the wifey machine and I don't need any unforeseen problems or
surprises. Thanks for the suggestion, though.

Dotan Cohen

<a href="http://lyricslist.com/lyrics/lyrics/48/402/pink_floyd/pulse.html" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"> http://lyricslist.com/lyrics/lyrics/48/402/pink_floyd/pulse.html
<a href="http://chridstmas.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://chridstmas.com
_______________________________________________
Digikam-users mailing list
[hidden email]
<a href="https://mail.kde.org/mailman/listinfo/digikam-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">https://mail.kde.org/mailman/listinfo/digikam-users



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

Re: Wrong date in all photos

Dotan Cohen
On 15/03/07, Gilles Caulier <[hidden email]> wrote:
> Like i cannot reproduce this problem on my computer with you rpicture
> sample, we need to investiguate better.

Interesting. I don't know where to go from here. I can try to build
from SVN, but that will be in a few days.

> Question : can you give me the root album library path where are stored your
> pictures. Are you used a network shared path ?
>
> Gilles

It's local:
/home/dotancohen/pictures/digikam/

Dotan Cohen

http://what-is-what.com/what_is/aids.html
http://about-config.com
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Wrong date in all photos

Fabien-5
In reply to this post by Dotan Cohen
Hello,

Just to make it a bit clearer for me (and maybe others) :
If I'm not wrong, there are a few dates associated with a picture :

1) in file properties :
- time of last access (not very useful for us)
- time of last change in the data of the file
- time of last modification of the file status
(ususally, change and modification date are the same)

This is common to any file on a unix file system.

2) in EXIF :

at least
- DateTime
- DateTimeOriginal
- DateTimeDigitized
And also some fields in IPTC.


Could you configure digiKam to display in tooltip "camera date" and
"file date" ?
And also, configure digiKam (Album settings) to display "file creating
date" and "file modification date"

Then, give us the 2 dates you get...


Dotan Cohen wrote:

> On 14/03/07, Gilles Caulier <[hidden email]> wrote:
>
>>Witch camera model you use ?
>
>
> My personal camera is a Fuji 5500, before that a Fuji 2800. The wife
> insists on photographing with her Nokia 6280 and we have hundreds of
> photos from friends with different models of cameras.
>
> Note that the problem occurs with all the photos, irregardless of
> camera used. And opening the photos with other tools such as F-Spot
> does not present a problem: in F-Spot the photos are sorted properly.
> So I don't think that the problem is with the photos themselves :)

--
Fabien

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

Re: Wrong date in all photos

Gilles Caulier-4


2007/3/15, Fabien <[hidden email]>:
Hello,

Just to make it a bit clearer for me (and maybe others) :
If I'm not wrong, there are a few dates associated with a picture :

1) in file properties :
- time of last access (not very useful for us)
- time of last change in the data of the file
- time of last modification of the file status
(ususally, change and modification date are the same)

This is common to any file on a unix file system.

These are the _File_ date properties on file system. This is not the date when have be taken the picture.
 

2) in EXIF :

at least
- DateTime
- DateTimeOriginal
- DateTimeDigitized
And also some fields in IPTC.

There are the date when have been taken the picture. this date is used by digiKam to perform search.

Could you configure digiKam to display in tooltip "camera date" and
"file date" ?

It's already in Photograph properties every where.
 

And also, configure digiKam (Album settings) to display "file creating
date" and "file modification date"

Already exist in Setup Album page
 
Gilles


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

Re: Wrong date in all photos

Fabien-5
Gilles,

I know that :) I just asked Dotan to give more informations, so that we
can check where's the problem...

Gilles Caulier wrote:

>
>
> 2007/3/15, Fabien <[hidden email]
> <mailto:[hidden email]>>:
>
>     Hello,
>
>     Just to make it a bit clearer for me (and maybe others) :
>     If I'm not wrong, there are a few dates associated with a picture :
>
>     1) in file properties :
>     - time of last access (not very useful for us)
>     - time of last change in the data of the file
>     - time of last modification of the file status
>     (ususally, change and modification date are the same)
>
>     This is common to any file on a unix file system.
>
>
> These are the _File_ date properties on file system. This is not the
> date when have be taken the picture.
>  
>
>     2) in EXIF :
>
>     at least
>     - DateTime
>     - DateTimeOriginal
>     - DateTimeDigitized
>     And also some fields in IPTC.
>
>
> There are the date when have been taken the picture. this date is used
> by digiKam to perform search.
>
>     Could you configure digiKam to display in tooltip "camera date" and
>     "file date" ?
>
>
> It's already in Photograph properties every where.
>  
>
>     And also, configure digiKam (Album settings) to display "file creating
>     date" and "file modification date"
>
>
> Already exist in Setup Album page


--
Fabien

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

Re: Wrong date in all photos

Dotan Cohen
In reply to this post by Gilles Caulier-4
On 15/03/07, Gilles Caulier <[hidden email]> wrote:

> 2007/3/15, Fabien <[hidden email]>:
> > Hello,
> >
> > Just to make it a bit clearer for me (and maybe others) :
> > If I'm not wrong, there are a few dates associated with a picture :
> >
> > 1) in file properties :
> > - time of last access (not very useful for us)
> > - time of last change in the data of the file
> > - time of last modification of the file status
> > (ususally, change and modification date are the same)
> >
> > This is common to any file on a unix file system.
>
> These are the _File_ date properties on file system. This is not the date
> when have be taken the picture.
>
> > 2) in EXIF :
> >
> > at least
> > - DateTime
> > - DateTimeOriginal
> > - DateTimeDigitized
> > And also some fields in IPTC.
>
> There are the date when have been taken the picture. this date is used by
> digiKam to perform search.
>
> > Could you configure digiKam to display in tooltip "camera date" and
> > "file date" ?
>
> It's already in Photograph properties every where.
>
> > And also, configure digiKam (Album settings) to display "file creating
> > date" and "file modification date"
>
> Already exist in Setup Album page

Thanks, I'm at the university right now but when I get home I'll set
it up to display the needed info in the tooltips. I thought that I
turned on all the available dates in the tooltips, but I may have
missed one or three.

Fabien, in the meantime I'll forward to you a screenshot that I sent to Gilles.

Thanks.

Dotan Coen

http://what-is-what.com/what_is/unix.html
http://music-liriks.com
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Wrong date in all photos

Gilles Caulier-4
Dotan,

You can check into you sqlite database file if image date stamp are correct. The file is digikam3.db stored in you root album library path.

i use 'sqlitebrowser' program to display content. others DB GUI don't work properlly (kexi, knoda, etc.)

http://sqlitebrowser.sourceforge.net/

The file content have some tables easy to understand.

If you don't understand DB stuff, you can send this file by private mail.

Gilles

2007/3/15, Dotan Cohen <[hidden email]>:
On 15/03/07, Gilles Caulier <[hidden email]> wrote:
> 2007/3/15, Fabien <[hidden email]>:
> > Hello,

> >
> > Just to make it a bit clearer for me (and maybe others) :
> > If I'm not wrong, there are a few dates associated with a picture :
> >
> > 1) in file properties :
> > - time of last access (not very useful for us)
> > - time of last change in the data of the file
> > - time of last modification of the file status
> > (ususally, change and modification date are the same)
> >
> > This is common to any file on a unix file system.
>
> These are the _File_ date properties on file system. This is not the date
> when have be taken the picture.
>
> > 2) in EXIF :
> >
> > at least
> > - DateTime
> > - DateTimeOriginal
> > - DateTimeDigitized
> > And also some fields in IPTC.
>
> There are the date when have been taken the picture. this date is used by
> digiKam to perform search.
>
> > Could you configure digiKam to display in tooltip "camera date" and
> > "file date" ?
>
> It's already in Photograph properties every where.
>
> > And also, configure digiKam (Album settings) to display "file creating
> > date" and "file modification date"
>
> Already exist in Setup Album page

Thanks, I'm at the university right now but when I get home I'll set
it up to display the needed info in the tooltips. I thought that I
turned on all the available dates in the tooltips, but I may have
missed one or three.

Fabien, in the meantime I'll forward to you a screenshot that I sent to Gilles.

Thanks.

Dotan Coen

http://what-is-what.com/what_is/unix.html
http://music-liriks.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
Reply | Threaded
Open this post in threaded view
|

Re: Wrong date in all photos

Fabien-5
In reply to this post by Dotan Cohen
Hi,

Dotan, I received your screenshot.
There's one thing that is unclear :
- we can see that the photograph properties are correct, showing the
right creation date, in the tooltip and in the sidebar (2 different
pictures)
- we can see other pictures in the main thumbnail view which have the
same date for creation and modification

Does this apply to all your pictures, ie creation date showed under the
thumbnail doesn't match the creation date you see in the photograph
properties ?

If it's the case, that would be the problem. I guess this is why Gilles
asked you the database to check it...

Dotan Cohen wrote:
 > [...]

>>>1) in file properties :
>>>- time of last access (not very useful for us)
>>>- time of last change in the data of the file
>>>- time of last modification of the file status
>>>(ususally, change and modification date are the same)
>>>
>>>This is common to any file on a unix file system.
>>
>>These are the _File_ date properties on file system. This is not the date
>>when have be taken the picture.
>>
>>
>>>2) in EXIF :
>>>
>>>at least
>>>- DateTime
>>>- DateTimeOriginal
>>>- DateTimeDigitized
>>>And also some fields in IPTC.

> Thanks, I'm at the university right now but when I get home I'll set
> it up to display the needed info in the tooltips. I thought that I
> turned on all the available dates in the tooltips, but I may have
> missed one or three.
>
> Fabien, in the meantime I'll forward to you a screenshot that I sent to Gilles.

--
Fabien

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

Re: Wrong date in all photos

Gilles Caulier-4


2007/3/19, Fabien <[hidden email]>:
Hi,

Dotan, I received your screenshot.
There's one thing that is unclear :
- we can see that the photograph properties are correct, showing the
right creation date, in the tooltip and in the sidebar (2 different
pictures)
- we can see other pictures in the main thumbnail view which have the
same date for creation and modification

Does this apply to all your pictures, ie creation date showed under the
thumbnail doesn't match the creation date you see in the photograph
properties ?

If it's the case, that would be the problem. I guess this is why Gilles
asked you the database to check it...


Well, just to check if Date recorded in database is right....

Gilles


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

Re: Wrong date in all photos

Dotan Cohen
In reply to this post by Gilles Caulier-4
On 15/03/07, Gilles Caulier <[hidden email]> wrote:

> Dotan,
>
> You can check into you sqlite database file if image date stamp are correct.
> The file is digikam3.db stored in you root album library path.
>
> i use 'sqlitebrowser' program to display content. others DB GUI don't work
> properlly (kexi, knoda, etc.)
>
> http://sqlitebrowser.sourceforge.net/
>
> The file content have some tables easy to understand.
>
> If you don't understand DB stuff, you can send this file by private mail.
>
> Gilles
>

Sorry for the delay. I'll check the DB tomorrow when I get home. In
any case, exiv2 0.14 has been released today, so I'll install that as
well and report back. Thanks!

Dotan Cohen

http://lyricslist.com/lyrics/artist_albums/129/corrosion_of_conformity.html
http://u-tube-com.com
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Wrong date in all photos

Dotan Cohen
Alright, I think that I've identified the problem. The database has
the wrong dates for some reason. I simply copied the database from my
old 0.9.0 installation. But when I copy and reimport a photo, then it
has the correct date.

I would simple erase the digikam.db file, but then I would lose all my
tag information. Is there a way to either:
1) Have the database rebuild the date information?
    or
2) Save the tag information so that I can reimport the photos?

Thanks in advance.

Dotan Cohen

http://technology-sleuth.com/long_answer/why_are_internet_greeting_cards_dangerous.html
http://what-is-what.com/what_is/touch.html
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Wrong date in all photos

Marcel Wiesweg
Am Freitag 23 März 2007 09:51 schrieb Dotan Cohen:
> Alright, I think that I've identified the problem. The database has
> the wrong dates for some reason. I simply copied the database from my
> old 0.9.0 installation. But when I copy and reimport a photo, then it
> has the correct date.
>
> I would simple erase the digikam.db file, but then I would lose all my
> tag information. Is there a way to either:
> 1) Have the database rebuild the date information?
>     or

With the sqlite3 tool, execute
"UPDATE Images SET datetime=null;"
Then at startup, scanlib should update the date information.
Of course make a backup of your database file!

> 2) Save the tag information so that I can reimport the photos?
>
> Thanks in advance.
>
> Dotan Cohen
>
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Wrong date in all photos

Dotan Cohen
On 25/03/07, Marcel Wiesweg <[hidden email]> wrote:

> Am Freitag 23 März 2007 09:51 schrieb Dotan Cohen:
> > Alright, I think that I've identified the problem. The database has
> > the wrong dates for some reason. I simply copied the database from my
> > old 0.9.0 installation. But when I copy and reimport a photo, then it
> > has the correct date.
> >
> > I would simple erase the digikam.db file, but then I would lose all my
> > tag information. Is there a way to either:
> > 1) Have the database rebuild the date information?
> >     or
>
> With the sqlite3 tool, execute
> "UPDATE Images SET datetime=null;"
> Then at startup, scanlib should update the date information.
> Of course make a backup of your database file!
>

Thank you, that worked fine. Upon startup Digikam rebuilt the missing
info and now the dates are correct.

Dotan Cohen

http://what-is-what.com/what_is/web_browser.html
http://lyricslist.com/lyrics/artist_albums/359/morrison_van.html
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
12