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.