Comments (6)
tibbi
commented on May 29, 2024
it might be corrupt. If you select those conversations on the main screen and use Delete, do they disappear?
from simple-sms-messenger.
ltguillaume
commented on May 29, 2024
Yes, they do, although the app completely crashed several times when doing so, even when deleting non-empty conversations.
from simple-sms-messenger.
tibbi
commented on May 29, 2024
what app version are you using at all? Check if it still happens with 5.1.4 released soon. There is already a check for message count, only conversations with >0 should be shown. So I guess the database is somehow corrupt, as it usually happens on Android.
from simple-sms-messenger.
ltguillaume
commented on May 29, 2024
F-Droid is still on 5.1.3, which:
- Either acts like the messages are deleted, but at the next operation, all deleted conversations reappear,
- Or crashes when trying to delete them (see below)
05-23 19:08:34.483 E/SQLiteLog( 1381): (1) no such table: cellbroadcast
05-23 19:08:34.484 E/DatabaseUtils( 1381): Writing exception to parcel
05-23 19:08:34.484 E/DatabaseUtils( 1381): android.database.sqlite.SQLiteException: no such table: cellbroadcast (code 1 SQLITE_ERROR): , while compiling: DELETE FROM threads WHERE status = 0 AND type <> ? AND _id NOT IN (SELECT thread_id FROM sms where thread_id is not null UNION SELECT thread_id FROM pdu where thread_id is not null UNION SELECT DISTINCT thread_id FROM cellbroadcast where thread_id is not null)
05-23 19:08:34.484 E/DatabaseUtils( 1381): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
05-23 19:08:34.484 E/DatabaseUtils( 1381): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:903)
05-23 19:08:34.484 E/DatabaseUtils( 1381): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:514)
05-23 19:08:34.484 E/DatabaseUtils( 1381): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
05-23 19:08:34.484 E/DatabaseUtils( 1381): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
05-23 19:08:34.484 E/DatabaseUtils( 1381): at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
05-23 19:08:34.484 E/DatabaseUtils( 1381): at android.database.sqlite.SQLiteDatabase.delete(SQLiteDatabase.java:1590)
05-23 19:08:34.484 E/DatabaseUtils( 1381): at com.android.providers.telephony.MmsSmsDatabaseHelper.updateMultiThreads(MmsSmsDatabaseHelper.java:4387)
05-23 19:08:34.484 E/DatabaseUtils( 1381): at com.android.providers.telephony.SmsProvider.delete(SmsProvider.java:865)
05-23 19:08:34.484 E/DatabaseUtils( 1381): at android.content.ContentProvider$Transport.delete(ContentProvider.java:343)
05-23 19:08:34.484 E/DatabaseUtils( 1381): at android.content.ContentProviderNative.onTransact(ContentProviderNative.java:195)
05-23 19:08:34.484 E/DatabaseUtils( 1381): at android.os.Binder.execTransact(Binder.java:731)
05-23 19:08:34.487 I/Proximity( 493): distance = 10
05-23 19:08:34.487 E/AndroidRuntime(16093): FATAL EXCEPTION: Thread-25
05-23 19:08:34.487 E/AndroidRuntime(16093): Process: com.simplemobiletools.smsmessenger, PID: 16093
05-23 19:08:34.487 E/AndroidRuntime(16093): android.database.sqlite.SQLiteException: no such table: cellbroadcast (code 1 SQLITE_ERROR): , while compiling: DELETE FROM threads WHERE status = 0 AND type <> ? AND _id NOT IN (SELECT thread_id FROM sms where thread_id is not null UNION SELECT thread_id FROM pdu where thread_id is not null UNION SELECT DISTINCT thread_id FROM cellbroadcast where thread_id is not null)
05-23 19:08:34.487 E/AndroidRuntime(16093): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:179)
05-23 19:08:34.487 E/AndroidRuntime(16093): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:135)
05-23 19:08:34.487 E/AndroidRuntime(16093): at android.content.ContentProviderProxy.delete(ContentProviderNative.java:547)
05-23 19:08:34.487 E/AndroidRuntime(16093): at android.content.ContentResolver.delete(ContentResolver.java:1684)
05-23 19:08:34.487 E/AndroidRuntime(16093): at com.simplemobiletools.smsmessenger.extensions.ContextKt.deleteConversation(Context.kt:460)
05-23 19:08:34.487 E/AndroidRuntime(16093): at com.simplemobiletools.smsmessenger.adapters.ConversationsAdapter.deleteConversations(ConversationsAdapter.kt:99)
05-23 19:08:34.487 E/AndroidRuntime(16093): at com.simplemobiletools.smsmessenger.adapters.ConversationsAdapter.access$deleteConversations(ConversationsAdapter.kt:26)
05-23 19:08:34.487 E/AndroidRuntime(16093): at com.simplemobiletools.smsmessenger.adapters.ConversationsAdapter$askConfirmDelete$1$1.invoke(ConversationsAdapter.kt:86)
05-23 19:08:34.487 E/AndroidRuntime(16093): at com.simplemobiletools.smsmessenger.adapters.ConversationsAdapter$askConfirmDelete$1$1.invoke(ConversationsAdapter.kt:26)
05-23 19:08:34.487 E/AndroidRuntime(16093): at com.simplemobiletools.commons.helpers.ConstantsKt$ensureBackgroundThread$1.run(Constants.kt:314)
05-23 19:08:34.487 E/AndroidRuntime(16093): at java.lang.Thread.run(Thread.java:764)
05-23 19:08:34.493 W/ActivityManager( 803): Force finishing activity com.simplemobiletools.smsmessenger/.activities.MainActivity
from simple-sms-messenger.
ltguillaume
commented on May 29, 2024
Thought I'd see what happened if I sent a msg from within Simple SMS Messenger (5.1.3):
I just wrote a new message to a number that wasn't listed yet, sent it, then removed the conversation. When I closed and reopened Simple SMS Messenger, the message was indeed gone, but the conversation was still listed, including the message preview of the deleted message.
from simple-sms-messenger.
ltguillaume
commented on May 29, 2024
I had enough of it, so I just pm clear com.android.providers.telephony'd and restarted. We'll see if this behavior will come back some day. If so, I'll reopen the issue with more info.
from simple-sms-messenger.
Related Issues (20)
- Trash not working HOT 1
- [FEATURE] Option to disable opening links HOT 1
- False ASCI/UTF Decoding | Message in Chinese characters HOT 1
- Exporting Messages causes crash HOT 3
- Make it possible to disable MMS HOT 1
- Make numbers clickable as links to open dialer app HOT 3
- Display scheduled messages in conversations list HOT 2
- BUG: No way to save when multiple images in same MMS HOT 1
- Multiple notifications (reminders) HOT 1
- Notification in conversation view HOT 1
- Requesting user for biometric fingerprint anomaly on Pixel 8 / Android 14 HOT 1
- spouted as ad free, but contains ads HOT 5
- License Violation : The binary app on GooglePlay store doesn't comply GPLv3 license. HOT 2
- Dealng with dual sim HOT 1
- Picture thumbnail, should show whole resized image rather than crop out excess pixels
- Change application name in app drawer from "SMS messenger" to "Simple SMS messenger"
- Bug : Draft sometimes cannot be deleted and keeps coming back HOT 1
- Notify when contact is starred in Do Not Disturb's priority only mode
- Simple SMS Messenger
- Simple SMS Messenger HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from simple-sms-messenger.