Bug 185915

Summary: Album View: "Created" time of video set to "00:00"
Product: [Applications] digikam Reporter: René Krell <renda.krell>
Component: Metadata-VideoAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: caulier.gilles, marcel.wiesweg
Priority: NOR    
Version: 0.10.0   
Target Milestone: ---   
Platform: unspecified   
OS: Linux   
Latest Commit: Version Fixed In: 6.0.0
Sentry Crash Report:

Description René Krell 2009-03-01 23:19:58 UTC 
Version:           0.10.0 (rev.: 933866) (using 4.2.00 (KDE 4.2.0) "release 102", KDE:KDE4:Factory:Desktop / openSUSE_11.1)
Compiler:          gcc
OS:                Linux (x86_64) release 2.6.27.19-3.2-default

There is already a long time a problem with some older videoclips in showing "created:" time in album view, which is "00:00", but in the tooltip over the video icon is shown the right date after the "Date:" label. This concerns only a few, not all videos. Unfortunately this goes along with an even worse problem: Changing View - Sort Images to "By Date" puts those videos with "00:00" to the beginning and doesn't use the right creating date (as in the tooltip).

The file creation timestamp of the mentioned files is correct and equals the time the clip was really created.

Maybe this is an import problem because I used the same folder with digikam for KDE3, too.
Comment 1 René Krell 2009-03-01 23:27:12 UTC 
Details of a video file which is displayed correctly:

mediainfo "2008-05-22 17.41.54.avi"         
General                                                                                           
Complete name                    : 2008-05-22 17.41.54.avi                                        
Format                           : AVI                                                            
Format/Info                      : Audio Video Interleave                                         
File size                        : 1.85 MiB                                                       
Duration                         : 5s 868ms                                                       
Overall bit rate                 : 2 643 Kbps                                                     
Mastered date                    : Thu May 22 17:41:54 2008                                       
Writing application              : OLYMPUS u830/S830                                              
Writing library                  : OLYMDigital CameraOLYMPUS DIGITAL CAMERA                       

... and of one which gets the "Created: 00:00" in album view:

mediainfo "2008-09-21 14.19.20.avi" 
General                                                                                   
Complete name                    : 2008-09-21 14.19.20.avi                                
Format                           : AVI                                                    
Format/Info                      : Audio Video Interleave                                 
File size                        : 8.22 MiB                                               
Duration                         : 25s 600ms                                              
Overall bit rate                 : 2 694 Kbps                                             
Mastered date                    : Sun Sep 21 14:19:20 2008                               
Writing application              : OLYMPUS u830/S830                                      
Writing library                  : OLYMDigital CameraOLYMPUS DIGITAL CAMERA

I can't see a problem with the file contents, as far as I can see.
Comment 2 Marcel Wiesweg 2009-03-02 23:02:22 UTC 
The tooltip shows the modification date, you can only compare it to the "modified:" date in the album view, if configured to show it.
May it be that you imported the affected video files with older beta versions of digikam 0.10? There was a bug scanning video files, fixed some time ago.
Comment 3 René Krell 2009-03-02 23:08:27 UTC 
Yes, I imported those videos with some beta version of Digikam.
Do You know how to regenerate the right tags? Importing them from a different place a second time? Or is there an easier way?
Comment 4 Marcel Wiesweg 2009-03-03 21:58:00 UTC 
No unfortunately there is no easy way at the moment. Especially, importing from a second place will not do it (digikam is too smart sometimes and will recognize it already knows these images).
The current way is to set modification date to null in the db which enforces a full rescan. So opening the db file with the sqlite3 tool and execute

UPDATE Images SET modificationDate=null WHERE category=2;

I hope that does the trick. (If you have valuable tags assigned to these video files make a db backup before ;-) )

Sorry for that problem and thanks for beta-testing!
Comment 5 Marcel Wiesweg 2009-03-03 21:59:06 UTC 
The SQL above affects all your video files; this will only affect the files with missing creationDate, but I'm not sure if it catches the files:

UPDATE Images SET modificationDate=null WHERE id in (SELECT id FROM Images LEFT JOIN ImageInformation ON id=imageid WHERE creationDate=NULL);
Comment 6 René Krell 2009-03-03 22:46:44 UTC 
Thank you very much for these tips. I executed the latest SQL:

sqlite3 digikam4.db
SQLite version 3.6.4
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> UPDATE Images SET modificationDate=null WHERE id in (SELECT id FROM Images LEFT JOIN ImageInformation ON id=imageid WHERE creationDate=NULL);
sqlite> .quit

