java.lang.RuntimeException: java.sql.SQLException: Could not perform raw query for SELECT s.id as _id, s.name, s.color, count(case when m.id > -1 or messages.read = 1 then 1 end) as unread FROM streams as s LEFT JOIN messages as m ON s.id=m.stream group by s.name order by s.name COLLATE NOCASE

GitHub | niftynei | 4 months ago
  1. 0

    GitHub comment 120#240272736

    GitHub | 4 months ago | niftynei
    java.lang.RuntimeException: java.sql.SQLException: Could not perform raw query for SELECT s.id as _id, s.name, s.color, count(case when m.id > -1 or messages.read = 1 then 1 end) as unread FROM streams as s LEFT JOIN messages as m ON s.id=m.stream group by s.name order by s.name COLLATE NOCASE
  2. 0

    Getting SQLITE Exception in getting data from ContactsContract table

    Stack Overflow | 3 years ago | Shazar
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.webpreneur_contactlist/com.webpreneur_contactlist.WebpreneurActivity}: android.database.sqlite.SQLiteException: no such column: has_phone_number: , while compiling: SELECT data_version, phonetic_name, contact_id, phonetic_name_style, lookup, data12, data11, mimetype, data10, data15, data14, data13, data_sync1, display_name_source, data_sync3, data_sync2, agg_presence.chat_capability AS contact_chat_capability, data_sync4, account_type, custom_ringtone, data1, status_updates.status AS status, data4, data5, data2, data3, data8, data9, data6, group_sourceid, data7, account_name, display_name, in_visible_group, display_name_alt, is_primary, contacts_status_updates.status_res_package AS contact_status_res_package, contacts_status_updates.status_ts AS contact_status_ts, raw_contact_id, times_contacted, contacts_status_updates.status AS contact_status, status_updates.status_res_package AS status_res_package, status_updates.status_icon AS status_icon, contacts_status_updates.status_icon AS contact_status_icon, version, presence.mode AS mode, last_time_contacted, _id, res_package, name_verified, is_super_primary, dirty, status_updates.status_ts AS status_ts, photo_id, send_to_voicemail, name_raw_contact_id, contacts_status_updates.status_label AS contact_status_label, status_updates.status_label AS status_label, sort_key_alt, starred, sort_key, sourceid, agg_presence.mode AS contact_presence FROM ( SELECT * FROM view_data_restricted WHERE (mimetype IS NULL OR mimetype NOT IN ('vnd.android.cursor.item/vnd.sonyericsson.android.hrphoto')) ) data LEFT OUTER JOIN agg_presence ON (agg_presence.presence_contact_id=contact_id) LEFT OUTER JOIN status_updates contacts_status_updates ON (status_update_id=contacts_status_updates.status_update_data_id) LEFT OUTER JOIN presence ON (presence_data_id=data._id) LEFT OUTER JOIN status_updates ON (status_updates.status_update_data_id=data._id) WHERE (1) AND (has_phone_number!=0 AND (mimetype=? OR mimetype=?)) ORDER BY contact_id
  3. 0

    How to get first name and last name from contacts?

    Stack Overflow | 6 months ago | user6265109
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.siddhi.meavita/com.example.siddhi.meavita.Activities.ContactList}: android.database.sqlite.SQLiteException: near ")": syntax error (code 1): , while compiling: SELECT sort_key, photo_uri, status_updates.status_label AS status_label, status_updates.status_ts AS status_ts, status_updates.status_res_package AS status_res_package, display_name, data_usage_stat.last_time_used AS last_time_used, mimetype, phonebook_label_alt, data6, version, photo_id, data3, custom_ringtone, times_contacted, account_type_and_data_set, dirty, data7, data15, raw_contact_is_user_profile, data_set, phonebook_label, data10, res_package, account_type, data11, display_name_alt, lookup, phonetic_name, last_time_contacted, contact_last_updated_timestamp, data13, in_visible_group, presence.chat_capability AS chat_capability, data9, carrier_presence, data_sync1, sort_key_alt, agg_presence.mode AS contact_presence, data_version, phonetic_name_style, name_raw_contact_id, raw_contact_id, send_to_voicemail, data4, data12, contacts_status_updates.status AS contact_status, contacts_status_updates.status_label AS contact_status_label, pinned, status_updates.status_icon AS status_icon, status_updates.status AS status, data1, phonebook_bucket, data_sync2, contacts_status_updates.status_res_package AS contact_status_res_package, in_default_directory, _id, hash_id, is_super_primary, data5, contact_id, data8, is_primary, data_sync4, has_phone_number, display_name_source, photo_file_id, data_sync3, backup_id, data14, contacts_status_updates.status_ts AS contact_status_ts, phonebook_bucket_alt, presence.mode AS mode, data2, group_sourceid, starred, photo_thumb_uri, data_usage_stat.times_used AS times_used, contacts_status_updates.status_icon AS contact_status_icon, agg_presence.chat_capability AS contact_chat_capability, account_name, sourceid FROM view_data data LEFT OUTER JOIN agg_presence ON (contact_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) LEFT OUTER JOIN presence ON (presence_data_id=data._id) LEFT OUTER JOIN status_updates ON (status_updates.status_update_data_id=data._id) LEFT OUTER JOIN (SELECT data_usage_stat.data_id as STAT_DATA_ID, SUM(data_usage_stat.times_used) as times_used, MAX(data_usage_stat.last_time_used) as last_time_used FROM data_usage_stat GROUP BY data_usage_stat.data_id) as data_usage_stat ON (STAT_DATA_ID=data._id) WHERE (1) ORDER BY data2) ASC
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Repositories accessed before they are migrated

    GitHub | 2 months ago | audax
    java.lang.RuntimeException: Unable to resume activity {de.qabel.qabel/de.qabel.qabelbox.activities.MainActivity}: de.qabel.core.repository.exception.PersistenceException: query failed android.database.sqlite.SQLiteException: no such table: chat_share (code 1): , while compiling: SELECT cdm.id AS cdm_id, cdm.contact_id AS cdm_contact_id, cdm.identity_id AS cdm_identity_id, cdm.direction AS cdm_direction, cdm.status AS cdm_status, cdm.payload_type AS cdm_payload_type, cdm.payload AS cdm_payload, cdm.created_on AS cdm_created_on, cdm.share_id AS cdm_share_id, cs.id AS cs_id, cs.owner_contact_id AS cs_owner_contact_id, cs.identity_id AS cs_identity_id, cs.status AS cs_status, cs.name AS cs_name, cs.size AS cs_size, cs.meta_key AS cs_meta_key, cs.meta_url AS cs_meta_url, cs.hash_type AS cs_hash_type, cs.hash AS cs_hash, cs.prefix AS cs_prefix, cs.modified_on AS cs_modified_on, cs.key AS cs_key, cs.block AS cs_block FROM chat_drop_message cdm LEFT JOIN chat_share cs ON cs.id=cdm.share_id WHERE cdm.identity_id=? AND cdm.status=?)
  6. 0

    Error during SQL: select

    symmetricds | 8 years ago | cmadsen_dk
    java.lang.RuntimeException: Error during SQL: select case when t."id" is null then '' else '"' || replace(replace(t."id",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."opened" is null then '' else '"' || to_char(t."opened", 'YYYY-MM-DD HH24:MI:SS') || '"' end ||','|| case when t."closed" is null then '' else '"' || to_char(t."closed", 'YYYY-MM-DD HH24:MI:SS') || '"' end ||','|| case when t."vesselid" is null then '' else '"' || replace(replace(t."vesselid",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."text" is null then '' else '"' || replace(replace(t."text",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."ackwho" is null then '' else '"' || replace(replace(t."ackwho",E'\\',E'\\\\'),'"',E'\\"') || '"' end ||','|| case when t."ackwhen" is null then '' else '"' || to_char(t."ackwhen", 'YYYY-MM-DD HH24:MI:SS') || '"' end ||','|| case when t."type" is null then '' else '"' || cast(t."type" as varchar) || '"' end from notice t where 1=1

    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. java.lang.RuntimeException

      java.sql.SQLException: Could not perform raw query for SELECT s.id as _id, s.name, s.color, count(case when m.id > -1 or messages.read = 1 then 1 end) as unread FROM streams as s LEFT JOIN messages as m ON s.id=m.stream group by s.name order by s.name COLLATE NOCASE

      at com.j256.ormlite.dao.RuntimeExceptionDao.queryRaw()
    2. ORMLite Core
      RuntimeExceptionDao.queryRaw
      1. com.j256.ormlite.dao.RuntimeExceptionDao.queryRaw(RuntimeExceptionDao.java:483)
      1 frame
    3. com.zulip.android
      ZulipActivity.onCreate
      1. com.zulip.android.activities.ZulipActivity$17.call(ZulipActivity.java:625)
      2. com.zulip.android.activities.ZulipActivity$17.call(ZulipActivity.java:621)
      3. com.zulip.android.activities.ZulipActivity.setupListViewAdapter(ZulipActivity.java:638)
      4. com.zulip.android.activities.ZulipActivity.checkAndSetupStreamsDrawer(ZulipActivity.java:747)
      5. com.zulip.android.activities.ZulipActivity.onCreate(ZulipActivity.java:409)
      5 frames
    4. Android Platform
      ActivityThread.handleLaunchActivity
      1. android.app.Activity.performCreate(Activity.java:6251)
      2. android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1107)
      3. android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2369)
      4. android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476)
      4 frames