java.lang.RuntimeException: Unable to start activity ComponentInfo{com.pfc.android/com.pfc.android.Prueba}: android.database.sqlite.SQLiteException: no such column: _id: , while compiling: SELECT _id, nombre, telefono, mail FROM t_contactos

Stack Overflow | Kitinz | 6 years ago
  1. 0

    Android. SQLite Exception: no such column _id

    Stack Overflow | 6 years ago | Kitinz
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.pfc.android/com.pfc.android.Prueba}: android.database.sqlite.SQLiteException: no such column: _id: , while compiling: SELECT _id, nombre, telefono, mail FROM t_contactos
  2. 0

    Failing to escape single quotes in queries

    GitHub | 2 years ago | johngray1965
    android.database.sqlite.SQLiteException: near "s": syntax error (code 1): , while compiling: SELECT _id, name FROM transactions WHERE name LIKE 'Crosby's%' ORDER BY name ASC
  3. 0

    What is table E? (Proguard issues)

    GitHub | 12 months ago | wirawansanusi
    android.database.sqlite.SQLiteException: no such table: PRODUCT (code 1): , while compiling: SELECT * FROM PRODUCT
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    DB migration fails when DB version <= 10

    GitHub | 3 years ago | maxme
    android.database.sqlite.SQLiteException: no such table: localdrafts (code 1): , while compiling: SELECT blogID, title, content, picturePaths, date, categories, tags, status, password, latitude, longitude FROM localdrafts ORDER BY id desc
  6. 0

    Database Upgrade Failed

    GitHub | 4 years ago | SammysHP
    android.database.sqlite.SQLiteException: no such column: myvote: , while compiling: SELECT _id, updated, reason, detailed, detailedupdate, visiteddate, geocode, cacheid, guid, type, name, own, owner, owner_real, hidden, hint, size, difficulty, distance, direction, terrain, latlon, location, latitude, longitude, elevation, shortdesc, favourite_cnt, rating, votes, myvote, disabled, archived, members, found, favourite, inventorycoins, inventorytags, inventoryunknown, onWatchlist, personal_note, reliable_latlon, coordsChanged, finalDefined FROM cg_caches WHERE geocode in ("GC3H58A")

  1. Minafaw 2 times, last 4 months ago
  2. Ranjana Dangol 1 times, last 5 months ago
  3. Stefan Braune 177 times, last 6 months ago
  4. dmitry 53 times, last 6 months ago
11 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

    no such column: _id: , while compiling: SELECT _id, nombre, telefono, mail FROM t_contactos

    at android.database.sqlite.SQLiteProgram.native_compile()
  2. Android Platform
    SQLiteDatabase.query
    1. android.database.sqlite.SQLiteProgram.native_compile(Native Method)
    2. android.database.sqlite.SQLiteProgram.compile(SQLiteProgram.java:110)
    3. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
    4. android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:49)
    5. android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:49)
    6. android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1118)
    7. android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1006)
    8. android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:964)
    9. android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1041)
    9 frames
  3. com.pfc.android
    Prueba.onCreate
    1. com.pfc.android.DataBaseAccess.getAllContact(DataBaseAccess.java:97)
    2. com.pfc.android.Prueba.onCreate(Prueba.java:21)
    2 frames
  4. Android Platform
    ActivityThread.main
    1. android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1123)
    2. android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2364)
    3. android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2417)
    4. android.app.ActivityThread.access$2100(ActivityThread.java:116)
    5. android.app.ActivityThread$H.handleMessage(ActivityThread.java:1794)
    6. android.os.Handler.dispatchMessage(Handler.java:99)
    7. android.os.Looper.loop(Looper.java:123)
    8. android.app.ActivityThread.main(ActivityThread.java:4203)
    8 frames
  5. Java RT
    Method.invoke
    1. java.lang.reflect.Method.invokeNative(Native Method)
    2. java.lang.reflect.Method.invoke(Method.java:521)
    2 frames
  6. Android
    ZygoteInit.main
    1. com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:791)
    2. com.android.internal.os.ZygoteInit.main(ZygoteInit.java:549)
    2 frames
  7. Android Platform
    NativeStart.main
    1. dalvik.system.NativeStart.main(Native Method)
    1 frame