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

Stack Overflow | A.asha | 5 months ago
  1. 0

    How to rectify this error iin Recyclerview with database

    Stack Overflow | 5 months ago | A.asha
    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
  2. 0

    `SQLiteException: no such collation sequence: JSON` on Barnes & Noble NOOK HD/HD+

    GitHub | 2 years ago | Takhion
    android.database.sqlite.SQLiteException: no such collation sequence: JSON: , while compiling: SELECT key, value, docid, revs.sequence, revid, json FROM maps, revs, docs WHERE maps.view_id=? AND key in (?) AND revs.sequence = maps.sequence AND docs.doc_id = revs.doc_id ORDER BY key LIMIT ? OFFSET ?
  3. 0

    Crash on startup after upgrading the app. to 2.4

    GitHub | 4 years ago | picon-software
    java.lang.RuntimeException: An error occured while executing doInBackground()
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    getQuery from SQLiteDatabase while afterTextChanged() in an addTextChangedListener()

    Stack Overflow | 2 years ago
    android.database.sqlite.SQLiteException: no such table: adm_table: , while compiling: SELECT adm FROM adm_table WHERE ktype='OEM' AND land=?
  6. 0

    Android Error When Execute SQLite Query

    Stack Overflow | 1 year ago | Ivan Andrianto
    android.database.sqlite.SQLiteException: no such table: table1: , while compiling: select * from table1

  1. Aria Pahlavan 8 times, last 2 weeks ago
  2. mrokay97 2 times, last 4 months ago
  3. Riyaz 1 times, last 6 months ago
  4. Bardh 1 times, last 6 months ago
  5. jk 12 times, last 7 months ago
4 more registered users
17 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. android.database.sqlite.SQLiteException

    near "fromcontacts": syntax error: , while compiling: select * fromcontacts

    at android.database.sqlite.SQLiteCompiledSql.native_compile()
  2. Android Platform
    SQLiteDatabase.rawQuery
    1. android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
    2. android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68)
    3. android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:143)
    4. android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361)
    5. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:127)
    6. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:94)
    7. android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:53)
    8. android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:47)
    9. android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1564)
    10. android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1538)
    10 frames
  3. com.example.anilkumar
    ShowContacts.onCreate
    1. com.example.anilkumar.contactstask.ShowContacts.initializeData(ShowContacts.java:44)
    2. com.example.anilkumar.contactstask.ShowContacts.onCreate(ShowContacts.java:34)
    2 frames
  4. Android Platform
    ActivityThread.performLaunchActivity
    1. android.app.Activity.performCreate(Activity.java:4466)
    2. android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)
    3. android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1920)
    3 frames