Community Packages

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

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
Task Type Bug Report
Category Packages
Status Closed
Assigned To Sergej Pupykin (sergej)
Architecture All
Severity Low
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

When 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

Closed by  Sergej Pupykin (sergej)
Friday, 17 May 2013, 10:18 GMT
Reason for closing:  Fixed

Loading...