but digikam 0.10.0 (rev.: 934372) crashes now on startup with:

Application: digiKam (digikam), signal SIGSEGV
[?1034h[Thread debugging using libthread_db enabled]
0x00007fe177ad6ce1 in nanosleep () from /lib64/libc.so.6
[Current thread is 1 (Thread 0x7fe17ed0b750 (LWP 13155))]

Thread 11 (Thread 0x7fe16b039950 (LWP 13156)):
#0  0x00007fe178512d59 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007fe178783f39 in QWaitCondition::wait (this=0xc63348, mutex=0xc63340, time=18446744073709551615) at thread/qwaitcondition_unix.cpp:83
#2  0x00000000006c7cb8 in Digikam::ScanController::run (this=0xc62f10) at /home/rkrell/src/KDE/graphics/digikam/digikam/scancontroller.cpp:412
#3  0x00007fe178782f82 in QThreadPrivate::start (arg=0xc62f10) at thread/qthread_unix.cpp:185
#4  0x00007fe17850f070 in start_thread () from /lib64/libpthread.so.0
#5  0x00007fe177b0810d in clone () from /lib64/libc.so.6
#6  0x0000000000000000 in ?? ()

Thread 10 (Thread 0x7fe169913950 (LWP 13159)):
#0  0x00007fe178512d59 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007fe178783f39 in QWaitCondition::wait (this=0xfcbba0, mutex=0xfcbb98, time=18446744073709551615) at thread/qwaitcondition_unix.cpp:83
#2  0x00007fe17c0248bf in Digikam::LoadSaveThread::run (this=0xfcbb80) at /home/rkrell/src/KDE/graphics/digikam/libs/threadimageio/loadsavethread.cpp:131
#3  0x00007fe178782f82 in QThreadPrivate::start (arg=0xfcbb80) at thread/qthread_unix.cpp:185
#4  0x00007fe17850f070 in start_thread () from /lib64/libpthread.so.0
#5  0x00007fe177b0810d in clone () from /lib64/libc.so.6
#6  0x0000000000000000 in ?? ()

Thread 9 (Thread 0x7fe16a114950 (LWP 13160)):
#0  0x00007fe178512d59 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007fe178783f39 in QWaitCondition::wait (this=0xe08670, mutex=0xe08668, time=18446744073709551615) at thread/qwaitcondition_unix.cpp:83
#2  0x00007fe17c0248bf in Digikam::LoadSaveThread::run (this=0xe08650) at /home/rkrell/src/KDE/graphics/digikam/libs/threadimageio/loadsavethread.cpp:131
#3  0x00007fe178782f82 in QThreadPrivate::start (arg=0xe08650) at thread/qthread_unix.cpp:185
#4  0x00007fe17850f070 in start_thread () from /lib64/libpthread.so.0
#5  0x00007fe177b0810d in clone () from /lib64/libc.so.6
#6  0x0000000000000000 in ?? ()

Thread 8 (Thread 0x7fe161162950 (LWP 13161)):
#0  0x00007fe178512fdd in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007fe1671b2611 in ?? () from /usr/lib64/libxine.so.1
#2  0x00007fe17850f070 in start_thread () from /lib64/libpthread.so.0
#3  0x00007fe177b0810d in clone () from /lib64/libc.so.6
#4  0x0000000000000000 in ?? ()

Thread 7 (Thread 0x7fe15f084950 (LWP 13162)):
#0  0x00007fe178512fdd in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007fe1671c0685 in ?? () from /usr/lib64/libxine.so.1
#2  0x00007fe17850f070 in start_thread () from /lib64/libpthread.so.0
#3  0x00007fe177b0810d in clone () from /lib64/libc.so.6
#4  0x0000000000000000 in ?? ()

Thread 6 (Thread 0x7fe15e883950 (LWP 13163)):
#0  0x00007fe177aff386 in poll () from /lib64/libc.so.6
#1  0x00007fe175109748 in g_main_context_iterate (context=0xab9260, block=1, dispatch=1, self=<value optimized out>) at gmain.c:3091
#2  0x00007fe175109a6b in IA__g_main_context_iteration (context=0xab9260, may_block=1) at gmain.c:2841
#3  0x00007fe17889563e in QEventDispatcherGlib::processEvents (this=0xe70150, flags=<value optimized out>) at kernel/qeventdispatcher_glib.cpp:321
#4  0x00007fe17886a792 in QEventLoop::processEvents (this=<value optimized out>, flags={i = 1585983472}) at kernel/qeventloop.cpp:145
#5  0x00007fe17886ab5d in QEventLoop::exec (this=0x7fe15e883030, flags={i = 1585983552}) at kernel/qeventloop.cpp:196
#6  0x00007fe17877ffe8 in QThread::exec (this=<value optimized out>) at thread/qthread.cpp:477
#7  0x00007fe16740db12 in ?? () from /usr/lib64/kde4/plugins/phonon_backend/phonon_xine.so
#8  0x00007fe178782f82 in QThreadPrivate::start (arg=0xd29b40) at thread/qthread_unix.cpp:185
#9  0x00007fe17850f070 in start_thread () from /lib64/libpthread.so.0
#10 0x00007fe177b0810d in clone () from /lib64/libc.so.6
#11 0x0000000000000000 in ?? ()

Thread 5 (Thread 0x7fe15dd65950 (LWP 13166)):
#0  0x00007fe177aff386 in poll () from /lib64/libc.so.6
#1  0x00007fe15de7d9c1 in ?? () from /usr/lib64/xine/plugins/1.25/xineplug_ao_out_alsa.so
#2  0x00007fe17850f070 in start_thread () from /lib64/libpthread.so.0
#3  0x00007fe177b0810d in clone () from /lib64/libc.so.6
#4  0x0000000000000000 in ?? ()

Thread 4 (Thread 0x7fe15d543950 (LWP 13167)):
#0  0x00007fe178512d59 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007fe1671c3b63 in ?? () from /usr/lib64/libxine.so.1
#2  0x00007fe17850f070 in start_thread () from /lib64/libpthread.so.0
#3  0x00007fe177b0810d in clone () from /lib64/libc.so.6
#4  0x0000000000000000 in ?? ()

Thread 3 (Thread 0x7fe15a5fc950 (LWP 13183)):
#0  0x00007fe178512d59 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007fe178783f39 in QWaitCondition::wait (this=0x385d770, mutex=0x385d768, time=18446744073709551615) at thread/qwaitcondition_unix.cpp:83
#2  0x00007fe17c0248bf in Digikam::LoadSaveThread::run (this=0x385d750) at /home/rkrell/src/KDE/graphics/digikam/libs/threadimageio/loadsavethread.cpp:131
#3  0x00007fe178782f82 in QThreadPrivate::start (arg=0x385d750) at thread/qthread_unix.cpp:185
#4  0x00007fe17850f070 in start_thread () from /lib64/libpthread.so.0
#5  0x00007fe177b0810d in clone () from /lib64/libc.so.6
#6  0x0000000000000000 in ?? ()

Thread 2 (Thread 0x7fe15bea5950 (LWP 13189)):
#0  0x00007fe178512fdd in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00007fe178783f17 in QWaitCondition::wait (this=0x4f938a8, mutex=0x4f938a0, time=30000) at thread/qwaitcondition_unix.cpp:81
#2  0x00007fe178779a49 in QThreadPoolThread::run (this=0x5011c20) at concurrent/qthreadpool.cpp:136
#3  0x00007fe178782f82 in QThreadPrivate::start (arg=0x5011c20) at thread/qthread_unix.cpp:185
#4  0x00007fe17850f070 in start_thread () from /lib64/libpthread.so.0
#5  0x00007fe177b0810d in clone () from /lib64/libc.so.6
#6  0x0000000000000000 in ?? ()

Thread 1 (Thread 0x7fe17ed0b750 (LWP 13155)):
[KCrash Handler]
#5  0x00007fe156d2c4e0 in ?? () from /usr/X11R6/lib64/libGLcore.so.1
#6  0x00007fe157b69c67 in _init () from /usr/lib64/libGL.so.1
#7  0x00007fe17eb4d8d8 in call_init (l=0x50acf40, argc=5, argv=0x7fff86d5c008, env=0xf21860) at dl-init.c:70
#8  0x00007fe17eb4da07 in _dl_init (main_map=0x5088600, argc=5, argv=0x7fff86d5c008, env=0xf21860) at dl-init.c:134
#9  0x00007fe17eb51bde in dl_open_worker (a=<value optimized out>) at dl-open.c:516
#10 0x00007fe17eb4d566 in _dl_catch_error (objname=0x7fff86d5ab00, errstring=0x7fff86d5aaf8, mallocedp=0x7fff86d5ab0f, operate=0x7fe17eb51860 <dl_open_worker>, args=0x7fff86d5aab0) at dl-error.c:178
#11 0x00007fe17eb5138b in _dl_open (file=0x5088ba8 "/usr/lib64/kde4/kipiplugin_advancedslideshow.so", mode=-2147483647, caller_dlopen=0x7fe17885f7a6, nsid=-2, argc=5, argv=0x7fff86d5c008, 
    env=0xf21860) at dl-open.c:596
