[Bug 185915] New: Album View: "Created" time of video set to "00:00"

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

           Summary: Album View: "Created" time of video set to "00:00"
           Product: digikam
           Version: unspecified
          Platform: unspecified
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
        AssignedTo: [hidden email]
        ReportedBy: [hidden email]


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.

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





--- Comment #1 from René <rkrell gmx net>  2009-03-01 23:27:12 ---
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.

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


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|general                     |Albums GUI
            Version|unspecified                 |0.10.0-svn




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

[Marcel Wiesweg]

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


Marcel Wiesweg <[hidden email]> changed:

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




--- Comment #2 from Marcel Wiesweg <marcel wiesweg gmx de>  2009-03-02 23:02:22 ---
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.

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





--- Comment #3 from René <rkrell gmx net>  2009-03-02 23:08:27 ---
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?

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

[Marcel Wiesweg]

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





--- Comment #4 from Marcel Wiesweg <marcel wiesweg gmx de>  2009-03-03 21:58:00 ---
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!

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

[Marcel Wiesweg]

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





--- Comment #5 from Marcel Wiesweg <marcel wiesweg gmx de>  2009-03-03 21:59:06 ---
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);

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





--- Comment #6 from René <rkrell gmx net>  2009-03-03 22:46:44 ---
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.

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





--- Comment #7 from Gilles Caulier <caulier gilles gmail com>  2009-03-03 22:57:58 ---
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

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





--- Comment #8 from René <rkrell gmx net>  2009-03-03 23:02:09 ---
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
:-)

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


René <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|                            |WORKSFORME




--- Comment #9 from René <rkrell gmx net>  2009-03-05 09:27:50 ---
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.

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


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|0.10.0-svn                  |0.10.0




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