{"action":"created","issue":{"url":"https://api.github.com/repos/couchbase/couchbase-lite-android/issues/434","labels_url":"https://api.github.com/repos/couchbase/couchbase-lite-android/issues/434/labels{/name}","comments_url":"https://api.github.com/repos/couchbase/couchbase-lite-android/issues/434/comments","events_url":"https://api.github.com/repos/couchbase/couchbase-lite-android/issues/434/events","html_url":"https://github.com/couchbase/couchbase-lite-android/issues/434","id":46416008,"number":434,"title":"`SQLiteException: no such collation sequence: JSON` on Barnes & Noble NOOK HD/HD+","user":{"login":"Takhion","id":2116164,"avatar_url":"https://avatars.githubusercontent.com/u/2116164?v=3","gravatar_id":"","url":"https://api.github.com/users/Takhion","html_url":"https://github.com/Takhion","followers_url":"https://api.github.com/users/Takhion/followers","following_url":"https://api.github.com/users/Takhion/following{/other_user}","gists_url":"https://api.github.com/users/Takhion/gists{/gist_id}","starred_url":"https://api.github.com/users/Takhion/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Takhion/subscriptions","organizations_url":"https://api.github.com/users/Takhion/orgs","repos_url":"https://api.github.com/users/Takhion/repos","events_url":"https://api.github.com/users/Takhion/events{/privacy}","received_events_url":"https://api.github.com/users/Takhion/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/couchbase/couchbase-lite-android/labels/bug","name":"bug","color":"e11d21"},{"url":"https://api.github.com/repos/couchbase/couchbase-lite-android/labels/S1:%20showstopper","name":"S1: showstopper","color":"e11d21"},{"url":"https://api.github.com/repos/couchbase/couchbase-lite-android/labels/S4:%20minor","name":"S4: minor","color":"bfd4f2"},{"url":"https://api.github.com/repos/couchbase/couchbase-lite-android/labels/size-medium","name":"size-medium","color":"fad8c7"},{"url":"https://api.github.com/repos/couchbase/couchbase-lite-android/labels/testneeded","name":"testneeded","color":"5319e7"},{"url":"https://api.github.com/repos/couchbase/couchbase-lite-android/labels/waffle:backlog","name":"waffle:backlog","color":"ededed"}],"state":"open","locked":false,"assignee":{"login":"hideki","id":15889,"avatar_url":"https://avatars.githubusercontent.com/u/15889?v=3","gravatar_id":"","url":"https://api.github.com/users/hideki","html_url":"https://github.com/hideki","followers_url":"https://api.github.com/users/hideki/followers","following_url":"https://api.github.com/users/hideki/following{/other_user}","gists_url":"https://api.github.com/users/hideki/gists{/gist_id}","starred_url":"https://api.github.com/users/hideki/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hideki/subscriptions","organizations_url":"https://api.github.com/users/hideki/orgs","repos_url":"https://api.github.com/users/hideki/repos","events_url":"https://api.github.com/users/hideki/events{/privacy}","received_events_url":"https://api.github.com/users/hideki/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/couchbase/couchbase-lite-android/milestones/12","html_url":"https://github.com/couchbase/couchbase-lite-android/milestones/1.2.0","labels_url":"https://api.github.com/repos/couchbase/couchbase-lite-android/milestones/12/labels","id":771936,"number":12,"title":"1.2.0","description":"* Adding enhancement features, such as:\r\n* ForestDB\r\n* Security\r\n* Model class","creator":{"login":"jessliu","id":4998909,"avatar_url":"https://avatars.githubusercontent.com/u/4998909?v=3","gravatar_id":"","url":"https://api.github.com/users/jessliu","html_url":"https://github.com/jessliu","followers_url":"https://api.github.com/users/jessliu/followers","following_url":"https://api.github.com/users/jessliu/following{/other_user}","gists_url":"https://api.github.com/users/jessliu/gists{/gist_id}","starred_url":"https://api.github.com/users/jessliu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jessliu/subscriptions","organizations_url":"https://api.github.com/users/jessliu/orgs","repos_url":"https://api.github.com/users/jessliu/repos","events_url":"https://api.github.com/users/jessliu/events{/privacy}","received_events_url":"https://api.github.com/users/jessliu/received_events","type":"User","site_admin":false},"open_issues":6,"closed_issues":6,"state":"open","created_at":"2014-08-29T17:08:18Z","updated_at":"2015-08-04T18:40:43Z","due_on":null,"closed_at":null},"comments":22,"created_at":"2014-10-21T16:40:54Z","updated_at":"2015-08-06T20:26:53Z","closed_at":null,"body":"Observed this one through (a lot of) crash reports, seems to target only these devices by producer \"BN LLC\" (Barnes & Noble):\r\n* BNTV400 (NOOK HD) on 4.0.4\r\n* BNTV600 (NOOK HD+) on 4.0.4\r\n\r\nStacktrace:\r\n```\r\nandroid.database.sqlite.SQLiteException: no such collation sequence: JSON: , while compiling: SELECT key, value, docid, revs.sequence, revid, json FROM maps, revs, docs WHERE maps.view_id=? AND key in (?) AND revs.sequence = maps.sequence AND docs.doc_id = revs.doc_id ORDER BY key LIMIT ? OFFSET ?\r\n\tat android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)\r\n\tat android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68)\r\n\tat android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:143)\r\n\tat android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361)\r\n\tat android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:127)\r\n\tat android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:94)\r\n\tat android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:53)\r\n\tat android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:47)\r\n\tat android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1564)\r\n\tat android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1538)\r\n\tat com.couchbase.lite.android.AndroidSQLiteStorageEngine.rawQuery(SourceFile:111)\r\n\tat com.couchbase.lite.View.resultSetWithOptions(SourceFile:685)\r\n\tat com.couchbase.lite.View.queryWithOptions(SourceFile:852)\r\n\tat com.couchbase.lite.Database.queryViewNamed(SourceFile:2062)\r\n\tat com.couchbase.lite.Query$1.run(SourceFile:403)\r\n    ...\r\n```"},"comment":{"url":"https://api.github.com/repos/couchbase/couchbase-lite-android/issues/comments/128497945","html_url":"https://github.com/couchbase/couchbase-lite-android/issues/434#issuecomment-128497945","issue_url":"https://api.github.com/repos/couchbase/couchbase-lite-android/issues/434","id":128497945,"user":{"login":"hideki","id":15889,"avatar_url":"https://avatars.githubusercontent.com/u/15889?v=3","gravatar_id":"","url":"https://api.github.com/users/hideki","html_url":"https://github.com/hideki","followers_url":"https://api.github.com/users/hideki/followers","following_url":"https://api.github.com/users/hideki/following{/other_user}","gists_url":"https://api.github.com/users/hideki/gists{/gist_id}","starred_url":"https://api.github.com/users/hideki/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hideki/subscriptions","organizations_url":"https://api.github.com/users/hideki/orgs","repos_url":"https://api.github.com/users/hideki/repos","events_url":"https://api.github.com/users/hideki/events{/privacy}","received_events_url":"https://api.github.com/users/hideki/received_events","type":"User","site_admin":false},"created_at":"2015-08-06T20:26:53Z","updated_at":"2015-08-06T20:26:53Z","body":"Hi @drspaceboo,\r\nWe have Samsung S3 which OS version is Android 4.1.2.\r\nI run the simple test with S3. However I could not reproduce the issue.\r\nCan you check Android OS versions that causes this issue?\r\nThanks!"}}