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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via gitlab.com by Unknown author, 1 year ago
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
via Stack Overflow by Sanjana Nair
, 2 years ago
near "desc": syntax error (code 1): , while compiling: SELECT * FROM UnMappText WHERE updateTime = '0' desc LIMIT 0, 500
via Stack Overflow by Kartikeya Garg
, 1 year ago
near "=": syntax error (code 1): , while compiling: SELECT * FROM RegisterWHERE phone= 7839477904
via GitHub by jasonkliu
, 2 years ago
unrecognized token: "'20150100 AND NumericalDate < 20150199) ;" (code 1): , while compiling: select * from events where Category = 1 AND ( NumericalDate > '20150100 AND NumericalDate < 20150199) ;
via Stack Overflow by alphasigmakappa
, 2 years ago
no such table: past (code 1): , while compiling: select * from past
via grman.at by Unknown author, 1 year ago
no such table: <TABLE> (code 1): , while compiling: SELECT <column list> FROM <TABLE>
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.(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)
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 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)

Users with the same issue

Samebug visitor profile picture
Unknown user
2 times, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
2 times, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
110 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.