https://bugs.kde.org/show_bug.cgi?id=421338
Bug ID: 421338
Summary: android.database.sqlite.SQLiteException: no such
column: group_sent
Product: kdeconnect
Version: unspecified
Platform: Android
OS: Android 8.x
Status: REPORTED
Severity: normal
Priority: NOR
Component: android-application
Assignee: albertv...@gmail.com
Reporter: br...@interlinx.bc.ca
Target Milestone: ---
SUMMARY
While looking through logcat to see why my GSConnect conversations were empty I
came across this:
05-11 09:53:57.548 32194 32194 W InputMethodManager: startInputReason = 8
05-11 09:53:57.720 32194 32194 V ActivityThread: Finishing stop of
ActivityRecord{edcee3b token=android.os.BinderProxy@a065177
{org.kde.kdeconnect_tp/org.kde.kdeconnect.UserInterface.MainActivity}}
05-11 09:54:02.511 32194 32220 W libEGL : EGLNativeWindowType 0x70eebbe010
disconnect failed
05-11 09:54:02.525 32194 32194 V ActivityThread: Handle window
ActivityRecord{edcee3b token=android.os.BinderProxy@a065177
{org.kde.kdeconnect_tp/org.kde.kdeconnect.UserInterface.MainActivity}}
visibility: false
05-11 09:55:08.007 32194 3757 E KDE/Device: Exception in SMSPlugin's
onPacketReceived()
05-11 09:55:08.007 32194 3757 E KDE/Device:
android.database.sqlite.SQLiteException: no such column: group_sent (Sqlite
code 1): , while compiling: SELECT date, subject, ct_t, reply_path_present,
body, type, msg_box, thread_id, sub_cs, retr_st, locked, exp, m_id, date_sent,
read, ct_cls, rpt_a, sub_id, pri, group_sent, resp_txt, ct_l, group_fail,
d_rpt, person, error_code, _id, m_type, status, rr, sub, group_all, is_secret,
read_status, risk_url_body, resp_st, text_only, retr_txt_cs, st, m_size,
address, tr_id, time_body, m_cls, addr_body, group_id, v, service_center,
network_type FROM (SELECT thread_id AS tid, date * 1000 AS normalized_date,
date, NULL AS subject, ct_t, NULL AS reply_path_present, NULL AS body, NULL AS
type, msg_box, thread_id, sub_cs, retr_st, locked, exp, m_id, date_sent, read,
ct_cls, rpt_a, sub_id, pri, NULL AS group_sent, resp_txt, ct_l, NULL AS
group_fail, d_rpt, NULL AS person, NULL AS error_code, _id, m_type, NULL AS
status, rr, sub, NULL AS group_all, NULL AS is_secret, read_status, NULL AS
risk_url_body, resp_st, text_only, retr_txt_cs, st, m_size, NULL AS address,
tr_id, NULL AS time_body, m_cls, NULL AS addr_body, NULL AS group_id, v, NULL
AS service_center, network_type FROM pdu_restricted WHERE ((msg_box != 3 AND
(m_type = 128 OR m_type = 132 OR m_type = 130))) GROUP BY thread_id HAVING date
= MAX(date) UNION SELECT thread_id AS tid, date * 1 AS normalized_date, date,
subject, NULL AS ct_t, reply_path_present, body, type, NULL AS msg_box,
thread_id, NULL AS sub_cs, NULL AS retr_st, locked, NULL AS exp, NULL AS m_id,
date_sent, read, NULL AS ct_cls, NULL AS rpt_a, sub_id, NULL AS pri,
group_sent, NULL AS resp_txt, NULL AS ct_l, group_fail, NULL AS d_rpt, person,
error_code, _id, NULL AS m_type, status, NULL AS rr, NULL AS sub, group_all,
is_secret, NULL AS read_status, risk_url_body, NULL AS resp_st, NULL AS
text_only, NULL AS retr_txt_cs, NULL AS st, NULL AS m_size, address, NULL AS
tr_id, time_body, NULL AS m_cls, addr_body, group_id, NULL AS v,
service_center, network_type FROM sms_secret WHERE ((type != 3)) GROUP BY
thread_id HAVING date = MAX(date)) GROUP BY tid HAVING normalized_date =
MAX(normalized_date), (OS error - 2:No such file or directory)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:179)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:135)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
android.content.ContentProviderProxy.query(ContentProviderNative.java:418)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
android.content.ContentResolver.query(ContentResolver.java:766)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
android.content.ContentResolver.query(ContentResolver.java:716)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
android.content.ContentResolver.query(ContentResolver.java:667)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
org.kde.kdeconnect.Helpers.SMSHelper.getMessages(SMSHelper.java:368)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
org.kde.kdeconnect.Helpers.SMSHelper.getMessages(SMSHelper.java:415)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
org.kde.kdeconnect.Helpers.SMSHelper.getConversations(SMSHelper.java:450)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
org.kde.kdeconnect.Plugins.SMSPlugin.SMSPlugin.handleRequestConversations(SMSPlugin.java:399)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
org.kde.kdeconnect.Plugins.SMSPlugin.SMSPlugin.onPacketReceived(SMSPlugin.java:333)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
org.kde.kdeconnect.Device.onPacketReceived(Device.java:572)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
org.kde.kdeconnect.Backends.BaseLink.packageReceived(BaseLink.java:84)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
org.kde.kdeconnect.Backends.LanBackend.LanLink.receivedNetworkPacket(LanLink.java:261)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
org.kde.kdeconnect.Backends.LanBackend.LanLink.lambda$reset$0$LanLink(LanLink.java:110)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
org.kde.kdeconnect.Backends.LanBackend.-$$Lambda$LanLink$TabvaCXA5qL_bcJDmIELWusNThw.run(Unknown
Source:4)
05-11 09:55:08.007 32194 3757 E KDE/Device: at
java.lang.Thread.run(Thread.java:784)
STEPS TO REPRODUCE
Not entirely sure. Related to trying to open GSConnect Messages.
OBSERVED RESULT
Exception, no conversation history
EXPECTED RESULT
Shouldn't be exceptions, should show conversation history.
Phone is a Huawei Honor 8 running Android 8.0.0. Using Android Messages from
Google. Message history from that app is also visible in other messaging apps,
so it appears to be using the Android SMS database. KDE Connect version is
1.14.2. It has permission to everything it wants except Location.
--
You are receiving this mail because:
You are watching all bug changes.
