java.lang.RuntimeException: Unable to start activity ComponentInfo{com.listviewtest.listdatabase/com.listviewtest.listdatabase.ViewListContents}: android.database.sqlite.SQLiteException: near "FROM": syntax error (code 1): , while compiling: SELECT + FROM mylist_data

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

,

Create an empty public constructor in your code.

Solutions on the web

via Stack Overflow by AgentEddie99
, 11 months ago
Unable to start activity ComponentInfo{com.listviewtest.listdatabase/com.listviewtest.listdatabase.ViewListContents}: android.database.sqlite.SQLiteException: near "FROM": syntax error (code 1): , while compiling: SELECT + FROM mylist_data
via Stack Overflow by Calitoz
, 1 year ago
Unable to start activity ComponentInfo{com.example.carlos.application1/com.example.carlos.application1.MainActivity}: android.database.sqlite.SQLiteException: near "values": syntax error (code 1): , while compiling: select * from values
via Stack Overflow by smartmouse
, 2 years ago
Unable to start activity ComponentInfo{com.example.myapp/com.example.myapp.ListMerchant}: android.database.sqlite.SQLiteException: near "Emilia": syntax error (code 1): , while compiling: Select _id,title,phone,comune from merchants where city='Reggio nell'Emilia'
via Stack Overflow by smartmouse
, 2 years ago
Unable to start activity ComponentInfo{com.example.myapp/com.example.myapp.ListMerchant}: android.database.sqlite.SQLiteException: near "Emilia": syntax error (code 1): , while compiling: Select _id,title,phone,comune from merchants where city='Reggio nell'Emilia'
via Stack Overflow by rockodile
, 10 months ago
Unable to start activity ComponentInfo{com.example.rockodile.contactsappliaction/com.example.rockodile.contactsappliaction.ContactDetails}: android.database.sqlite.SQLiteException: near "FROM": syntax error (code 1): , while compiling: SELECT id, forename, surname, housenumber, street, town, county, postcode, phone, FROM contacts WHERE id=?
via Stack Overflow by Adit R
, 1 year ago
Unable to start activity ComponentInfo{com.example.rcadit.foodgenie/com.example.rcadit.foodgenie.resultActivity}: android.database.sqlite.SQLiteException: near "null": syntax error (code 1): , while compiling: SELECT foodName FROM foodDB where cuisine = null & hungerLevel = null & preparationTime null & course = null
java.lang.RuntimeException: Unable to start activity ComponentInfo{com.listviewtest.listdatabase/com.listviewtest.listdatabase.ViewListContents}: android.database.sqlite.SQLiteException: near "FROM": syntax error (code 1): , while compiling: SELECT + FROM mylist_data
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2416)

Users with the same issue

66 times, 4 weeks ago
Once, 2 months ago
33 times, 3 months ago
8 times, 4 months ago
468 times, 4 months ago

Write tip

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