For some time now thunderbird searches dont work. Usually I build my own ports, but I tried with the very latest thunderbird (thunderbird-52.5.2) installed with pkg install and the issue persists. I reported the issue with mozilla at: https://bugzilla.mozilla.org/show_bug.cgi?id=1426632 They believe its a FreeBSD build issue. When I try a search a new blank search panel opens, there are no search results. The console logged the following error: TypeError: nounDef is undefined -- Exception object -- * -- Stack Trace -- gloda_ns_newQuery@resource:///modules/gloda/gloda.js:1901:5 GlodaMsgSearcher_buildFulltextQuery@resource:///modules/gloda/msg_search.js:260:17 GlodaMsgSearcher_getCollection@resource:///modules/gloda/msg_search.js:306:18 glodaFacetTabType_openTab@chrome://messenger/content/glodaFacetTab.js:50:25 openTab@chrome://messenger/content/tabmail.xml:565:11 doSearch@chrome://messenger/content/search.xml:248:15 Note that I tried deleting my email account and setting it up from scratch (deleted ~/.thunderbird) and the error persists. Thunderbird running on OS X (same email account) doe snot have this issue
Check if FTS3_TOKEN=on in databases/sqlite3.
I did not have that setting. Rebuilding databases/sqlite3 with that option fixes the problem. I also see that that option is on by default, I'm not sure why my build doesn't have it (My install is years old ...). It would be nice if the thunderbird build failed at build time when sqlite doesn't have the necessary functionality compiled in, but I guess it doesn't affect a lot of people. Thanks very much for your help.
If it is solved, please close the PR.
*** This bug has been marked as a duplicate of bug 208500 ***