android.database.sqlite.SQLiteException: near "DESC": syntax error (code 1): , while compiling: DELETE FROM people_email_followers WHERE local_blog_id=?1 AND person_id IN (SELECT person_id FROM people_email_followers WHERE local_blog_id=?1 DESC LIMIT ?2) ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (near "DESC": syntax error (code 1): , while compiling: DELETE FROM people_email_followers WHERE local_blog_id=?1 AND person_id IN (SELECT person_id FROM people_email_followers WHERE local_blog_id=?1 DESC LIMIT ?2)) #################################################################


Solutions on the web

Solution icon of github
) ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (near "DESC": syntax error (code 1): , while compiling: DELETE FROM people_email_followers WHERE local_blog_id=?1 AND person_id IN (SELECT

Solution icon of stackoverflow
via Stack Overflow by Sanjana Nair
, 1 year ago
near "desc": syntax error (code 1): , while compiling: SELECT * FROM UnMappText WHERE updateTime = '0' desc LIMIT 0, 500

Solution icon of stackoverflow
via Stack Overflow by Unknown author, 1 year ago
near "t": syntax error (code 1): , while compiling: SELECT * from ValueTable where SrNo = (with t as(SELECT SrNo,Value2 from ValueTable where Value2<'600' ) SELECT SrNo from t order by Value2 DESC limit 1)

Solution icon of stackoverflow
near "?": syntax error (code 1): , while compiling: DELETE FROM ChatData WHERE conversation_ID = 1 AND _id in ?

Solution icon of github
near "ORDER": syntax error (code 1): , while compiling: DELETE FROM tbl_posts WHERE tag_name=? AND tag_type=? ORDER BY date_published LIMIT ?

Solution icon of stackoverflow
via Stack Overflow by iAziz
, 1 year ago
near "WHERE": syntax error (code 1): , while compiling: SELECT * FROM history WHERE query= 'Information Pillar' AND WHERE distance= '20'****

Solution icon of github
(SQLITE_ERROR) Caused By : SQL(query) error or missing database. (near "S": syntax error (code 1): , while compiling: select * from recentsearches where zim = '/storage/extSdCard/ab'S/APKz/Download/wikipedia_en_all_simple_2015-08.zim') #################################################################

Solution icon of stackoverflow
via Stack Overflow by DWA2112
, 1 year ago
Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (near "FROM": syntax error (code 1): , while compiling: SELECT FROM SCANDATA) #################################################################

Solution icon of web
via pr8x.com by Unknown author, 1 year ago
near "WHERE": syntax error (code 1): , while compiling: SELECT * FROM history WHERE query= 'Information Pillar' AND WHERE distance= '20'****

Solution icon of github
via GitHub by kelson42
, 1 year ago
################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (no such column: recentSearches.searchString (code 1): , while compiling: SELECT DISTINCT recentSearches.searchString AS searchString FROM recentSearches ORDER BY recentSearches._id DESC LIMIT 5) #################################################################

Stack trace

android.database.sqlite.SQLiteException: near "DESC": syntax error (code 1): , while compiling: DELETE FROM people_email_followers WHERE local_blog_id=?1 AND person_id IN (SELECT person_id FROM people_email_followers WHERE local_blog_id=?1 DESC LIMIT ?2)
#################################################################
Error Code : 1 (SQLITE_ERROR)
Caused By : SQL(query) error or missing database.
	(near "DESC": syntax error (code 1): , while compiling: DELETE FROM people_email_followers WHERE local_blog_id=?1 AND person_id IN (SELECT person_id FROM people_email_followers WHERE local_blog_id=?1 DESC LIMIT ?2))
#################################################################
	at android.database.sqlite.SQLiteConnection.nativePrepareStatement(SQLiteConnection.java)
	at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1058)
	at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:623)
	at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
	at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
	at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
	at android.database.sqlite.SQLiteDatabase.delete(SQLiteDatabase.java:1634)
	at org.wordpress.android.datasets.PeopleTable.deletePeopleExceptForFirstPage(PeopleTable.java:181)
	at org.wordpress.android.ui.people.PeopleManagementActivity.onCreate(PeopleManagementActivity.java:105)
	at android.app.Activity.performCreate(Activity.java:6876)
	at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1135)
	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3207)
	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3350)
	at android.app.ActivityThread.access$1100(ActivityThread.java:222)
	at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1795)
	at android.os.Handler.dispatchMessage(Handler.java:102)
	at android.os.Looper.loop(Looper.java:158)
	at android.app.ActivityThread.main(ActivityThread.java:7229)
	at java.lang.reflect.Method.invoke(Method.java)
	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230)
	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120)
	at de.robv.android.xposed.XposedBridge.main(XposedBridge.java:117)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

23 times, 1 week ago
39 times, 7 months ago
6 times, 1 year ago
347 times, 1 week ago
2 times, 1 week ago
110 more bugmates