mirror of
https://github.com/jberkel/sms-backup-plus.git
synced 2026-04-25 17:05:59 +03:00
[GH-ISSUE #214] Crash when calculating. #179
Labels
No labels
AM+RCS
FAQ
awaiting response
backup
bespoke
bug
calendar
call log
cannot reproduce
cloudless
device-specific
documentation
dual- & multi-SIM
duplicate
feature-request
fixed in beta
good first issue
half-missing
help wanted
helpful
meta
misattribution
mms
other message sources
pull-request
question
rejuvenation
restore
schedule
security
stale
task
thanks
v1.5.1
v1.5.10
v1.5.11
v1.5.2
v1.5.3
v1.5.3
v1.5.4
v1.5.4
v1.5.5
v1.5.5
v1.5.6
v1.5.7
v1.5.8
v1.5.9
v1.6β
xoauth
~$ bounty $~
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
starred/sms-backup-plus-jberkel#179
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @discomm on GitHub (Feb 4, 2012).
Original GitHub issue: https://github.com/jberkel/sms-backup-plus/issues/214
Below is crash report under /data/.../.../...
file name is: 1328330665000-approved.stacktrace
SMS Backup+ 1.4.5
Android Ver: 2.3.5
Kernel Ver:2.6.35.7-perf+
Phone model is : ZTE U960 (project name as skate, a Dual SIM Card cell phone)
there is only 2 message in my sms box, 1 for sim card1, 1 for sim card2.
Let me know if you needs sms box for analyze ?
----begin of file----
D/dalvikvm(12584): GC_FOR_MALLOC freed 9428 objects / 771376 bytes in 599ms
D/ACRA (13232): Writing crash report file.
D/ACRA (13232): Looking for error files in /data/data/com.zegoggles.smssync/files
D/dalvikvm(13232): GC_FOR_MALLOC freed 7558 objects / 492976 bytes in 89ms
D/NativeCrypto(13232): Freeing OpenSSL session
E/AndroidRuntime(13232): FATAL EXCEPTION: AsyncTask #1
E/AndroidRuntime(13232): java.lang.RuntimeException: An error occured while executing doInBackground()
E/AndroidRuntime(13232): at android.os.AsyncTask$3.done(AsyncTask.java:200)
E/AndroidRuntime(13232): at java.util.concurrent.FutureTask$Sync.innerSetException(FutureTask.java:273)
E/AndroidRuntime(13232): at java.util.concurrent.FutureTask.setException(FutureTask.java:124)
E/AndroidRuntime(13232): at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:307)
E/AndroidRuntime(13232): at java.util.concurrent.FutureTask.run(FutureTask.java:137)
E/AndroidRuntime(13232): at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1068)
E/AndroidRuntime(13232): at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:561)
E/AndroidRuntime(13232): at java.lang.Thread.run(Thread.java:1096)
E/AndroidRuntime(13232): Caused by: android.database.sqlite.SQLiteException: unknown error: Unable to convert BLOB to string
E/AndroidRuntime(13232): at android.database.CursorWindow.getString_native(Native Method)
E/AndroidRuntime(13232): at android.database.CursorWindow.getString(CursorWindow.java:329)
E/AndroidRuntime(13232): at android.database.AbstractWindowedCursor.getString(AbstractWindowedCursor.java:49)
E/AndroidRuntime(13232): at android.database.CursorWrapper.getString(CursorWrapper.java:135)
E/AndroidRuntime(13232): at com.zegoggles.smssync.CursorToMessage.cursorToMessages(CursorToMessage.java:172)
E/AndroidRuntime(13232): at com.zegoggles.smssync.SmsBackupService$BackupTask.backup(SmsBackupService.java:268)
E/AndroidRuntime(13232): at com.zegoggles.smssync.SmsBackupService$BackupTask.doInBackground(SmsBackupService.java:159)
E/AndroidRuntime(13232): at com.zegoggles.smssync.SmsBackupService$BackupTask.doInBackground(SmsBackupService.java:105)
E/AndroidRuntime(13232): at android.os.AsyncTask$2.call(AsyncTask.java:185)
E/AndroidRuntime(13232): at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:305)
E/AndroidRuntime(13232): ... 4 more
W/ActivityManager( 1362): Force finishing activity com.zegoggles.smssync/.SmsSync
I/WindowManager( 1362): updateFocusedWindowLocked newFocus=Window{45fb9548 com.zegoggles.smssync/com.zegoggles.smssync.SmsSync paused=true} mode=0 mCurrentFocus = Window{45fb9548 com.zegoggles.smssync/com.zegoggles.smssync.SmsSync paused=true}
I/ActivityThread(13232): enter process activity msg = 102
----end of file----
@discomm commented on GitHub (Feb 13, 2012):
I downloaded the mmssms.db to my box and try to read it by sqlite3
$ sqlite3 mmssms.u960.db
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .table
Error: file is encrypted or is not a database
sqlite> .schema
Error: file is encrypted or is not a database
sqlite>
sms is still readable on my phone, so ... so I guess vendor customize the sms database. //sad
@jberkel commented on GitHub (Feb 13, 2012):
can you access other databases from the phone ok?
@discomm commented on GitHub (Feb 13, 2012):
I tried couple databases, some works good with sqlite, some don't. Which wrong looks like all comes from vendor (guess those app already been customized).
same error on telephony.db
$ sqlite3 telephony.db
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema
Error: file is encrypted or is not a database
sqlite>
[5]+ Stopped sqlite3 telephony.db
same error on another vendor customize app's db :
/data/data/zte.com.cn.alarmclock/databases/alarms.db
$ sqlite3 alarms.db
sqlite> .schema
Error: file is encrypted or is not a database
sqlite>
[8]+ Stopped sqlite3 alarms.db
Works good on:
/mnt/sdcard/Android/data/com.disney.WMWLite/files/water-Lite.db (Where is my water lite ver.)
$ sqlite3 water-Lite.db
sqlite> .schema
CREATE TABLE "Achievements" ("Points" INTEGER NOT NULL , "ID" TEXT PRIMARY KEY NOT NULL UNIQUE , "Hidden" INTEGER NOT NULL DEFAULT 0, "PreEarnedDescription" TEXT NOT NULL , "EarnedDescription" TEXT NOT NULL , "Image" TEXT NOT NULL , "PercentComplete" FLOAT NOT NULL DEFAULT 0, "SortingGroup" INTEGER NOT NULL DEFAULT 0);
CREATE TABLE "CollectibleInfo" ("ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE , "Unlocked" BOOL NOT NULL DEFAULT 0, "Basename" TEXT, "HasViewed" BOOL NOT NULL DEFAULT 0);
CREATE TABLE "LevelInfo" ("ID" INTEGER PRIMARY KEY NOT NULL ,"Name" TEXT NOT NULL ,"Filename" TEXT NOT NULL ,"Stars" INTEGER NOT NULL DEFAULT (0) ,"PackName" TEXT,"TimesPlayed" INTEGER NOT NULL DEFAULT (0) ,"TimesFinished" INTEGER NOT NULL DEFAULT (0) ,"Unlocked" BOOL NOT NULL DEFAULT (0) , "ParTime" FLOAT NOT NULL DEFAULT 15.0, "BestScore" INTEGER NOT NULL DEFAULT 0, "CollectibleFound" INTEGER NOT NULL DEFAULT -1, "PlayTime" INTEGER NOT NULL DEFAULT 0, "TimesRetried" INTEGER NOT NULL DEFAULT 0, "IgnoreInStarCount" BOOL NOT NULL DEFAULT 0, "Type" INTEGER DEFAULT 0, "StartDate" DATETIME, "EndDate" DATETIME);
CREATE TABLE "LevelPackInfo" ("ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE , "PackName" TEXT NOT NULL DEFAULT LP_, "Unlocked" BOOL NOT NULL DEFAULT 0, "HasPlayed" BOOL NOT NULL DEFAULT 0, "StarsRequired" INTEGER DEFAULT 30, "TileTexture" TEXT NOT NULL DEFAULT tile_world_01, "LightingColor" TEXT NOT NULL DEFAULT "255 255 255", "CurtainTexture" TEXT NOT NULL DEFAULT shower_curtain_01, "LockColor" TEXT NOT NULL DEFAULT "255 255 255", "HasAlerted" BOOL NOT NULL DEFAULT 0, 'PackType' INTEGER NOT NULL DEFAULT 0, 'Hidden' BOOL NOT NULL DEFAULT 0, 'PackIcon' TEXT, 'StartDate' DATETIME, 'EndDate' DATETIME);
CREATE TABLE "PlayerData" ("ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , "EventName" TEXT NOT NULL , "EventValue" INTEGER NOT NULL , EventStringValue TEXT);
CREATE TABLE "Settings" ("Name" TEXT NOT NULL UNIQUE , "Value" INTEGER NOT NULL DEFAULT 1);
sqlite>
[9]+ Stopped sqlite3 water-Lite.db
@jberkel commented on GitHub (Jun 30, 2013):
this is fixed now