android.database.sqlite.SQLiteException: no such column: data1 (code 1): , while compiling: SELECT times_contacted, contacts_status_updates.status AS contact_status, phonetic_name, phonetic_name_style, link_accounts AS link, is_user_profile, lookup, phonebook_label_alt, contacts_status_updates.status_icon AS contact_status_icon, last_time_contacted, contact_last_updated_timestamp, sec_custom_vibration, _id, display_name_source, photo_uri, photo_thumb_uri, agg_presence.chat_capability AS contact_chat_capability, photo_id, send_to_voicemail, display_name_alt AS display_name_reverse, custom_ringtone, name_raw_contact_id, photo_file_id, has_phone_number, contacts_status_updates.status_label AS contact_status_label, link_type1, phonebook_bucket, display_name, phonebook_bucket_alt, has_email, sort_key_alt, phonebook_label, dirty_contact, in_visible_group, starred, link_count, display_name_alt, sort_key, agg_presence.mode AS contact_presence, sec_custom_alert, is_private, contacts_status_updates.status_res_package AS contact_status_res_package, contacts_status_updates.status_ts AS contact_status_ts FROM view_contacts_restricted LEFT OUTER JOIN agg_presence ON (view_contacts_restricted._id = agg_presence.presence_contact_id) LEFT OUTER JOIN status_updates contacts_status_updates ON (status_update_id=contacts_status_updates.status_update_data_id) WHERE ((1)) AND (((display_name LIKE ?) OR (data1 LIKE ?) OR (data1 LIKE ? )))

Stack Overflow | Dhrupal | 2 months ago
  1. 0

    Query db for getting list either like given name, email or phone

    Stack Overflow | 2 months ago | Dhrupal
    android.database.sqlite.SQLiteException: no such column: data1 (code 1): , while compiling: SELECT times_contacted, contacts_status_updates.status AS contact_status, phonetic_name, phonetic_name_style, link_accounts AS link, is_user_profile, lookup, phonebook_label_alt, contacts_status_updates.status_icon AS contact_status_icon, last_time_contacted, contact_last_updated_timestamp, sec_custom_vibration, _id, display_name_source, photo_uri, photo_thumb_uri, agg_presence.chat_capability AS contact_chat_capability, photo_id, send_to_voicemail, display_name_alt AS display_name_reverse, custom_ringtone, name_raw_contact_id, photo_file_id, has_phone_number, contacts_status_updates.status_label AS contact_status_label, link_type1, phonebook_bucket, display_name, phonebook_bucket_alt, has_email, sort_key_alt, phonebook_label, dirty_contact, in_visible_group, starred, link_count, display_name_alt, sort_key, agg_presence.mode AS contact_presence, sec_custom_alert, is_private, contacts_status_updates.status_res_package AS contact_status_res_package, contacts_status_updates.status_ts AS contact_status_ts FROM view_contacts_restricted LEFT OUTER JOIN agg_presence ON (view_contacts_restricted._id = agg_presence.presence_contact_id) LEFT OUTER JOIN status_updates contacts_status_updates ON (status_update_id=contacts_status_updates.status_update_data_id) WHERE ((1)) AND (((display_name LIKE ?) OR (data1 LIKE ?) OR (data1 LIKE ? )))
  2. 0

    Crashes on android 4.3 when get calls log by getContentResolver

    Stack Overflow | 2 years ago | Mít Tơ Lớp
    android.database.sqlite.SQLiteException: near "GROUP": syntax error (code 1): , while compiling: SELECT number, name FROM logs WHERE (logs.logtype=100 OR logs.logtype=110 OR logs.logtype=900 OR logs.logtype=500 OR logs.logtype=800 OR logs.logtype=120 OR logs.logtype=510 OR logs.logtype=1000 OR (logs.logtype=200 AND number NOT IN (SELECT number FROM logs WHERE number LIKE '%@%')) OR logs.logtype=300 OR logs.logtype=950) AND ((number IS NOT NULL) GROUP BY (number) AND ((type != 4)) AND (logtype=100 OR logtype=500 OR logtype=950 OR logtype=1000)) ORDER BY date DESC
  3. 0

    com.andrew.apollo.MusicPlaybackService: SQLiteException: no such column: album_id (code 1)

    GitHub | 2 years ago | gubatron
    java.lang.RuntimeException: Unable to create service com.andrew.apollo.MusicPlaybackService: android.database.sqlite.SQLiteException: no such column: album_id (code 1): , while compiling: SELECT album_art FROM (SELECT album_info.*,audio_meta._data,audio_meta.is_music,audio_meta.is_drm FROM album_info LEFT OUTER JOIN audio_meta ON album_info._id=audio_meta.album_id) WHERE (_data not like '/storage/sdcard1/%' AND is_music=1 AND album_id=?) GROUP BY _id
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Android SMS SQLite Crash "Caused by: android.database.sqlite.SQLiteException: Can't downgrade database from version 58 to 55"

    Stack Overflow | 3 years ago | Chethan Shetty
    android.database.sqlite.SQLiteException: Can't downgrade database from version 58 to 55
  6. 0

    Android Application crashes on Startup

    Stack Overflow | 3 years ago | Gantrof
    android.database.sqlite.SQLiteException: unknown error (code 14): Could not open database

  1. Rajesh 20 times, last 4 months ago
  2. jk 8 times, last 5 months ago
