Your message dated Mon, 07 Nov 2011 22:50:04 +0100
with message-id <1320702604.22458.195.ca...@julia.gcs.org.hu>
and subject line sqlite3 FTS3 support is available again in 3.7.9-2
has caused the Debian Bug report #647933,
regarding libsqlite3-0: Missing FTS3 Support
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
647933: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=647933
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
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 \
--- End Message ---
--- Begin Message ---
Package: sqlite3
Version: 3.7.9-2
Package building flags, like CFLAGS were not exported automatically
anymore, do it explicitly.
--- End Message ---
