Bug 485635

Summary:	Firefox 3.x needs sqlite fts3 module for some extensions to work
Product:	[Fedora] Fedora	Reporter:	Chris Nolan <chris>
Component:	sqlite	Assignee:	Panu Matilainen <pmatilai>
Status:	CLOSED WORKSFORME	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	low	Docs Contact:
Priority:	low
Version:	10	CC:	john.brown009, mmcgrath, pmatilai
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2009-10-31 10:46:35 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Chris Nolan 2009-02-15 18:11:52 UTC

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):

sqlite-3.5.9-3.fc10.x86_64
firefox-3.0.6-1.fc10.x86_64

How reproducible:

Always.

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".
  
Actual results:

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.

Expected results:

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! 

Additional info:

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.

See also: 

http://bugs.archlinux.org/task/10968
http://brief.mozdev.org/drupal/node/233
http://brief.mozdev.org/drupal/node/207
http://brief.mozdev.org/drupal/node/317

Comment 1 Chris Nolan 2009-02-19 18:27:19 UTC

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.

Comment 2 TK009 2009-10-30 19:21:39 UTC

I can not reproduce this problem in F11.

@Chris

Are you still able to reproduce the error? Can you try it in F11 or rawhide if you're still seeing it in F10?

Comment 3 Chris Nolan 2009-10-31 10:29:05 UTC

Hi John

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.

Thanks
Chris

Comment 4 TK009 2009-10-31 10:46:35 UTC

@Chris

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.

TK009
---

Fedora Bugzappers volunteer triage team
https://fedoraproject.org/wiki/BugZappers