Package: libsqlite3-0 Version: 3.7.9-1 Severity: critical Tags: patch Justification: breaks unrelated software
Since the update of libsqlite3-0 3.7.8-1 -> 3.7.9-1 the program "hamster- applet" 2.91.3+git20110714.9aefd7-2 does not work properly any more. An investigation revealed that hamster complained OperationalError: no such module: fts3 every time the OK button in the edit dialog for activities was pressed and the entered data was not saved and the dialog stayed open. As it seems, hamster uses the Full Text Search feature of SQLite http://www.sqlite.org/fts3.html which is not compiled by default. It has to be enabled by calling ./configure with CPPFLAGS="-DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS" ./configure <configure options> (see http://www.sqlite.org/fts3.html#section_2). It seems this was droped from 3.7.8-1 to 3.7.9. Please find attached a patch which adds this variable to debian/rules. After recompiling the library, the program "hamster" works like a charm. -- System Information: Debian Release: wheezy/sid APT prefers unstable APT policy: (500, 'unstable'), (1, 'experimental') Architecture: amd64 (x86_64) Kernel: Linux 3.0.0-2-amd64 (SMP w/8 CPU cores) Locale: LANG=de_AT.utf8, LC_CTYPE=de_AT.utf8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages libsqlite3-0 depends on: ii libc6 2.13-21 libsqlite3-0 recommends no packages. libsqlite3-0 suggests no packages. -- no debconf information
--- rules.old 2011-11-07 21:42:31.637210319 +0100 +++ rules 2011-11-07 21:37:34.021210791 +0100 @@ -33,7 +33,7 @@ configure-stamp: dh_testdir autoconf - ./configure --prefix=/usr --mandir="/usr/share/man" \ + CPPFLAGS="-DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS" ./configure --prefix=/usr --mandir="/usr/share/man" \ $(confflags) --enable-threadsafe \ --enable-load-extension \ TCLLIBDIR=/usr/lib/tcltk/sqlite3 \