{"action":"created","issue":{"url":"https://api.github.com/repos/clementine-player/Clementine/issues/5278","repository_url":"https://api.github.com/repos/clementine-player/Clementine","labels_url":"https://api.github.com/repos/clementine-player/Clementine/issues/5278/labels{/name}","comments_url":"https://api.github.com/repos/clementine-player/Clementine/issues/5278/comments","events_url":"https://api.github.com/repos/clementine-player/Clementine/issues/5278/events","html_url":"https://github.com/clementine-player/Clementine/issues/5278","id":138845841,"number":5278,"title":"SQLite says there is no tokenizer=unicode","user":{"login":"tureba","id":124199,"avatar_url":"https://avatars.githubusercontent.com/u/124199?v=3","gravatar_id":"","url":"https://api.github.com/users/tureba","html_url":"https://github.com/tureba","followers_url":"https://api.github.com/users/tureba/followers","following_url":"https://api.github.com/users/tureba/following{/other_user}","gists_url":"https://api.github.com/users/tureba/gists{/gist_id}","starred_url":"https://api.github.com/users/tureba/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tureba/subscriptions","organizations_url":"https://api.github.com/users/tureba/orgs","repos_url":"https://api.github.com/users/tureba/repos","events_url":"https://api.github.com/users/tureba/events{/privacy}","received_events_url":"https://api.github.com/users/tureba/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2016-03-06T22:35:50Z","updated_at":"2016-08-05T12:11:27Z","closed_at":"2016-03-07T11:39:32Z","body":"Hi,\r\n\r\nI get the following when launching Clementine (branch release-1.3) from the command line:\r\n\r\n> 18:28:16.769 WARN  Database:274                     Couldn't register FTS3 tokenizer \r\n> 18:28:16.771 DEBUG Database:444                     Applying database schema update 13 from \":/schema/schema-13.sql\" \r\n> 18:28:16.772 ERROR Database:573                     db error:  QSqlError(1, \"No foi possvel obter a linha\", \"**unknown tokenizer: unicode**\") \r\n> 18:28:16.772 ERROR Database:574                     faulty query:  \"CREATE VIRTUAL TABLE songs_fts USING fts3(\r\n>   ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer, ftsgenre, ftscomment,\r\n>   **tokenize=unicode**\r\n> )\" \r\n> 18:28:16.772 ERROR Database:575                     bound values:  QMap() \r\n> 18:28:16.772 ERROR unknown                          Unable to update music library database\r\n> \r\n\r\nI have SQLite 3.11.0 installed. According to the SQLite docs (even much older ones), it should probably be **unicode61** instead:\r\n\r\n> [...]\r\n> USING fts3(\r\n>   ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer, ftsgenre, ftscomment,\r\n>   **tokenize=unicode61**\r\n> )\" \r\n\r\nRecompiling Clementine with that change in place on every schema file of the source tree made Clementine start perfectly.\r\n\r\nCheers,\r\nArthur"},"comment":{"url":"https://api.github.com/repos/clementine-player/Clementine/issues/comments/237834754","html_url":"https://github.com/clementine-player/Clementine/issues/5278#issuecomment-237834754","issue_url":"https://api.github.com/repos/clementine-player/Clementine/issues/5278","id":237834754,"user":{"login":"davidgfnet","id":3145339,"avatar_url":"https://avatars.githubusercontent.com/u/3145339?v=3","gravatar_id":"","url":"https://api.github.com/users/davidgfnet","html_url":"https://github.com/davidgfnet","followers_url":"https://api.github.com/users/davidgfnet/followers","following_url":"https://api.github.com/users/davidgfnet/following{/other_user}","gists_url":"https://api.github.com/users/davidgfnet/gists{/gist_id}","starred_url":"https://api.github.com/users/davidgfnet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidgfnet/subscriptions","organizations_url":"https://api.github.com/users/davidgfnet/orgs","repos_url":"https://api.github.com/users/davidgfnet/repos","events_url":"https://api.github.com/users/davidgfnet/events{/privacy}","received_events_url":"https://api.github.com/users/davidgfnet/received_events","type":"User","site_admin":false},"created_at":"2016-08-05T12:11:27Z","updated_at":"2016-08-05T12:11:27Z","body":"How did you fix it? I just build the thing as before, no weird flags or anything, but it doesn't work.\r\nIs it cause my system sqlite3 is missing the FTS3? I moved to fedora 24 and it used to work for 23. Do I need to download, build and install sqlite3 myself? I thought clementine would do that for me or something. Thanks!"}}
{"actor":{"display_login":"davidgfnet"}}