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


Solutions on the web

Solution icon of stackoverflow
via Stack Overflow by AgentEddie99
, 8 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

Solution icon of stackoverflow
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

Solution icon of stackoverflow
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'

Solution icon of stackoverflow
via Stack Overflow by smartmouse
, 1 year 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'

Solution icon of stackoverflow
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=?

Solution icon of stackoverflow
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

Solution icon of stackoverflow
via Stack Overflow by Hama
, 8 months ago
Unable to start activity ComponentInfo{com.bignerdranch.android.test/com.bignerdranch.android.test.MainActivity}: android.database.sqlite.SQLiteException: near "table": syntax error (code 1): , while compiling: CREATE TABLE table(nameTEXT)

Solution icon of github
via GitHub by leletec
, 1 year ago
Unable to start activity ComponentInfo{de.leletec.namememo/main.MainActivity}: android.database.sqlite.SQLiteException: no such table: pictures (code 1): , while compiling: SELECT * FROM pictures

Solution icon of stackoverflow
Unable to start activity ComponentInfo{com.anapp.tpb.replacement/com.anapp.tpb.replacement.Setup.DataPresentation.ClassTimeCollector}: android.database.sqlite.SQLiteException: no such table: ClassTimes (code 1): , while compiling: SELECT * FROM ClassTimes

Solution icon of stackoverflow
via Stack Overflow by Suprad Parashar
, 2 months ago
Unable to start activity ComponentInfo{com.example.android.collecto/com.example.android.collecto.NoteActivity}: android.database.sqlite.SQLiteException: no such table: notes (code 1): , while compiling: SELECT * FROM notes

Stack trace

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)
	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476)

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

Samebug visitor profile picture
Unknown user
Once, 4 weeks ago
7 times, 7 months ago
Samebug visitor profile picture
Unknown user
Once, 9 months ago
Samebug visitor profile picture
Unknown user
Once, 9 months ago
3 times, 10 months ago
109 more bugmates