+- PINE64 (https://forum.pine64.org)
+-- Forum: PinePhone (https://forum.pine64.org/forumdisplay.php?fid=120)
+--- Forum: PinePhone Software (https://forum.pine64.org/forumdisplay.php?fid=121)
+---- Forum: PostmarketOS on PinePhone (https://forum.pine64.org/forumdisplay.php?fid=124)
+---- Thread: How to delete single sms in phosh? (/showthread.php?tid=16955)
How to delete single sms in phosh? - bircoph - 07-04-2022
Hi!
I want to delete a single sms from chat history in phosh, not the whole chat history. How to do that?
IIRC phosh utilizes evolution for contacts and data.
RE: How to delete single sms in phosh? - bircoph - 07-06-2022
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)