SQL error when clicked on the "new message" button

[dybdeskarphet]

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):

[tibbi]

isnt that a rooted device or one modified in a similar way?

[dybdeskarphet]

not really, my device is neither rooted nor modified.

[tibbi]

that sms_secret looks weird. It sounds like some device specific issue with a secret storage or something like that

[dybdeskarphet]

i'm not shocked at all, my phone's vendor-modified Android is generally painful to use.

[tibbi]

if you downloaded some other SMS Messenger, does it work? I mean a really downloaded one, not preinstalled.

[dybdeskarphet]

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.

[tibbi]

oh, so everything work well in our app? Sending and receiving messages?

[dybdeskarphet]

yeah everything works, i just wanted to report the issue in case if something in the backend was broken

[tibbi]

right, so it appears only as you click on "New message" and it appears right at opening that new screen?

[dybdeskarphet]

exaclty, like this:

[amirghm]

@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

[tibbi]

what app version are you using?

[amirghm]

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