How to delete single sms in phosh?
#2
Self-answer:

1) kill chatty
2) sqlite3 ~/.purple/chatty/db/chatty-history.db
3) find necessary thread_id:
select * from threads where name like "%username%" limit 10;
4) find target message(s):
select * from messages where thread_id is NUM and time >= SECONDS limit 20;
NUM from 3)
SECONDS is in date "+%s", e.g. for recent day.
5) delete necessary message(s):
delete from messages where id = ID;
ID is from 4) output
6) run chatty again (e.g. by running gui app)
  Reply


Messages In This Thread
How to delete single sms in phosh? - by bircoph - 07-04-2022, 04:11 AM
RE: How to delete single sms in phosh? - by bircoph - 07-06-2022, 08:10 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Fresh install pmos+phosh does not boot user641 1 644 10-08-2023, 04:04 AM
Last Post: user641
  [Not Pinephone] Phosh Autologin LienRag 11 2,446 09-01-2023, 10:55 PM
Last Post: rocket2nfinity
  pmos/phosh edge update and audio disappears robthebold 9 5,836 07-10-2022, 03:26 AM
Last Post: arkadione
  no screen rotation on pinephone pro with postmarketOS + phosh elode 2 2,792 07-03-2022, 09:13 AM
Last Post: a.h.littorin
  closing apps rather than leaving them running (phosh) lordearl 7 6,443 02-03-2022, 09:14 PM
Last Post: parry
  Application list PMOS-Phosh jmorris 6 6,328 12-04-2021, 02:26 AM
Last Post: Juergen
  Phosh beta 10, no send button on Chatty? Rainer 0 1,671 05-24-2021, 08:17 AM
Last Post: Rainer
  No camera app on PinePhone Postmarket Edition / Phosh Noah222 3 5,005 12-02-2020, 03:38 PM
Last Post: jmorris
  Phosh and Plasma together stozi 5 7,295 09-30-2020, 01:25 PM
Last Post: wibble
Bug Phosh Black Screen gotomech 8 8,164 06-16-2020, 02:40 AM
Last Post: davidbe

Forum Jump:


Users browsing this thread: 1 Guest(s)