Description of problem: After upgrading to Fedora 24, geary started to behave erratically and to crash. I removed all files in .local/share/geary, to get a clean configuration, and, when I tried to create a mail account, I got this message. ** (geary:2193): ERROR **: imap-db-database.vala:247: Error creating search table: (Connection.exec /home/eris/.local/share/geary/ernesto.manriquez/geary.db) [err=1] - unknown tokenizer: unicodesn ( CREATE VIRTUAL TABLE MessageSearchTable USING fts4( body, attachment, subject, from_field, receivers, cc, bcc, tokenize=unicodesn "stemmer=spanish", prefix="2,4,6,8,10", ); ) Trace/breakpoint trap (`core' generado) I don't get this error message under Fedora 23. I tried to downgrade Geary to no avail, so, I think this error could be some misconfiguration with sqlite3, or some missing patch in Geary needed to work with the sqlite3 version provided in Fedora 24. How reproducible: All the time. Steps to reproduce. 1. Install Geary. 2. Try to create a mail account. Actual results: The referred error message. After that, if you try to start Geary, Geary simply refuses to start, and keeps in a loop of "Geary is updating" Expected results: I can access my mail accounts, just like I did in Fedora 23.
If I install sqlite-3.11.0-3.fc23 over my Fedora 24 install, the problem goes away. The FTS3 tokenizer needs to be enabled in SQLite for this to work. bug 1312506
Geary 0.11 can enable FTS3 with the runtime method introduced in SQLite 3.12, but SQLite 3.11 requires compilation with the FTS3 tokenizer. https://mail.gnome.org/archives/commits-list/2016-April/msg07576.html
sqlite 3.12.2 hasn't fixed the problem.
I can confirm this. Hope it will be fixed soon. Ernesto, thanks for a working solution!
Downgrading to sqlite-3.11.0-3.fc24.x86_64 did not solve the problem.
If I understand things right, this can be fixed by either: - pushing a fixed sqlite 3.11 to F24, or - pushing sqlite 3.12 to F24 *and* building geary against that As sqlite 3.12 is already in testing and will be pushed soon I'll go for the second option (and update to geary 0.11.1).
geary-0.11.1-1.fc23 has been submitted as an update to Fedora 23. https://bodhi.fedoraproject.org/updates/FEDORA-2016-7a2fb3caf1
geary-0.11.1-2.fc24 has been submitted as an update to Fedora 24. https://bodhi.fedoraproject.org/updates/FEDORA-2016-0a39e9f457
geary-0.11.1-2.fc24 has been pushed to the Fedora 24 testing repository. If problems still persist, please make note of it in this bug report. See https://fedoraproject.org/wiki/QA:Updates_Testing for instructions on how to install test updates. You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2016-0a39e9f457
geary-0.11.1-1.fc23 has been pushed to the Fedora 23 testing repository. If problems still persist, please make note of it in this bug report. See https://fedoraproject.org/wiki/QA:Updates_Testing for instructions on how to install test updates. You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2016-7a2fb3caf1
geary-0.11.1-2.fc24 has been pushed to the Fedora 24 stable repository. If problems still persist, please make note of it in this bug report.
geary-0.11.1-1.fc23 has been pushed to the Fedora 23 stable repository. If problems still persist, please make note of it in this bug report.