Simple-SMS-Messenger
Simple-SMS-Messenger copied to clipboard
SQL error when clicked on the "new message" button
Device: Huawei Y6 2019 (MRD-LX1) Android version: 9.1.0 App version: 5.12.0
An SQL error shows up as a toast message when I click on the "new message" button below. Here is a screenshot of it (Also I tried deleting the data and cache but error still occurs so It doesn't seem to be related):
isnt that a rooted device or one modified in a similar way?
not really, my device is neither rooted nor modified.
that sms_secret looks weird. It sounds like some device specific issue with a secret storage or something like that
i'm not shocked at all, my phone's vendor-modified Android is generally painful to use.
if you downloaded some other SMS Messenger, does it work? I mean a really downloaded one, not preinstalled.
Simple SMS Messenger still works, it's just that error message comes out and that's it.
and also, i just installed QKSMS to see if the error shows up but it doesn't.
oh, so everything work well in our app? Sending and receiving messages?
yeah everything works, i just wanted to report the issue in case if something in the backend was broken
right, so it appears only as you click on "New message" and it appears right at opening that new screen?
exaclty, like this:
@tibbi Could you fix this issue, I saw this on my own messenger too. seems something changed in one of the huawei's updates. if I found something, I will share it here
what app version are you using?
I have my own SMS Messenger https://cafebazaar.ir/app/ir.digitaldreams.hodhod/?l=en But recently got a lot of reports that my messages aren't loading for some Huawei devices after their phone updates.
I got some information from our users and this is the cause of issue:
java.lang.RuntimeException: Unable to start activity ComponentInfo{ir.digitaldreams.hodhod/ir.digitaldreams.hodhod.ui.activities.ConversationsActivity}: android.database.sqlite.SQLiteException: near "Group": syntax error (Sqlite code 1 SQLITE_ERROR): , while compiling: SELECT s._id,s.thread_id,s.address,s.body,s.status,s.type,s.read,s.date from sms_secret as s , ( Select thread_id,max(_id) as _id FROM sms_secret WHERE ((1=1) Group By thread_id) as t where (s._id=t._id)) ORDER BY s.date desc, (OS error - 11:Try again)
I searched and found this thread. I think they changed something in SMS database. because also they did this before maybe 4 years ago and I have to create a new query getting threads