SMS incoming problem ... solution !!! - Hero, G2 Touch General

Hi there.
I had problem with sms-messages after modaco-2.2 flashing.
When I got sms-message phone made sound and vibration but nothing to read in message program.
After reading couple hundred pages I found solution:
(Before you do this remember that this distroys your old mms and sms archive )
1. I found and downloaded adb.zip file and extracted it. You can get it from attacement. ( nope ... I can't upload it here )
2. Then I turned phones debugging on ( home-> menu-> settings-> Applications-> Developement -> USB debugging on
3. Wired phone to my mac
4. Opened terminal and then went to that directory where I extracted adb.zip
5. First checked device with command
./adb device
6. When everything was ok then shell command
./adb shell
7. Now prompt was #
8. Changed directory with command
# cd /data/data/com.android.providers.telephony/databases
9. Look that there was mmssms.db
# ls mmssms.db
10. Erased that file
# rm mmssms.db
11. Went out from shell
# exit
12. Went out from terminal
exit
13. Rebooted my phone and then everythin worked perfect.
I think that old mmssms.db file was different format than new one and thats why message-program could't use it.
I hope that this helps somebody.
...Lasse...

worked perfectly for me, thanks a lot of the tip!

The database from 2.73.405.5 build got a lot of changes to the old one (1.76.405.6). So it does not work to copy back the old Database after an update. I imported my old Mails manual to the new databasefile by accessing the database directly.

patzek said:
The database from 2.73.405.5 build got a lot of changes to the old one (1.76.405.6). So it does not work to copy back the old Database after an update. I imported my old Mails manual to the new databasefile by accessing the database directly.
Click to expand...
Click to collapse
Could you please describe how you restored your old data? I know it's a SQLite database and manually changed data in it before updating, but my knowledge with SQLite ain't that great, so I don't know "the perfect" SQL manager and so on...
Any advice is highly appreciated!

For me it was really easy as i only have SMS messages in my Database. So i wrote a very simple windows-app that imports the old messages out of the old database-file into the new database.

i have read about this fix in a german forum. it doesn't seem to fix the issue completely. i would suggest to keep smstomailbox installed for a while so we can be sure this really is a permanent fix.

This fix (german forum) does not work because the database got also changes in other parts of the database than the sms table. only in import into the new format will work.

patzek said:
For me it was really easy as i only have SMS messages in my Database. So i wrote a very simple windows-app that imports the old messages out of the old database-file into the new database.
Click to expand...
Click to collapse
Yes, I used your method when migrating from Windows to Android. It worked great and it was me who wrote directions for Notepad++ on how to change dates to proper format with regexp for other countries
Although, with the new Hero ROM database ROM seems to have changed in such a way that old message collides with new database/table structure. I will transfer new database to my computer and do some research soon.

sibbor said:
Yes, I used your method when migrating from Windows to Android. It worked great and it was me who wrote directions for Notepad++ on how to change dates to proper format with regexp for other countries
Although, with the new Hero ROM database ROM seems to have changed in such a way that old message collides with new database/table structure. I will transfer new database to my computer and do some research soon.
Click to expand...
Click to collapse
The SMSImport Application was done to import my SMS Messages from Windows Mobile. The application is based on the 1.76 Rom SMS Database.
After my Update to 2.73 is was in the same situation, how to get the messages into the new Databaseformat and so i wrote a second little application that just make a transfer from the old databsefile to the new databasefile Quick and Dirty

sibbor said:
Yes, I used your method when migrating from Windows to Android. It worked great and it was me who wrote directions for Notepad++ on how to change dates to proper format with regexp for other countries
Although, with the new Hero ROM database ROM seems to have changed in such a way that old message collides with new database/table structure. I will transfer new database to my computer and do some research soon.
Click to expand...
Click to collapse
patzek said:
The SMSImport Application was done to import my SMS Messages from Windows Mobile. The application is based on the 1.76 Rom SMS Database.
After my Update to 2.73 is was in the same situation, how to get the messages into the new Databaseformat and so i wrote a second little application that just make a transfer from the old databsefile to the new databasefile Quick and Dirty
Click to expand...
Click to collapse
Come on guys, lets share these about...
I have to migrate my brothers contacts from his Diamond to his Hero, he's on the 1.76 rom at the minute but will be upgrading to 2.73 later on.
I then have to import my messages from my old 1.76 database to my 2.73 database.

patzek said:
The SMSImport Application was done to import my SMS Messages from Windows Mobile. The application is based on the 1.76 Rom SMS Database.
After my Update to 2.73 is was in the same situation, how to get the messages into the new Databaseformat and so i wrote a second little application that just make a transfer from the old databsefile to the new databasefile Quick and Dirty
Click to expand...
Click to collapse
Ah, sorry I missunderstood. Please share your dirty solution with us ;-)! Btw, can one merge the old structure with the new one (two databases) and keep data intact from both? Or is it just a conversation from old to new structure, where you keep old messages? Either way, sounds great! I can manually add messages that I recieved in my new database "manually" afterwards

i will try to make an sql update script that will update the structure from the old database to the new one.

so i make a quick compare of the database files from a wiped hero 1.76 rom and an wiped 2.73 hero rom. the only difference is the column "index_on_sim" in the table "sms" as an integer field. an simple "alter table sms add index_on_sim integer null" would fix this. i think this field will store the id of an contact which is on the sim card stored, otherwise its value is "null" on messages that was sended and "-1" on messages that was received.
there are hugher differences between a normal android sms database and the hero one and and "easy" upgrade is not possible. its necessary to add columns to different tables and it is also necessary to have them in the right possition so that when a application try to access the column by the index and not with the column name it uses the right one. maybe there is a application in the www available that makes an automatic database update. for other databases like ms sql server there are solutions available...

patzek said:
so i make a quick compare of the database files from a wiped hero 1.76 rom and an wiped 2.73 hero rom. the only difference is the column "index_on_sim" in the table "sms" as an integer field. an simple "alter table sms add index_on_sim integer null" would fix this. i think this field will store the id of an contact which is on the sim card stored, otherwise its value is "null" on messages that was sended and "-1" on messages that was received.
there are hugher differences between a normal android sms database and the hero one and and "easy" upgrade is not possible. its necessary to add columns to different tables and it is also necessary to have them in the right possition so that when a application try to access the column by the index and not with the column name it uses the right one. maybe there is a application in the www available that makes an automatic database update. for other databases like ms sql server there are solutions available...
Click to expand...
Click to collapse
Yes, I've made this conclusion too. I've now merged my entire MMS/SMS database:
1) I exported both the 1.76 db and the 2.73 db as SQL dumps
2) Merged them together and got rid of lots of messed up data. Also I had to fix formatting for strings for the application to be able to import it properly again. Changed some ID's too.
3) Then I truncated the tables "sms" & "threads" + made minior fixes around the database (clean-up). and made changes to other ID's for it to look cleaner.
Since I've done SMS migration like this: Nokia > Windows Mobile > Android (Hero, v1.76) > Android (Hero, 2.73) there was some differences within the database. I fixed number formatting + updated data in proper places. Ex. sms.toa + sms.sc_toa (145 for one person and 0 for me), sms.person to correct ID for the contact (since there was diffs between the two Android databases and no person ID at all for earlier merged databases; Nokia + WM).
Side note: it seems sms.index_on_sim should be NULL for outgoing SMS'es and -1 for incoming (that's not stored on SIM card).
Also I added correct ID to the sms.person column for all my old SMS'es. First

