Crash when pressing spacebar as the first key when searching
Reported via ACRA, really easy to reproduce.
USER_COMMENT=Pressing spacebar as the first key when searching crashes immediately.
ANDROID_VERSION=6.0
APP_VERSION_NAME=0.98
BRAND=google
PHONE_MODEL=Nexus 5
CUSTOM_DATA=
STACK_TRACE=java.lang.RuntimeException: An error occured while executing doInBackground()
at android.support.v4.content.ModernAsyncTask$3.done(ModernAsyncTask.java:137)
at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:354)
at java.util.concurrent.FutureTask.setException(FutureTask.java:223)
at java.util.concurrent.FutureTask.run(FutureTask.java:242)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1113)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:588)
at java.lang.Thread.run(Thread.java:818)
Caused by: android.database.sqlite.SQLiteException: near ")": syntax error (code 1): , while compiling: SELECT fdroid_app.rowid as _id,fdroid_app.id,fdroid_app.name,fdroid_app.summary,fdroid_app.compatible,fdroid_app.license,fdroid_app.icon,fdroid_app.iconUrl,installed.versionCode AS installedVersionCode,installed.versionName AS installedVersionName,suggestedApk.version AS suggestedApkVersion,fdroid_app.suggestedVercode,fdroid_app.ignoreAllUpdates,fdroid_app.ignoreThisUpdate,fdroid_app.requirements FROM fdroid_app LEFT JOIN fdroid_apk ON ( fdroid_apk.id = fdroid_app.id ) LEFT JOIN fdroid_repo ON ( fdroid_apk.repo = fdroid_repo._id ) LEFT JOIN fdroid_installedApp AS installed ON (installed.appId = fdroid_app.id) LEFT JOIN fdroid_apk AS suggestedApk ON (fdroid_app.suggestedVercode = suggestedApk.vercode AND fdroid_app.id = suggestedApk.id) WHERE (() OR () OR () OR () ) AND ( fdroid_repo.isSwap = 0 OR fdroid_repo.isSwap is null ) GROUP BY fdroid_app.id ORDER BY fdroid_app.name COLLATE LOCALIZED
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:887)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:498)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)
at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1255)
at org.fdroid.fdroid.data.AppProvider.query(AppProvider.java:825)
at android.content.ContentProvider.query(ContentProvider.java:1017)
at android.content.ContentProvider$Transport.query(ContentProvider.java:238)
at android.content.ContentResolver.query(ContentResolver.java:491)
at android.content.ContentResolver.query(ContentResolver.java:434)
at android.support.v4.content.CursorLoader.loadInBackground(CursorLoader.java:49)
at android.support.v4.content.CursorLoader.loadInBackground(CursorLoader.java:35)
at android.support.v4.content.AsyncTaskLoader.onLoadInBackground(AsyncTaskLoader.java:242)
at android.support.v4.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:51)
at android.support.v4.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:40)
at android.support.v4.content.ModernAsyncTask$2.call(ModernAsyncTask.java:123)
at java.util.concurrent.FutureTask.run(FutureTask.java:237)
... 3 more
android.database.sqlite.SQLiteException: near ")": syntax error (code 1): , while compiling: SELECT fdroid_app.rowid as _id,fdroid_app.id,fdroid_app.name,fdroid_app.summary,fdroid_app.compatible,fdroid_app.license,fdroid_app.icon,fdroid_app.iconUrl,installed.versionCode AS installedVersionCode,installed.versionName AS installedVersionName,suggestedApk.version AS suggestedApkVersion,fdroid_app.suggestedVercode,fdroid_app.ignoreAllUpdates,fdroid_app.ignoreThisUpdate,fdroid_app.requirements FROM fdroid_app LEFT JOIN fdroid_apk ON ( fdroid_apk.id = fdroid_app.id ) LEFT JOIN fdroid_repo ON ( fdroid_apk.repo = fdroid_repo._id ) LEFT JOIN fdroid_installedApp AS installed ON (installed.appId = fdroid_app.id) LEFT JOIN fdroid_apk AS suggestedApk ON (fdroid_app.suggestedVercode = suggestedApk.vercode AND fdroid_app.id = suggestedApk.id) WHERE (() OR () OR () OR () ) AND ( fdroid_repo.isSwap = 0 OR fdroid_repo.isSwap is null ) GROUP BY fdroid_app.id ORDER BY fdroid_app.name COLLATE LOCALIZED
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:887)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:498)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)
at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1255)
at org.fdroid.fdroid.data.AppProvider.query(AppProvider.java:825)
at android.content.ContentProvider.query(ContentProvider.java:1017)
at android.content.ContentProvider$Transport.query(ContentProvider.java:238)
at android.content.ContentResolver.query(ContentResolver.java:491)
at android.content.ContentResolver.query(ContentResolver.java:434)
at android.support.v4.content.CursorLoader.loadInBackground(CursorLoader.java:49)
at android.support.v4.content.CursorLoader.loadInBackground(CursorLoader.java:35)
at android.support.v4.content.AsyncTaskLoader.onLoadInBackground(AsyncTaskLoader.java:242)
at android.support.v4.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:51)
at android.support.v4.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:40)
at android.support.v4.content.ModernAsyncTask$2.call(ModernAsyncTask.java:123)
at java.util.concurrent.FutureTask.run(FutureTask.java:237)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1113)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:588)
at java.lang.Thread.run(Thread.java:818)