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 ? )))

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Stack Overflow by Dhrupal
, 1 year ago
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
via Stack Overflow by prom85
, 9 months ago
no such column: metadata_dirty (code 1): , while compiling: SELECT sort_key, send_to_voicemail, pinned, display_name, metadata_dirty, phonebook_label_alt, version, phonebook_bucket, _id, custom_ringtone, times_contacted, account_type_and_data_set
via Stack Overflow by rxDroid
, 1 year ago
unrecognized token: "2audio" (code 1): , while compiling: SELECT _id FROM audio_genres_map_noid, audio WHERE (audio._id = audio_id AND playlist_id = 2audio._id = audio_id AND genre_id=?) AND ((_data LIKE '%mp3' OR _data LIKE '%ogg' OR _data LIKE '%m4a' OR _data LIKE '%flac' OR _data LIKE '%wav')) ORDER BY title ASC
via Stack Overflow by Mít Tơ Lớp
, 2 years ago
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
via Stack Overflow by AlexKost
, 7 months ago
via GitHub by N2Android
, 2 years ago
no such column: _id (code 1): , while compiling: SELECT _id, class FROM apps WHERE (package=?) ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing
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(DatabaseUtils.java:181)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:137)
at android.content.ContentProviderProxy.query(ContentProviderNative.java:385)
at android.content.ContentResolver.query(ContentResolver.java:417)
at android.content.ContentResolver.query(ContentResolver.java:360)
at com.icpl.dhrupalpatel.searchconatact.MainActivity.getDetail(MainActivity.java:81)
at com.icpl.dhrupalpatel.searchconatact.MainActivity$1.onClick(MainActivity.java:49)
at android.view.View.performClick(View.java:4475)
at android.view.View$PerformClick.run(View.java:18796)
at android.os.Handler.handleCallback(Handler.java:730)
at android.os.Handler.dispatchMessage(Handler.java:92)
at android.os.Looper.loop(Looper.java:137)
at android.app.ActivityThread.main(ActivityThread.java:5455)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:525)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1187)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1003)

Users with the same issue

20 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
8 times, 1 year ago
3 times, 2 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.