FS#10968 - Firefox 3 miss sqlite fts3 module: causes errors on some extensions

Attached to Project: Arch Linux
Opened by Fabio Varesano (fax8) - Monday, 21 July 2008, 02:51 GMT
Last edited by Andreas Radke (AndyRTR) - Tuesday, 30 December 2008, 11:34 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To Jan de Groot (JGC)
Andreas Radke (AndyRTR)
Architecture i686
Severity Medium
Priority Normal
Reported Version None
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 1
Private No

Details

Description:
Seems that Firefox firefox 3.0.1-1 is missing the sqlite fts3 module.

More informations at http://brief.mozdev.org/drupal/node/233 and http://brief.mozdev.org/drupal/node/207
Seems that other distributions are having this issue too.

Default FF package shipped by Mozilla have the sqlite fts3 module enabled so Archilinux should have it enabled too.


Additional info:
* package version(s) firefox 3.0.1-1
* config and/or log files etc.


Steps to reproduce:
Install the Brief 1.2 extension then check firefox Error Console. it will displays:

Brief:
SQL statement: CREATE VIRTUAL TABLE entries_text USING fts3 (title TEXT, content TEXT, authors TEXT, tags TEXT )

Error: [Exception... "'Error: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL] Stack: undefined Database error: no such module: fts3' when calling method: [nsIObserver::observe]" nsresult: "0x8057001c (NS_ERROR_XPC_JS_THREW_JS_OBJECT)" location: "" data: no]
This task depends upon

Closed by  Andreas Radke (AndyRTR)
Tuesday, 30 December 2008, 11:34 GMT
Reason for closing:  Fixed
Comment by Fabio Varesano (fax8) - Tuesday, 23 December 2008, 03:45 GMT
  • Field changed: Percent Complete (100% → 0%)
Seems that this bug is again present with xulrunner 1.9.0.5-1 and firefox 3.0.5-1.
Comment by Jan de Groot (JGC) - Tuesday, 23 December 2008, 12:57 GMT
Andy, can we get this enabled in our sqlite build? I don't like to build xulrunner with internal sqlite, because that pulls in two copies of sqlite in each running process that utilizes xulrunner: one static compiled version into xulrunner, and the dynamic version in nss.
Comment by Jan Hradek (jan.hradek) - Tuesday, 23 December 2008, 17:30 GMT
To make things easier : this little diff of PKGBUILD did the magic for me (ie. brief now works):

--- PKGBUILD.old 2008-12-23 18:27:05.000000000 +0100
+++ PKGBUILD 2008-12-23 18:17:27.000000000 +0100
@@ -21,7 +21,7 @@

build() {
cd ${srcdir}/sqlite-${pkgver}
- ./configure --prefix=/usr --enable-threadsafe --disable-static || return 1
+ CFLAGS="-DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_COLUMN_METADATA=1" ./configure --prefix=/usr --enable-threadsafe --disable-static || return 1
make || return 1
make DESTDIR=${pkgdir} install
install -Dm0644 sqlite3.1 ${pkgdir}/usr/share/man/man1/sqlite3.1

Regards,
Comment by Fabio Varesano (fax8) - Sunday, 28 December 2008, 13:11 GMT
seems that the diff above didn't work for me. did you make any other modification?
Comment by Fabio Varesano (fax8) - Sunday, 28 December 2008, 13:36 GMT
The attached patch to the PKGBUILD revision 21929 worked for me.

I used the same options Jan Hradek used but I put them as options to the configure script.

Now brief works correctly using the linked sqlite3.
I can't guarantee that this change does not break other packages .. I doubt tough.
   sqlite3_enable_fts3.patch (0.2 KiB)
Comment by Fabio Varesano (fax8) - Sunday, 28 December 2008, 13:37 GMT
Ops.. patch recreated with "diff -u .."
   sqlite3_enable_fts3.patch (0.5 KiB)

Loading...