Tx uttila for the sms problem solution
@uttila: it worked fine for me and my htc hero. I erased the database table mmssms.db and now it saves the messages

I have the Sprint version of the HTC Hero, Just got it a few days ago. I started noticing in about my second day having the phone that I wasnt receiving texts either. Same problem as everyone else, could send, make calls, receive calls, etc. Just couldnt recieve texts. After a while, i will eventually be able to recieve again, usually because I restart the phone, or that could just be a coincidence. But nevertheless I dont recieve any of the "lost" texts.
I just got off the phone with customer service with Sprint, They had me turn the phone off, take the battery out, and were doing some "updates" on their end. And then tried to send a text to me after turning it back on. They werent able to resolve the problem. They are telling me to take it to a Sprint store, so that they can run some tests on the phone, and send it off for a replacement.
I mentioned to the customer service rep that I've read about this problem online, that alot of people seem to be having the same problem. His response was "Yeah, I have been receiving some calls, but not to the point where we would consider it a known issue"
So I guess thats where we stand right now. Is there someway that I can fix it on my end, or is there an update out from HTC that resolve's this. Because it doesn't seem to just be a Sprint issue, since people overseas in Europe with different providers are having the same issue. So I'm guessing its a software\hardware issue, and not a network problem.
Any solutions?

