@
ivanchou 原生短信里面能看到旧的短信， AirDroid 也可以看到旧短信，但是都没有新短信。
@
echopan 已经设置为了默认， google 账号同步一直开着，虽然一直 s+s ，但是还是觉得网络不太好，换机一直都是手动备份还原。
@
l8mEQ331 今天在 v2 看到了 messenger 的帖子，就打算试一下，结果就碰到了这个问题。
查 log ， sqlite 报错： android.database.sqlite.SQLiteException: no such column: sub_id (code 1): , while compiling: SELECT _id, type, address, body, date, thread_id, status, read, seen, date_sent, sub_id FROM sms WHERE ((type IN (1, 4, 6, 5, 2)) AND date>=1469758098175 AND date<1469758474248) ORDER BY date DESC
数据库格式不对？ sub_id 是什么列？
···
07-29 10:14:34.987 1860-3699/? E/DatabaseUtils﹕ Writing exception to parcel
android.database.sqlite.SQLiteException: no such column: sub_id (code 1): , while compiling: SELECT _id, type, address, body, date, thread_id, status, read, seen, date_sent, sub_id FROM sms WHERE ((type IN (1, 4, 6, 5, 2)) AND date>=1469758098175 AND date<1469758474248) ORDER BY date DESC
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:891)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:502)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)
at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:400)
at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:294)
at com.android.providers.telephony.SmsProvider.query(SmsProvider.java:311)
at android.content.ContentProvider.query(ContentProvider.java:1014)
at android.content.ContentProvider$Transport.query(ContentProvider.java:228)
at com.zte.ZTESecurity.ZTETransport.query(ZTETransport.java:57)
at android.content.ContentProviderNative.onTransact(ContentProviderNative.java:112)
at android.os.Binder.execTransact(Binder.java:446)
07-29 10:14:34.987 12393-12482/? E/Bugle﹕ SqliteWrapper: catch an exception when query
07-29 10:14:34.997 12393-12482/? E/Bugle﹕ android.database.sqlite.SQLiteException: no such column: sub_id (code 1): , while compiling: SELECT _id, type, address, body, date, thread_id, status, read, seen, date_sent, sub_id FROM sms WHERE ((type IN (1, 4, 6, 5, 2)) AND date>=1469758098175 AND date<1469758474248) ORDER BY date DESC
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:181)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:137)
at android.content.ContentProviderProxy.query(ContentProviderNative.java:421)
at android.content.ContentResolver.query(ContentResolver.java:478)
at android.content.ContentResolver.query(ContentResolver.java:422)
at com.google.android.apps.messaging.shared.mmslib.a.aJW(SourceFile:40)
at com.google.android.apps.messaging.shared.datamodel.action.M.<init>(SourceFile:434)
at
com.google.android.apps.messaging.shared.datamodel.action.X.US(SourceFile:119)
at
com.google.android.apps.messaging.shared.datamodel.action.SyncMessagesAction.Uz(SourceFile:285)
at
com.google.android.apps.messaging.shared.datamodel.action.SyncMessagesAction.Sn(SourceFile:236)
at com.google.android.apps.messaging.shared.datamodel.action.BackgroundWorkerService.Wi(SourceFile:134)
at com.google.android.apps.messaging.shared.datamodel.action.BackgroundWorkerService.onHandleIntent(SourceFile:111)
at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:135)
at
android.os.HandlerThread.run(HandlerThread.java:61)
07-29 10:14:34.997 12393-12482/? W/Bugle﹕ SyncCursorPair: Remote SMS query returned null cursor; need to cancel sync
07-29 10:14:34.997 12393-12482/? A/BugleDataModel﹕ wtf
SyncMessagesAction: unexpected failure in scan
java.lang.RuntimeException: Null cursor from remote SMS query
at com.google.android.apps.messaging.shared.datamodel.action.M.<init>(SourceFile:445)
at
com.google.android.apps.messaging.shared.datamodel.action.X.US(SourceFile:119)
at
com.google.android.apps.messaging.shared.datamodel.action.SyncMessagesAction.Uz(SourceFile:285)
at
com.google.android.apps.messaging.shared.datamodel.action.SyncMessagesAction.Sn(SourceFile:236)
at com.google.android.apps.messaging.shared.datamodel.action.BackgroundWorkerService.Wi(SourceFile:134)
at com.google.android.apps.messaging.shared.datamodel.action.BackgroundWorkerService.onHandleIntent(SourceFile:111)
at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:135)
at
android.os.HandlerThread.run(HandlerThread.java:61)
07-29 10:14:34.997 12393-12482/? A/BugleDataModel﹕ SyncMessagesAction: unexpected failure in scan
java.lang.RuntimeException: Null cursor from remote SMS query
at com.google.android.apps.messaging.shared.datamodel.action.M.<init>(SourceFile:445)
at
com.google.android.apps.messaging.shared.datamodel.action.X.US(SourceFile:119)
at
com.google.android.apps.messaging.shared.datamodel.action.SyncMessagesAction.Uz(SourceFile:285)
at
com.google.android.apps.messaging.shared.datamodel.action.SyncMessagesAction.Sn(SourceFile:236)
at com.google.android.apps.messaging.shared.datamodel.action.BackgroundWorkerService.Wi(SourceFile:134)
at com.google.android.apps.messaging.shared.datamodel.action.BackgroundWorkerService.onHandleIntent(SourceFile:111)
at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:135)
at
android.os.HandlerThread.run(HandlerThread.java:61)
···