#12 0x00007fe174ec8f9b in dlopen_doit (a=<value optimized out>) at dlopen.c:67
#13 0x00007fe17eb4d566 in _dl_catch_error (objname=0xa75190, errstring=0xa75198, mallocedp=0xa75188, operate=0x7fe174ec8f30 <dlopen_doit>, args=0x7fff86d5acd0) at dl-error.c:178
#14 0x00007fe174ec934c in _dlerror_run (operate=0x7fe174ec8f30 <dlopen_doit>, args=0x7fff86d5acd0) at dlerror.c:164
#15 0x00007fe174ec8f01 in __dlopen (file=<value optimized out>, mode=<value optimized out>) at dlopen.c:88
#16 0x00007fe17885f7a6 in QLibraryPrivate::load_sys (this=0xb54910) at plugin/qlibrary_unix.cpp:182
#17 0x00007fe17885a0e5 in QLibraryPrivate::loadPlugin (this=0xb54910) at plugin/qlibrary.cpp:490
#18 0x00007fe178fa7031 in KPluginLoader::load (this=0x0) at /usr/src/debug/kdelibs-4.2.0/kdecore/util/kpluginloader.cpp:172
#19 0x00007fe178fa768b in KPluginLoader (this=0x7fff86d5b180, service=@0x5009e00, componentdata=@0xa1d260, parent=<value optimized out>)
    at /usr/src/debug/kdelibs-4.2.0/kdecore/util/kpluginloader.cpp:134
