java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.anilkumar.contactstask/com.example.anilkumar.contactstask.ShowContacts}: android.database.sqlite.SQLiteException: near "fromcontacts": syntax error: , while compiling: select * fromcontacts

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Stack Overflow by A.asha
, 1 year ago
Unable to start activity ComponentInfo{com.example.anilkumar.contactstask/com.example.anilkumar.contactstask.ShowContacts}: android.database.sqlite.SQLiteException: near "fromcontacts": syntax error: , while compiling: select * fromcontacts
via Stack Overflow by Abhishek Bera
, 1 year ago
Unable to start activity ComponentInfo{com.app.bluu.campus360/com.app.bluu.campus360.OrderActivity}: android.database.sqlite.SQLiteException: **near "order": syntax error (code 1): , while compiling: SELECT * FROM order**
via Stack Overflow by Salva
, 2 years ago
Unable to start activity ComponentInfo{com.example.lovehate.loveandhate/com.example.lovehate.loveandhate.Love}: android.database.sqlite.SQLiteException: near "CHECK": syntax error (code 1): , while compiling: SELECT _id, nombre, imagen, checki FROM lovehateTable WHERE CHECK=0
via Stack Overflow by Inessaria
, 1 year ago
Unable to start activity ComponentInfo{com.example.sixth/com.example.sixth.Drinks}: android.database.sqlite.SQLiteException: near "null": syntax error (code 1): , while compiling: SELECT * FROM null WHERE DRINKTYPE='Beer';
via codeproject.com by Unknown author, 1 year ago
Unable to start activity ComponentInfo{com.example.a/com.example.a.MainActivity}: android.database.sqlite.SQLiteException: near "EXISTSnumber": syntax error (code 1): , while compiling: DROP TABLE IF EXISTSnumber
via Stack Overflow by RD Division Medequip
, 1 year ago
Unable to start activity ComponentInfo{com.lakshman.androidfiles/com.lakshman.androidfiles.MainActivity}: android.database.sqlite.SQLiteException: near "Beforefuseoffsets": syntax error (code 1): , while compiling: Beforefuseoffsets
java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.anilkumar.contactstask/com.example.anilkumar.contactstask.ShowContacts}: android.database.sqlite.SQLiteException: near "fromcontacts": syntax error: , while compiling: select * fromcontacts
at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
at android.database.sqlite.SQLiteCompiledSql.(SQLiteCompiledSql.java:68)
at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:143)
at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361)
at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:127)
at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:94)
at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:53)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:47)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1564)
at com.example.anilkumar.contactstask.ShowContacts.initializeData(ShowContacts.java:44)
at com.example.anilkumar.contactstask.ShowContacts.onCreate(ShowContacts.java:34)
at android.app.Activity.performCreate(Activity.java:4466)
at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)

Users with the same issue

4 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
8 times, 3 months ago
Once, 1 year ago

Write tip

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