4 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: data1 (code 1): , while compiling: SELECT times_contacted, contacts_status_updates.status AS contact_status, phonetic_name, phonetic_name_style, link_accounts AS link, is_user_profile, lookup, phonebook_label_alt, contacts_status_updates.status_icon AS contact_status_icon, last_time_contacted, contact_last_updated_timestamp, sec_custom_vibration, _id, display_name_source, photo_uri, photo_thumb_uri, agg_presence.chat_capability AS contact_chat_capability, photo_id, send_to_voicemail, display_name_alt AS display_name_reverse, custom_ringtone, name_raw_contact_id, photo_file_id, has_phone_number, contacts_status_updates.status_label AS contact_status_label, link_type1, phonebook_bucket, display_name, phonebook_bucket_alt, has_email, sort_key_alt, phonebook_label, dirty_contact, in_visible_group, starred, link_count, display_name_alt, sort_key, agg_presence.mode AS contact_presence, sec_custom_alert, is_private, contacts_status_updates.status_res_package AS contact_status_res_package, contacts_status_updates.status_ts AS contact_status_ts FROM view_contacts_restricted LEFT OUTER JOIN agg_presence ON (view_contacts_restricted._id = agg_presence.presence_contact_id) LEFT OUTER JOIN status_updates contacts_status_updates ON (status_update_id=contacts_status_updates.status_update_data_id) WHERE ((1)) AND (((display_name LIKE ?) OR (data1 LIKE ?) OR (data1 LIKE ? )))

    at android.database.DatabaseUtils.readExceptionFromParcel()
  2. Android Platform
    ContentResolver.query
    1. android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:181)
    2. android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:137)
    3. android.content.ContentProviderProxy.query(ContentProviderNative.java:385)
    4. android.content.ContentResolver.query(ContentResolver.java:417)
    5. android.content.ContentResolver.query(ContentResolver.java:360)
    5 frames
  3. com.icpl.dhrupalpatel
    MainActivity$1.onClick
    1. com.icpl.dhrupalpatel.searchconatact.MainActivity.getDetail(MainActivity.java:81)
    2. com.icpl.dhrupalpatel.searchconatact.MainActivity$1.onClick(MainActivity.java:49)
    2 frames
  4. Android Platform
    ActivityThread.main
    1. android.view.View.performClick(View.java:4475)
    2. android.view.View$PerformClick.run(View.java:18796)
    3. android.os.Handler.handleCallback(Handler.java:730)
    4. android.os.Handler.dispatchMessage(Handler.java:92)
    5. android.os.Looper.loop(Looper.java:137)
    6. android.app.ActivityThread.main(ActivityThread.java:5455)
    6 frames
  5. Java RT
    Method.invoke
    1. java.lang.reflect.Method.invokeNative(Native Method)
    2. java.lang.reflect.Method.invoke(Method.java:525)
    2 frames
  6. Android
    ZygoteInit.main
    1. com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1187)
    2. com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1003)
    2 frames
  7. Android Platform
    NativeStart.main
    1. dalvik.system.NativeStart.main(Native Method)
    1 frame