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 web53727

Solution icon of stackoverflow
via Stack Overflow by AgentEddie99
, 6 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
Unable to start activity ComponentInfo{com.example.mayurn.sqlite/com.example.mayurn.sqlite.MainActivity}: android.database.sqlite.SQLiteException: near "1": syntax error (code 1): , while compiling: SELECT * FROM productsWHERE 1

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

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
via Stack Overflow by beshoy samy
, 9 months ago
Unable to start activity ComponentInfo{com.getsaveit.saveit/com.getsaveit.saveit.activities.Dashboard}: android.database.sqlite.SQLiteException: near "TRANSACTION": syntax error (code 1): , while compiling: SELECT * FROM TRANSACTION

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 web
Unable to start activity ComponentInfo{com.example.expandablelistview/com.example.expandablelistview.MainActivity}: android.database.sqlite.SQLiteException: near "Entertainment": syntax error (code 1): , while compiling: SELECT NAME from products where CATEGORY =Audio and Home Entertainment

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

Solution icon of stackoverflow
via Stack Overflow by karthickYadav
, 1 year ago
Unable to start activity ComponentInfo{com.example.aeiltech.exfoodsql/com.example.aeiltech.exfoodsql.Subcategory}: android.database.sqlite.SQLiteException: near "=": syntax error (code 1): , while compiling: SELECT subcategory FROM food_details WHERE Title=

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'

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

7 times, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 7 months ago
Samebug visitor profile picture
Unknown user
Once, 7 months ago
3 times, 7 months ago
Samebug visitor profile picture
Unknown user
Once, 8 months ago
104 more bugmates