#20 0x00007fe17d6ceaba in KService::createInstance<KIPI::Plugin> (this=0x5009e00, parentWidget=0x0, parent=0x48fa950, args=@0x7fff86d5b290, error=0x7fff86d5b280) at /usr/include/kservice.h:521
#21 0x00007fe17d6cec61 in KService::createInstance<KIPI::Plugin> (this=0x5009e00, parent=0x48fa950, args=@0x7fff86d5b290, error=0x7fff86d5b280) at /usr/include/kservice.h:501
#22 0x00007fe17d6ccb21 in KIPI::PluginLoader::loadPlugin (this=0x50092e0, info=0x5009510) at /home/rkrell/src/KDE/kdegraphics/libs/libkipi/libkipi/pluginloader.cpp:271
#23 0x00007fe17d6ccf81 in KIPI::PluginLoader::loadPlugins (this=0x50092e0) at /home/rkrell/src/KDE/kdegraphics/libs/libkipi/libkipi/pluginloader.cpp:261
#24 0x000000000065e1c8 in Digikam::DigikamApp::loadPlugins (this=0xcc6170) at /home/rkrell/src/KDE/graphics/digikam/digikam/digikamapp.cpp:2196
#25 0x0000000000679fc0 in DigikamApp (this=0xcc6170) at /home/rkrell/src/KDE/graphics/digikam/digikam/digikamapp.cpp:225
#26 0x00000000006f30b7 in main (argc=5, argv=0x7fff86d5c008) at /home/rkrell/src/KDE/graphics/digikam/digikam/main.cpp:167

which  is appearantly a different problem. I can put it to a different issue, if You want to.
Comment 7 caulier.gilles 2009-03-03 22:57:58 UTC 
No need to open report for that. It already exist. it's a problem with kipi-plugin AdvancedSlideShow.

A quick fix it to uninstall this plugin temporally.

Gilles Caulier
Comment 8 René Krell 2009-03-03 23:02:09 UTC 
Hi Gilles. you are right, I reported this yesterday and "solved" it temporarily by installing the kde4-kipi-plugins RC2 precompiled package, but 'sudo make install' reinstalled the bad plugin, of course. Sorry, I'm a bit confused today :-)
Comment 9 René Krell 2009-03-05 09:27:50 UTC 
Well, the SQL on the digikam4 db did not lead to the desired effect, there were even more videos in album view with "Created: 00:00", instead. Renaming the original digikam4 database file and reimporting all albums did help, and it even did not take so much time.
Thus, the problem seems not to occur any longer in 0.10.0 RC2 and later.
Comment 10 caulier.gilles 2018-03-14 04:38:10 UTC 
Fixed with next 6.0.0 release which integrate a nex video metadata parser based
on FFMPEg instead Exiv2. Video date extraction work as expected...

Gilles Caulier