Red Hat Bugzilla – Bug 485635
Firefox 3.x needs sqlite fts3 module for some extensions to work
Last modified: 2009-10-31 06:46:35 EDT
Description of problem:
Firefox needs the sqlite fts3 module in order for some extensions to work. The mozilla build of firefox includes this sqlite module but the fedora build of sqlite does not.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Install Firefox 3.0.x
2. Install addon "Brief" (for example) https://addons.mozilla.org/en-US/firefox/addon/4578
3. Start firefox and try adding feeds to "Brief".
Feeds can be added, but only 1 story is fetched from each feed with each "refresh". Feeds show no content - i.e. feeds don't show in the main window when selected. Firefox error console shows a load of sql errors.
All RSS feed stories should be fetched with each "refresh" of Brief. When a feed is selected the stories for that feed should be displayed in the main window. There shouldn't be any sql errors in the error console!
Fix is trivial. Just add "-DSQLITE_ENABLE_FTS3=1" to CFLAGS. For example, change sqlite.spec to read:
export CFLAGS="$RPM_OPT_FLAGS -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_DISABLE_DIRSYNC=1 -Wall"
Rebuild RPM, install it, remove brief.sqlite and restart Firefox. Problem fixed.
New sqlite pushed to F-10 updates (sqlite-3.5.9-4.fc10) doesn't appear to address this issue. It's a trivial fix and would be most welcomed here.
I can not reproduce this problem in F11.
Are you still able to reproduce the error? Can you try it in F11 or rawhide if you're still seeing it in F10?
The particular addon I was trying to get working ("Brief") works fine now in F11 and Firefox 3.5.3. It's hard to say whether the addon was altered or whether this bug has been addressed in the current builds of Firefox. Whichever, it appears this is no longer an issue for me.
I was using brief about a month back with no issues, tried it again yesterday, no problems.
I am going assume this issue is resolved and close this report. If this is incorrect or you see the problem again please re-open this report and change the version. Thank you for the quick response.
report set to CLOSED - WORKSFORME | tested in F11.
Fedora Bugzappers volunteer triage team