Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines
Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.
REPEAT: Do NOT report bugs for outdated packages!
https://wiki.archlinux.org/title/Bug_reporting_guidelines
Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.
REPEAT: Do NOT report bugs for outdated packages!
FS#35330 - [sqlitebrowser] Link with system sqlite library
Attached to Project:
Community Packages
Opened by Linas (Linas) - Thursday, 16 May 2013, 22:17 GMT
Last edited by Sergej Pupykin (sergej) - Friday, 17 May 2013, 10:18 GMT
Opened by Linas (Linas) - Thursday, 16 May 2013, 22:17 GMT
Last edited by Sergej Pupykin (sergej) - Friday, 17 May 2013, 10:18 GMT
|
DetailsWhen trying to open ~/.cache/tracker/meta.db with sqlitebrowser, it was failing showing in the cli:
could not get list of tables: 26, file is encrypted or is not a database The reason was that sqlitebrowser is bundled with an old sqlite version (3.6.18, 2009-09-11). IMHO it should be linked with sqlite library. The sqlite package (version 3.7.16.2, 2013-04-12) has no problem opening that db. And after recompiling sqlitebrowser, neither does sqlitebrowser :) I attach a patch to the PKGBUILD. The needed changes to the source were: sed -i '/sqlite_source/sqlite3.h/d' sqlbrowser_util.c # Remove two useless #include sed -i 's/"sqlite_source/sqlite3.h"/<sqlite3.h>/' sqlbrowser_util.h sed -i -e '1i LIBS += -lsqlite3' -e '/sqlite_source/d' sqlitebrowser.pro Also: -Add 'sqlite' to depends -It depends on qt4, but qt4 now provides qmake-qt4 binary, not qmake -The -ldl is no longer needed (the reason was sqlite_source/sqlite3.c calling dlclose, but that file is no longer compiled) |
This task depends upon
sqlitebrowser-libsqlite.patch