Is there a way to trigger the phone to look for missed SMS messages?
-
Hi! Does anybody have a clever way to try to seek out missed SMS messages? A terminal command or something?
It seems that when my phone is off, some messages don't get discovered. Unclear why some do and some don't. Not knowing who might have messaged me is tricky.
I'm using Oneplus Nord N10 on 20.04, for the record. Things were a bit glitchy when I moved to this phone and imported my old messages by moving history.sqlite over, but seemed to iron themselves out over time. I almost always have the phone on, so this problem could have been happening all along.So far I've tried putting the SIM into another phone, and no new messages appeared, which I presume means the cell carrier thinks they were delivered.
I'm presently trying to examine history.sqlite in database software and realizing that I have no idea what a database is or how to find anything -
@wally said in Is there a way to trigger the phone to look for missed SMS messages?:
Hi! Does anybody have a clever way to try to seek out missed SMS messages? A terminal command or something?
It seems that when my phone is off, some messages don't get discovered. Unclear why some do and some don't. Not knowing who might have messaged me is tricky.
I'm using Oneplus Nord N10 on 20.04, for the record. Things were a bit glitchy when I moved to this phone and imported my old messages by moving history.sqlite over, but seemed to iron themselves out over time. I almost always have the phone on, so this problem could have been happening all along.So far I've tried putting the SIM into another phone, and no new messages appeared, which I presume means the cell carrier thinks they were delivered.
I'm presently trying to examine history.sqlite in database software and realizing that I have no idea what a database is or how to find anythingWhen you received an sms, the carrier delete it, there are not stored in the SIM card, but in history-service database.
if you missed an sms, it should be shown in the indicator, and also displayed as bold in the threads view
history.sqlite is a the sqlite databaseyou can browse it on desktop easily with any sqlite browser. the sms are in the text_events table, and the unreadcount is in the threads table ( it gathers all text_event that have messageStatus == 7 if i'm not wrong
-
@lduboeuf Thanks for the help. Sounds like if on somebody else's phone a message was sent to me, but it never appeared in my notifications, threads view, or messages, it probably just won't be recoverable. The missing messages don't seem to be in history.service, so it's not just some problem of failing to be displayed in the messaging app.
The messages that I know about which didn't come through aren't the problem of course, it's not knowing how many other people messaged me without the messages arriving, and without the senders knowing that I didn't receive them.
My best guess is that this may relate to one or both of picking up messages after the phone has been powered off and being either in low signal or in an area where my cell provider has an agreement with other networks. It happened to me a lot with this phone when I was on a carrier who had a limited network, where I was out of normal network more frequently. I quickly switched cell carriers.
But I think it also may be either device specific or some glitch on my particular installation. -
@wally I also had that several times this month, particularly on one contact ( or at least someone that i meet often so i can know if any missing messages ), and indeed it is when traveling. I've created an issue here, it can be very annoying, but surely very hard to tackle:
https://gitlab.com/ubports/development/core/packaging/ofono-sailfish/-/issues/20 -
@lduboeuf Yeah, sounds like a hard issue to solve indeed. Maybe one day more modern messengers will become more fully interoperable and we can forget about SMS.
Thanks for helping me understand how this works, and for filing that issue.