<div dir="ltr"><div>Ok, I may have it already as my version is sqlite-3.8.2</div><div><br></div>I did enable a sqlite3 USE flag in the make.conf but when doing an "emerge -avuND @world" no package picks it up. There is a dev-ruby/sqlite3 that says this: "An extension library to access a SQLite database from Ruby" so not sure that would do anything for me. Thanks much for the response. cheers, Jim</div>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jan 2, 2014 at 12:25 PM, Gilles Caulier <span dir="ltr"><<a href="mailto:caulier.gilles@gmail.com" target="_blank">caulier.gilles@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">yes, you need SQlite3 Qt plugin... not SQlite directly. We use Qt DB SDK<br>
<br>
Gilles Caulier<br>
<br>
2014/1/2 Jim Dory <<a href="mailto:james@dorydesign.com">james@dorydesign.com</a>>:<br>
<div class="HOEnZb"><div class="h5">> Happy New Year Gilles,<br>
><br>
> Does digikam need sqlite3 for gentoo, do you know? This page seems to<br>
> suggest that:<br>
> <a href="https://projects.kde.org/projects/extragear/graphics/digikam/repository/revisions/master/entry/README" target="_blank">https://projects.kde.org/projects/extragear/graphics/digikam/repository/revisions/master/entry/README</a><br>
><br>
> On my system I have sqlite installed, but not sqlite3. I may go ahead and<br>
> install that, but wondering if it will fix my thumbnails and crashing<br>
> problem.<br>
><br>
> cheers, Jim<br>
><br>
><br>
> On Fri, Dec 20, 2013 at 12:20 AM, Gilles Caulier <<a href="mailto:caulier.gilles@gmail.com">caulier.gilles@gmail.com</a>><br>
> wrote:<br>
>><br>
>> It crash in Sqlite Qt driver. There is no reason for that, excepted if<br>
>> binary compatibility is broken due to a recent update of system<br>
>> package... It's the eternal problem under Linux if packager don't take<br>
>> a care enough...<br>
>><br>
>> Note : your digiKam is not compiled with debug symbols. There is no<br>
>> source code from digiKam printed in GDB...<br>
>><br>
>> Gilles Caulier<br>
>><br>
>> 2013/12/20 Jim Dory <<a href="mailto:james@dorydesign.com">james@dorydesign.com</a>>:<br>
>> > I have been very unstable since 3.5. I'm running Gentoo and unstable<br>
>> > settings ( ~amd_64) but haven't had any problem until this latest<br>
>> > digikam<br>
>> > version. KDE-4.12<br>
>> ><br>
>> > I can work several minutes and then it crashes. Not reproducible other<br>
>> > than<br>
>> > just using it for a bit - nothing in particular seems to be the cause.<br>
>> > Program just disappears - closes completely.<br>
>> ><br>
>> > I recompiled it with the debug use flag (compiled in debug) and I'll<br>
>> > give a<br>
>> > little backtrace when it crashed - although this time it didn't just<br>
>> > close<br>
>> > like usual.. but maybe that was from running it with gdb. This time it<br>
>> > just<br>
>> > froze, and I see I had a seg fault. At the time I had just clicked on an<br>
>> > image thumbnail in an album.<br>
>> ><br>
>> > I've also had problems with it not properly reading the thumbnails. I<br>
>> > can<br>
>> > fix a few of them by running "rebuild the thumbnails in current album"<br>
>> > but<br>
>> > it won't fix them all and sometimes they revert to other image<br>
>> > thumbnails.<br>
>> ><br>
>> > I'm running the albums on a network attached storage, though the<br>
>> > database is<br>
>> > on my home partition.<br>
>> ><br>
>> > Here's my component list followed by the 'bt': (hope this helps - let<br>
>> > me<br>
>> > know what else you might want)<br>
>> ><br>
>> > digiKam version 3.5.0<br>
>> > Demosaic GPL2 pack support: Yes<br>
>> > Demosaic GPL3 pack support: Yes<br>
>> > Exiv2 can write to Jp2: Yes<br>
>> > Exiv2 can write to Jpeg: Yes<br>
>> > Exiv2 can write to Pgf: Yes<br>
>> > Exiv2 can write to Png: Yes<br>
>> > Exiv2 can write to Tiff: Yes<br>
>> > Exiv2 supports XMP metadata: Yes<br>
>> > LibCImg: 130<br>
>> > LibEigen: 3.1.3<br>
>> > LibExiv2: 0.23<br>
>> > LibJPEG: 62<br>
>> > LibJasper: 1.900.1<br>
>> > LibKDE: 4.12.0<br>
>> > LibKExiv2: 2.3.1<br>
>> > LibKGeoMap: 2.0.0<br>
>> > LibKdcraw: 2.4.2<br>
>> > LibLCMS: 2050<br>
>> > LibLensFun: 0.2.8-0<br>
>> > LibPGF: 6.12.27 - external shared library<br>
>> > LibPNG: 1.6.7<br>
>> > LibQt: 4.8.5<br>
>> > LibRaw: 0.15.4<br>
>> > LibTIFF: LIBTIFF, Version 4.0.3 Copyright (c) 1988-1996 Sam Leffler<br>
>> > Copyright (c) 1991-1996 Silicon Graphics, Inc.<br>
>> > Marble Widget: 0.17.0 (stable version)<br>
>> > Parallelized PGF codec: No<br>
>> > Parallelized demosaicing: Yes<br>
>> > RawSpeed codec support: Yes<br>
>> > Database backend: QSQLITE<br>
>> > Kipi-Plugins: 3.5.0<br>
>> > LibKface: 3.0.0<br>
>> > LibKipi: 2.1.0<br>
>> > LibOpenCV: 2.4.6.1<br>
>> ><br>
>> ><br>
>> ><br>
>> > digikam(13284)/digikam (core) Digikam::DMetadata::getImageHistory:<br>
>> > Loading<br>
>> > image history ""<br>
>> > [Thread 0x7fffb6b02700 (LWP 13427) exited]<br>
>> > [Thread 0x7fff96c89700 (LWP 13428) exited]<br>
>> > [Thread 0x7fffb7677700 (LWP 13429) exited]<br>
>> ><br>
>> > Program received signal SIGSEGV, Segmentation fault.<br>
>> > 0x0000000000000000 in ?? ()<br>
>> > (gdb) bt<br>
>> > #0 0x0000000000000000 in ?? ()<br>
>> > #1 0x00007fffe096fa9e in ?? () from /usr/lib64/libsqlite3.so.0<br>
>> > #2 0x00007fffe096fe30 in ?? () from /usr/lib64/libsqlite3.so.0<br>
>> > #3 0x00007fffe0994bbd in ?? () from /usr/lib64/libsqlite3.so.0<br>
>> > #4 0x00007fffe099d6c5 in ?? () from /usr/lib64/libsqlite3.so.0<br>
>> > #5 0x00007fffe09a5ed6 in sqlite3_step () from<br>
>> > /usr/lib64/libsqlite3.so.0<br>
>> > #6 0x00007fffd4a52b4f in ?? () from<br>
>> > /usr/lib64/qt4/plugins/sqldrivers/libqsqlite.so<br>
>> > #7 0x00007fffd4a538ef in ?? () from<br>
>> > /usr/lib64/qt4/plugins/sqldrivers/libqsqlite.so<br>
>> > #8 0x00007ffff7bac687 in QSqlQuery::exec() () from<br>
>> > /usr/lib64/qt4/libQtSql.so.4<br>
>> > #9 0x00007ffff5511c86 in<br>
>> > Digikam::DatabaseCoreBackend::exec(Digikam::SqlQuery&) () from<br>
>> > /usr/lib64/libdigikamcore.so.3<br>
>> > #10 0x00007ffff5511d0c in<br>
>> > Digikam::DatabaseCoreBackend::execQuery(Digikam::SqlQuery&, QVariant<br>
>> > const&)<br>
>> > () from /usr/lib64/libdigikamcore.so.3<br>
>> > #11 0x00007ffff5512b80 in<br>
>> > Digikam::DatabaseCoreBackend::execQuery(QString<br>
>> > const&, QVariant const&) () from /usr/lib64/libdigikamcore.so.3<br>
>> > #12 0x00007ffff5512bc9 in Digikam::DatabaseCoreBackend::execSql(QString<br>
>> > const&, QVariant const&, QList<QVariant>*, QVariant*) () from<br>
>> > /usr/lib64/libdigikamcore.so.3<br>
>> > #13 0x00007ffff4e7fb6e in Digikam::AlbumDB::getSetting(QString const&)<br>
>> > ()<br>
>> > from /usr/lib64/libdigikamdatabase.so.3<br>
>> > #14 0x00007ffff4e804a9 in<br>
>> > Digikam::AlbumDB::getFilterSettings(QStringList*,<br>
>> > QStringList*, QStringList*) () from /usr/lib64/libdigikamdatabase.so.3<br>
>> > #15 0x000000000065f9a5 in ?? ()<br>
>> > #16 0x00000000005442e6 in ?? ()<br>
>> > #17 0x0000000000543c54 in ?? ()<br>
>> > #18 0x00007fff9415ae34 in ?? () from<br>
>> > /usr/lib64/kde4/kipiplugin_advancedslideshow.so<br>
>> > #19 0x00007ffff2b5b63f in QMetaObject::activate(QObject*, QMetaObject<br>
>> > const*, int, void**) () from /usr/lib64/qt4/libQtCore.so.4<br>
>> > #20 0x00007ffff5eb5012 in KIPI::Interface::currentAlbumChanged(bool) ()<br>
>> > from<br>
>> > /usr/lib64/libkipi.so.11<br>
>> > #21 0x00007ffff2b5b63f in QMetaObject::activate(QObject*, QMetaObject<br>
>> > const*, int, void**) () from /usr/lib64/qt4/libQtCore.so.4<br>
>> > #22 0x00000000005bb724 in ?? ()<br>
>> > #23 0x00000000005e39d5 in ?? ()<br>
>> > #24 0x00007ffff35bf75a in QWidget::event(QEvent*) () from<br>
>> > /usr/lib64/qt4/libQtGui.so.4<br>
>> > #25 0x00007ffff397925e in QFrame::event(QEvent*) () from<br>
>> > /usr/lib64/qt4/libQtGui.so.4<br>
>> > #26 0x00007ffff3a9086b in QAbstractItemView::viewportEvent(QEvent*) ()<br>
>> > from<br>
>> > /usr/lib64/qt4/libQtGui.so.4<br>
>> > #27 0x00007ffff3ad0816 in QTreeView::viewportEvent(QEvent*) () from<br>
>> > /usr/lib64/qt4/libQtGui.so.4<br>
>> > #28 0x00000000005dad40 in ?? ()<br>
>> > #29 0x00007ffff2b46f65 in<br>
>> > QCoreApplicationPrivate::sendThroughObjectEventFilters(QObject*,<br>
>> > QEvent*) ()<br>
>> > from /usr/lib64/qt4/libQtCore.so.4<br>
>> > #30 0x00007ffff3571b6c in QApplicationPrivate::notify_helper(QObject*,<br>
>> > QEvent*) () from /usr/lib64/qt4/libQtGui.so.4<br>
>> > #31 0x00007ffff3574e31 in QApplication::notify(QObject*, QEvent*) ()<br>
>> > from<br>
>> > /usr/lib64/qt4/libQtGui.so.4<br>
>> > #32 0x00007ffff42cf3aa in KApplication::notify(QObject*, QEvent*) ()<br>
>> > from<br>
>> > /usr/lib64/libkdeui.so.5<br>
>> > #33 0x00007ffff2b46ded in QCoreApplication::notifyInternal(QObject*,<br>
>> > QEvent*) () from /usr/lib64/qt4/libQtCore.so.4<br>
>> > #34 0x00007ffff3577ce2 in QApplicationPrivate::sendMouseEvent(QWidget*,<br>
>> > QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool)<br>
>> > ()<br>
>> > from /usr/lib64/qt4/libQtGui.so.4<br>
>> > #35 0x00007ffff35ebe9c in ?? () from /usr/lib64/qt4/libQtGui.so.4<br>
>> > #36 0x00007ffff35ea7e1 in QApplication::x11ProcessEvent(_XEvent*) ()<br>
>> > from<br>
>> > /usr/lib64/qt4/libQtGui.so.4<br>
>> > #37 0x00007ffff36133e2 in ?? () from /usr/lib64/qt4/libQtGui.so.4<br>
>> > #38 0x00007fffeaf5fdf4 in g_main_context_dispatch () from<br>
>> > /usr/lib64/libglib-2.0.so.0<br>
>> > #39 0x00007fffeaf60164 in ?? () from /usr/lib64/libglib-2.0.so.0<br>
>> > #40 0x00007fffeaf6022c in g_main_context_iteration () from<br>
>> > /usr/lib64/libglib-2.0.so.0<br>
>> > #41 0x00007ffff2b75884 in<br>
>> ><br>
>> > QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>)<br>
>> > () from /usr/lib64/qt4/libQtCore.so.4<br>
>> > #42 0x00007ffff36134c6 in ?? () from /usr/lib64/qt4/libQtGui.so.4<br>
>> > #43 0x00007ffff2b45a2f in<br>
>> > QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from<br>
>> > /usr/lib64/qt4/libQtCore.so.4<br>
>> > #44 0x00007ffff2b45d10 in<br>
>> > QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from<br>
>> > /usr/lib64/qt4/libQtCore.so.4<br>
>> > #45 0x00007ffff2b4afc8 in QCoreApplication::exec() () from<br>
>> > /usr/lib64/qt4/libQtCore.so.4<br>
>> > #46 0x0000000000497a3c in ?? ()<br>
>> > #47 0x00007ffff1b9bb8d in __libc_start_main () from /lib64/libc.so.6<br>
>> > #48 0x000000000049a151 in _start ()<br>
>> > (gdb) quit<br>
>> > A debugging session is active.<br>
>> ><br>
>> > Inferior 1 [process 13284] will be killed.<br>
>> ><br>
>> ><br>
>> > _______________________________________________<br>
>> > Digikam-users mailing list<br>
>> > <a href="mailto:Digikam-users@kde.org">Digikam-users@kde.org</a><br>
>> > <a href="https://mail.kde.org/mailman/listinfo/digikam-users" target="_blank">https://mail.kde.org/mailman/listinfo/digikam-users</a><br>
>> ><br>
>> _______________________________________________<br>
>> Digikam-users mailing list<br>
>> <a href="mailto:Digikam-users@kde.org">Digikam-users@kde.org</a><br>
>> <a href="https://mail.kde.org/mailman/listinfo/digikam-users" target="_blank">https://mail.kde.org/mailman/listinfo/digikam-users</a><br>
><br>
><br>
><br>
> _______________________________________________<br>
> Digikam-users mailing list<br>
> <a href="mailto:Digikam-users@kde.org">Digikam-users@kde.org</a><br>
> <a href="https://mail.kde.org/mailman/listinfo/digikam-users" target="_blank">https://mail.kde.org/mailman/listinfo/digikam-users</a><br>
><br>
_______________________________________________<br>
Digikam-users mailing list<br>
<a href="mailto:Digikam-users@kde.org">Digikam-users@kde.org</a><br>
<a href="https://mail.kde.org/mailman/listinfo/digikam-users" target="_blank">https://mail.kde.org/mailman/listinfo/digikam-users</a><br>
</div></div></blockquote></div><br></div>