Same Issue here.... about to send it back!
From Sprint's actual Hero forum users are reporting the same issue...
http://community.sprint.com/baw/thread/22913?start=30&tstart=0&reqsorting=dec
Hope posting this link is ok
Additionally it seems like some files are not being removed when performing a factory reset as I had installed a sound board and after two factory resets I noticed some sound files were still on my phone. TO me this indicates not all files are being removed correctly. I doubt the sound board messed anything up but this may indicate another app inadvertently did and the factory reset isn't cutting it as far as fixing the issue. Called Sprint and they offered to replace for free and also refreshed my syst settings which had zero impact.

Related

Read SMS

Hello!
I have some difficulties to read SMS in my application : my application doesn't want to use the fonction SmsOpen in mode RECEIVE. Do you know the parameters to use in this function to read Sms?
Gremlins (and I'm not Gizmo!)
funny as Gizmo asked me exact the same question via private mail ...
This was my response:
----------------------------------------
I've never used the function to read SMS messages but here is my suggestion:
check the return code of SmsOpen, it is probably SMS_E_RECEIVEHANDLEALREADYOPEN. According the SDK help it means, that another app has already opened and is using the provider. In most cases, that might be Inbox, so shut down the Inbox task befor you are running your code.
If your error code is different, check the meaning in the help file, look for SmsOpen -> SMS specific error codes.
You don't have disable Inbox. The problem is the internal SMS handler - if you look in \Windows\Startup, you'll see a SMSHandler (I don't have a T-Mobile at the moment, so can't confirm the exact name). You need to get your application to start before it. In addition, you need to do a SmsSetMessageNotification() for both SMS_MSGTYPE_RAW as well as SMS_MSGTYPE_TEXT message types. Strangely, the code does not get the notification if you only set it for one of the two.
I have a T-Mobile MDA. There is a folder called "AutoStart" in the Windows folder, so I guess the file called "SMSReceiver.exe" is the handler you were talking about. I named my application "aaamyapplication" in order to start it up first after a soft reset (There is actually no "startup" registry-entry either for "SMSReceiver" nor for my application... in the end I kicked "SMSReceiver" out).
Unfortunately receiving an SMS through my app does not work (but strangely the system is still able to receive SMS in spite of deleting "SMSReceiver").
Do you have a good guess what I should do? I would be grateful for any advice
t_lex
Could some body be more specific on what Jvd said ??? i'm running an XDA2 and when i look in windows/startup i only get the followng :
CheckAutoRun
ChgDfLnk
IA_Caller_ID
MMReg
poutlook
stk
wifiIcon

"Speed-dial Broken But Repaired" Error

Every time I go to use Speed-dial, I get the message 'Speed-dial was broken and has been repaired.' Once I hit OK, it dials the number fine. Whenever I look at my speed-dial list, it appears fine. Anyone else have this happen? Any solution you found. It's not that big of a deal but the purpose of speed-dial is speed, not navigating messageboxes.
Any help would be appreciated.
db
dcbehan said:
Every time I go to use Speed-dial, I get the message 'Speed-dial was broken and has been repaired.' Once I hit OK, it dials the number fine. Whenever I look at my speed-dial list, it appears fine. Anyone else have this happen? Any solution you found. It's not that big of a deal but the purpose of speed-dial is speed, not navigating messageboxes.
Any help would be appreciated.
db
Click to expand...
Click to collapse
Same error here. Anyone have a solution.
Not a solution but a question/hint towards collobrative discovery...
Are you backing up & restoring your XDA or databases etc?
Normally I do not get this message on a regular basis. I use SpriteBackup to backup the database file called speed.db. This database contains the speed dial entries. Each time I restore this database I get the error you mention.
It appears that the speed dial list is simply a list of references to Contacts database positions. Somehow the system must be tracking whether either of the two databases have been "touched" and then put it into the recovery mode mentioned. I guess the trick is to detect this change and counter it if needed.
Just pure speculation so please forgive me this is all rubbish and useless information.
k_kirk said:
Not a solution but a question/hint towards collobrative discovery...
Are you backing up & restoring your XDA or databases etc?
Normally I do not get this message on a regular basis. I use SpriteBackup to backup the database file called speed.db. This database contains the speed dial entries. Each time I restore this database I get the error you mention.
It appears that the speed dial list is simply a list of references to Contacts database positions. Somehow the system must be tracking whether either of the two databases have been "touched" and then put it into the recovery mode mentioned. I guess the trick is to detect this change and counter it if needed.
Just pure speculation so please forgive me this is all rubbish and useless information.
Click to expand...
Click to collapse
Interesting speculation K_Kirk, I backup using Sprite Clone and ActiveSync backup\restore function every few days. Maybe their is a connection.
I use Backup Manager daily for backup but have not restored recently. What I did do that seems to work is delete all the speeddials and redo them (as I only had three it was no big deal). Since I did that, I haven't had any problem.
The restore question indeed may be on the right track thought I'm not sure what you'd do about it other than start again.
db
I don't use Sprite nor do I backup via AS and I get the error regularly.
The speed dial database is indeed a collection of OID links to the contacts database.
restoring your databases, by any means (except raw mode in sprite clone), causes the OID's of database records to change, breaking this link.
Sprite Backup repairs the link on restore, however, when you next synchronise with Active Sync, a full resync is performed because of the OID changes, and Active Sync does not patch the SpeedDial database appropriately.
if the OID link appears invalid on use, in 2003, it matches them up via name ot the contacts database, hense the "broken but fixed" message.
[email protected] can send you a speedmatch.exe that does this to all speed dial links, perhaps if it can be made to run automatically after any active sync activity then you'll never see that message again.
You don't NEED to backup and restore to see this message however, Activesync quite commonly deletes and re-creates altered contacts, breaking any speeddial links to them.
..belial..

Restoring SMS from MPB files?

Hi,
Prior to upgrading to 2003SE, I copied the contents of the Messaging folder to my PC and then back again after the upgrade.
My belief that this would retain my SMS messages was wrong - is there any way for me to restore my SMS messages from the MPB files?
I've searched the forum over and over but can only usually find references to Sprite or other backup/restore facilities - they would've been fine for me if I'd used them prior to the upgrade, but since I didn't the only way I'm able to restore is to somehow get them from the MPB files.
Any thoughts?
maybe here
http://forum.xda-developers.com/viewtopic.php?t=21681&highlight=
or you can try dbExplorer
AllExport
Unfortunately AllExport doesn't work for me. I guess I'll give dbExplorer a punt, but again I don't think that will work as I didn't use it to export them in the first place. All I have are a whole bunch of MPB files.
try google for the format and possible programs to access such files
http://filext.com/
Database gone
Turns out I should've also copied/exported a particular database file from the XDA before I upgraded the OS.
Guess I've lost it now, for whilst I have the messages themselves I don't have the message headers (they are contained in said database).
In a word... bugger.
I've got a similar problem...
I've both mpb and database but they seem to be unbound
I can see header from one side and contents form the other...but no way to recover the complete functionality...
Guess we'va lost everything!
Gone gone gone
Wow, interesting that even preserving the db and the mpb files doesn't help you out.
Strikes me as pretty stupid. Whilst I haven't used them because of my current problem, has anyone been able to export and import SMS (particularly imported to a new installation / fresh upgrade) using one of the existing programs (Sprite, dbexplorer) WITHOUT losing SMS functionality (as Sprite seems to do) or having to manually stuff around with databases? Interested for future reference (as in, if I decide to up to WM2005 when it gets relatively stable).

Auto backup of sms

Hi,
I'm looking fo a software that backup the SMS in real time, not scheduled once or twice a day
I mean that the SMS received and sent are stored elsewhere from the poutlook as they arrive
Is there a way to do this ?
I don't know if such a tool exists; however how much cpu and battery time would this take if it was constantly backing up in real time?
WB
I don't think that it would use more that other app'
I mean it stay in memory load as a service or something like that and when an SMS is sent or received (a new entry in the database) the software will just store it in a text file a something like that
I don't mean a complete backup but one by one...
For a simple implementation have a look at this:
http://www.cjcraft.com/blog/2008/06/17/30DaysOfNETWindowsMobileApplicationsDay16SMSLogger.aspx
I'm currently implementing something similar but instead of putting the sms into a text file (like in this example) I'm storing them into a sql table so that further analysis can easily be made (sort/count by sender, ...).
Some feature like autostart after reset would also be nice.
Any other ideas?
P.S.: Unfortunately I still haven't found a way to also get notified when sending messages.
heliosdev said:
For a simple implementation have a look at this:
http://www.cjcraft.com/blog/2008/06/17/30DaysOfNETWindowsMobileApplicationsDay16SMSLogger.aspx
I'm currently implementing something similar but instead of putting the sms into a text file (like in this example) I'm storing them into a sql table so that further analysis can easily be made (sort/count by sender, ...).
Some feature like autostart after reset would also be nice.
Any other ideas?
P.S.: Unfortunately I still haven't found a way to also get notified when sending messages.
Click to expand...
Click to collapse
I know that the sms data are stored in the cemail files in the root of the device.
Scanning the database (it's a database) every x minutes.... (to heavy I think)
There is no event that is catchable like RS232 connect, syncronisation, alarme.... ???
heliosdev said:
For a simple implementation have a look at this:
http://www.cjcraft.com/blog/2008/06/17/30DaysOfNETWindowsMobileApplicationsDay16SMSLogger.aspx
I'm currently implementing something similar but instead of putting the sms into a text file (like in this example) I'm storing them into a sql table so that further analysis can easily be made (sort/count by sender, ...).
Some feature like autostart after reset would also be nice.
Any other ideas?
P.S.: Unfortunately I still haven't found a way to also get notified when sending messages.
Click to expand...
Click to collapse
Hi, can you please share your sql table create/read/update code in VB .NET?
For sent sms notification, there is a way to do this using inthehand api's professional editon.

"Old" SMS Application for HD2?

Hi. I'd need the option to use the old Application for managing the SMS Store.
Does anybody know if it is incorporated in HD2-Roms but hidden, or if the old application from a 6.1 ROM would work on HD2?
Backgroud: I used to created subfolders under Inbox and sent messages as an archive for all SMS I get and send. Every year I export them with PIMBackup and save the resulting file to a safe place.
Now, with the new messaging-application I'm not able to change the folders anymore. The subfolders are still there (I see them in PIMBackup when trying to create a backup), but I can't access them.
Take a look here
Cheers.
Oh thank you.
I must have defined my searches wrong, cause I missed that posting
EDIT: Oh, thank you again. You made me edit the registry and I mistankely changed the Name "System" und HKLM to "e" and I couldn't change it back. :S
Since it is one of the most important keys in the registry, only a hard-reset brought my HD2 back to life.
Well, it was not so bad at all. I have all my data as a backup.
Actually, it was kinda funny to see what the device does when you edit the registry and make a mistake.

Categories

Resources