Immediate help - G1 Q&A, Help & Troubleshooting

this is for legal reasons. where exactly are sms messages stored? a lot depends on this!

I don't remember where exactly they are, but I think we have an app that can back them up. Even if you find them though they will be in a weird format

corp769 said:
this is for legal reasons. where exactly are sms messages stored? a lot depends on this!
Click to expand...
Click to collapse
Texts are stored in a database file located here in this directory:
Code:
/data/data/com.android.providers.telephony/databases
the name of the database file you want is called mmssms.db
To get it from your phone enter this code in terminal:
Code:
su
cp /data/data/com.android.providers.telephony/databases/mmssms.db /sdcard
That should copy the file to your sd card then you can mount your sd card and pull the file off to your PC. To read the file, download sqlite studio, install it, add the database and you should be able to figure it out from there. Sqlite studio can be found here
http://sqlitestudio.one.pl/index.rvt

(Deleted)

Related

How to put ringonte (.mp3) into phone memory?

As above. Anyone knows?
bryant_16 said:
As above. Anyone knows?
Click to expand...
Click to collapse
put it in the media>ringtone folder.
bryant_16 said:
As above. Anyone knows?
Click to expand...
Click to collapse
Ok... I'll bite. Ringdroid from the market. Any other answer will take some info.
As in, the ringroid will put the ringtones in the sd card memory not the phone memory, i tried copy paste over but fail.
To place them into the phone memory you will need to either copy them using the terminal or push them through adb.
using adb, place the file(s) in your tools folder
Code:
adb push filename.mp3 /system/media/audio/ringtones
In the terminal, if you place them in the root of your sdcard
Code:
cp /sdcard/filename.mp3 /system/media/audio/ringtones
I am not sure if you need to remount or not to push/copy into the folder or not.
It says read-only file system as the error.
jairomeo said:
To place them into the phone memory you will need to either copy them using the terminal or push them through adb.
using adb, place the file(s) in your tools folder
Code:
adb push filename.mp3 /system/media/audio/ringtones
Click to expand...
Click to collapse
Try:
Code:
adb remount
That should fix the "read only" problem.
i'm not using adb... I'm using the second method which is in the terminal.
Do yourself a favor and go get Root Explorer from the market. It lets you move any file to anywhere.
Move your files to /system/media/audio/ringtones and remember to check to see if the files that are there are .ogg or .mp3. If they are .ogg just rename your files after you move them.
What you mean I have to rename the files after i move them?
What's the exact application name? I tried searching on market but could not find any.
bryant_16 said:
What's the exact application name? I tried searching on market but could not find any.
Click to expand...
Click to collapse
I like SUFBS but ES (or estrong) file explorer is good also. SUFBS cost a buck or 2 but I think it is worth it. Either way your phone needs to be rooted for this. You do have root right?
Yeah, phone is rooted. I tried ES Strong Explorer but cannot work, it says something about permission or something like that..
bryant_16 said:
What you mean I have to rename the files after i move them?
Click to expand...
Click to collapse
I'm not sure if it's a "hero thing" but sometimes the file extensions in the ringtones folder are not .mp3. They are .ogg. If you look into the folder and see .ogg files just change the extension and you'll be all good.
As for the apps. Look for "Root Explorer". I believe there are both free and paid options. The paid one isn't very much $$ so, considering how much easier it makes things, give up the loot and support a dev.
I tried searching under market, but cant find it..
id use terminal with cmds, would be a tad faster and a bit more reliable, in my opinion, but as of searching on your behalf i have found root explorer a paid version and estrongs free version by searching "root" while in the market. estrongs sounds unstable. If your going to pay for a good file explorer get SU file manager&terminal. (and...SAA?ror)
How do I use terminals? I tried but that say permission thingy..
Did you mount the system?
OK dude. If you're rooted I assume you have somebody's recovery. Boot to recovery and go into console (Alt+x). Now do this.
<enter>
mount /system <enter> (maybe mount /system/media if just /system doesn't work)
mount /sdcard <enter>
cp /sdcard/yourfolder/yourringtone.mp3 /system/media/audio/ringtones <enter>
reboot
You should be good to go.
Can I do that in terminal? As in one of the application in my HTC Dream?

Question about DB

So do I have any way to view/extract a SQL DB from the phone? I can view the DB using a SQL editor/viewer on the phone for Workout Assist but the Export Data function isn't working from the app. The file that it creates isn't a known file type. If I could get the raw data, I could import it into SQL and write the query myself to pull the data I need but I can't figure out how to get the darn data off the phone.
Thanks
Like copying to the sdcard or what exactly?
hah2110 said:
So do I have any way to view/extract a SQL DB from the phone? I can view the DB using a SQL editor/viewer on the phone for Workout Assist but the Export Data function isn't working from the app. The file that it creates isn't a known file type. If I could get the raw data, I could import it into SQL and write the query myself to pull the data I need but I can't figure out how to get the darn data off the phone.
Thanks
Click to expand...
Click to collapse
why not back up the database, preferences etc (files)?
evilkorn said:
Like copying to the sdcard or what exactly?
Click to expand...
Click to collapse
I need the DB that is powering Workout Assist on my computer.
britoso said:
why not back up the database, preferences etc (files)?
Click to expand...
Click to collapse
How can I backup the DB and extract the file?
They are stored in /data/data/_package_name_/.
I still don't know what you mean, you said you can read the DB, which implies you know the location of the file.
evilkorn said:
They are stored in /data/data/_package_name_/.
I still don't know what you mean, you said you can read the DB, which implies you know the location of the file.
Click to expand...
Click to collapse
Yes... But how can I GET the DB files to import into SQL? If I try and attach it to an e-mail from Root Explorer, it looks like it attaches, but nothing is sent?
Just copy it to /sdcard/...
adb
lots of other options.
That is the same question I asked you and you just said you needed the db file.
evilkorn said:
Just copy it to /sdcard/...
adb
lots of other options.
That is the same question I asked you and you just said you needed the db file.
Click to expand...
Click to collapse
Ok... Sorry if I confused you. I got the file to my PC but it isn't readable by anything... Any ideas?
You can download sqlite3 for your pc and open the database with that.
mlevin said:
You can download sqlite3 for your pc and open the database with that.
Click to expand...
Click to collapse
Yep - thats what I did.... Had to export everything though to Access and query that way since SQLite doesn't export query results.
Thx
hah2110 said:
How can I backup the DB and extract the file?
Click to expand...
Click to collapse
the db IS a file. Simply backup by copyin gthe .db file, and when you need to restore it, push it back.

[Q] SMS backup

Hey guys
Is there any PC applications for windows ors Linux that can save or backup SMS txt messages from my nexus one.
It's a forensics assignment and I was thinking of checking out android.
Any help would be awesome ^_^
You just have to pull the file from the phone using the tools in the SDK. adb pull and adb push the file back after you wipe.
http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=where+are+android+sms's+stored
the things to back up are:
/data/data/com.android.providers.telephony/databases/mmssms.db
/data/data/com.android.providers.telephony/app_parts/*
(app_parts contains any sms attachments. if you were to try to open a text with a picture in it and the appropriate app_parts/* was not there it would force close).
when restoring, if restoring to a fresh rom, you have to create the app_parts folder (as it does not initially exist -- it is created when the first mms is sent or received) and then put all of the files into it. also move the mmssms.db back to its original location. and make sure you set the permissions, owner and group back to the what they were when you pulled them.
you can open the mmssms.db with a sqlite database viewer.
Hey guys thanks so much ^_^ really appreciate it.
Would I need to root my phone in order to pull these DB files?
Probably, but maybe not... I can't test because I have always rooted.
to pull those files, maybe not. to push those files, probably yes.
try it
Code:
c:\android\tools>adb pull /data/data/com.android.providers.telephony/databases/mmssms.db c:\
failed to copy '/data/data/com.android.providers.telephony/databases/mmssms.db' to 'c:\/mmssms.db': Permission denied
c:\android\tools>
Thats the error that I get when I try it ... even if I tried doing ls -l /data/, I get this:
Code:
c:\android\tools>adb shell ls -l /data
opendir failed, Permission denied
c:\android\tools>
I just need to create a demonstration, could someone clean their txts messages DB and then get someone to send some messages, in order for me to show it to class, what would happen, if my droid was rooted.
I know there's an app called SMS Backup which basically reads this and dumps HTML output to email or screen but thats modifying the phone, which i will not have to do.
Or just use SMS Backup and Restore from the Market. It'll back up your SMS to an XML file on your SD which you can then transfer to your PC. Much easier. It just doesn't do MMS.
That's not forensic enough. If I ran adb root to restart in root mode, would that root it enough to void the warranty?
You could use MyBackup Pro. Once sms/mms's are backed up, they are in a zip file in the rerware folder of your SD card.
sigh >.< it seems that I cant forensically image /data/data/com.android.providers.telephony/databases/mmssms.db
so sad.. Need a rooted phone.

HTC Notes App

Hi, I’m having a problem with the HTC Notes App on my Rogers HTC One. I have backed up a copy of the folder ".data\HtcNotes" on the SD card, thinking that this folder contains all my notes files. I then wiped my phone and started setup as a new phone. I tried restoring my backed up notes by replacing the folder ".data\HtcNotes" with the one I had backed up earlier but the Notes App does not recognize the restored files. the Notes App works fine, i.e I can create new notes without any problems.
Also, when I try to open the "contentE.html" stored for each note inside subfolders of ".data\HtcNotes", I get unreadable characters. This happens for my new and properly functioning notes as well. Does the Notes App store content in a non-standard html format?. It used to be that the Notes app stored the content in a file called "content.html" which was a normally readable html format, but now it stores in the non-readable " "contentE.html" file.
Please advise how to recover the content of my notes...is there a way I can open the "contentE.html" files in a readable format?. My notes are not synched to the clouds and are stored only locally on the phone.
Thanks
any suggestions?
dabasdabas said:
any suggestions?
Click to expand...
Click to collapse
you may have to reset the permissions of the files
you do this with ES File Explorer and highlight a file go to properties and set the permissions ... usually to rw-r-r but notes files may be different check one you just created and make the old ones the same
thanks for the suggestion, I am able to open the "contentE.html" of my old notes using an html editor or browser, but the file contains unreadable characters, as if I'm opening a binary file inside a text editor. The same thing happens for any new notes I create.
I remember in earlier versions of Android, the Notes app used to store the content in a file called "content.html" which was a normally readable html format, but now it stores it in a "contentE.html" file which is not readable by html editors...
attached is an example of the "contentE.html" file from a new note I've just created, it's supposed to be titled "w1" and contain only the word hello...if you try to open it you'll understand what I'm trying to describe...can you guys please check the "contentE.html" on your phone and let me know if you're able to open the file properly outside the Notes app...thanks...
guys need your help...can anyone please check the "contentE.html" located in numeric subfolders under ".data\HtcNotes" on the SD card and let me know if you're able to open the file properly outside the Notes app...thanks...
bump
i use colornote app, its free in playstore, you can sync with gmail,.. if you use another android phone just install same app, and your note will there to
BUMP!!
Having the same problem, did a factory reset of my phone and the files arer physically still intact, but I can't open them with Evernote app or HTC Notes app. Alle notes are stored in a folder with a .PNG and a .HTML file, the HTML file contains unreadable text. There's very important info in for me, which I need within a week. Can someone please help? I'm willing to do almost anything to be able to read my files...
Still unsolved (bump)
mpc007 said:
Still unsolved (bump)
Click to expand...
Click to collapse
^^
mpc007 said:
^^
Click to expand...
Click to collapse
This disappoints me. If you consider yourselves even moderately skilled, this little problem of my should be peanuts.
Please, help me how to restore my notes from the ContentE.html file!!
mpc007 said:
This disappoints me. If you consider yourselves even moderately skilled, this little problem of my should be peanuts.
Please, help me how to restore my notes from the ContentE.html file!!
Click to expand...
Click to collapse
Try this, create a new note in the HTC Notes app and save it (If it doesn't save, just write random words and exit, it should save then), then go to your .data/HtcNotes folder, find the folder that contains the note you just created. There should be an existing "ContentE.html" file. Delete it and replace it with the file you want to restore.
mpc007 said:
This disappoints me. If you consider yourselves even moderately skilled, this little problem of my should be peanuts.
Please, help me how to restore my notes from the ContentE.html file!!
Click to expand...
Click to collapse
I think you're wasting your time, just having the ContentIE.hml file won't be enough, the actual database is stored in /data/data/com.htc.notes (i think), and without that, the app can't link to the contents of the sdcard.
nkk71 said:
I think you're wasting your time, just having the ContentIE.hml file won't be enough, the actual database is stored in /data/data/com.htc.notes (i think), and without that, the app can't link to the contents of the sdcard.
Click to expand...
Click to collapse
My data folder is indeed empty. However, can't it just be enough to have the raw files from the .data/htcnotes/ folder? I have those, every note exists of a folder with a PNG and a HTML file. They're just not recognised by the Notes App.
mpc007 said:
My data folder is indeed empty. However, can't it just be enough to have the raw files from the .data/htcnotes/ folder? I have those, every note exists of a folder with a PNG and a HTML file. They're just not recognised by the Notes App.
Click to expand...
Click to collapse
Yes, but unless i'm mistaken, the Notes app will rely on the database file, which in turn would link to the contents on the sdcard... so even if the contents weren't on the sdcard they would still show up in the notes app, but not vice versa.
And I don't know of any way to reconstruct the database file.... maybe try searching for that.
nkk71 said:
Yes, but unless i'm mistaken, the Notes app will rely on the database file, which in turn would link to the contents on the sdcard... so even if the contents weren't on the sdcard they would still show up in the notes app, but not vice versa.
And I don't know of any way to reconstruct the database file.... maybe try searching for that.
Click to expand...
Click to collapse
Nobody found a way yet? right?
If you have a backup of your data (or data partition), you need to restore the contents of /data/data/com.htc.provider.notes (as well as com.htc.notes, i think) and set the file permissions by ES file explorer or sth. This is tested and works (I got this answer off google somewhere else, but since this xda thread is the first result that comes up for searches like "recover htc notes", I (necro-)posted the solution here).
Now comes the hard part: If you don't have backup of com.htc.provider.notes, here's how I suggest you hack it BUT I haven't tested: try adding a new note in an empty instance of the notes app. The file /data/data/com.htc.provider.notes/databases/notes.db will be an SQLite file. Open it with any SQLite editor on your computer and you see IDs and file names in its tables match with the created note in your /sdcard/.data/HtcNotes folder. See if you can modify the notes.db database by adding new rows in all related tables to make the app recognize your old HtcNotes files. Don't forget to change file permissions of notes.db after restoring it to your device (I gave rwx-rwx-rwx to everything I copied). If you're lucky and knowledgeable enough you might be able to fix it.
Lesson to learn: Sync, or use plain-text file next time for writing notes.
Chromatix said:
Now comes the hard part: If you don't have backup of com.htc.provider.notes, here's how I suggest you hack it BUT I haven't tested: try adding a new note in an empty instance of the notes app. The file /data/data/com.htc.provider.notes/databases/notes.db will be an SQLite file. Open it with any SQLite editor on your computer and you see IDs and file names in its tables match with the created note in your /sdcard/.data/HtcNotes folder. See if you can modify the notes.db database by adding new rows in all related tables to make the app recognize your old HtcNotes files. Don't forget to change file permissions of notes.db after restoring it to your device (I gave rwx-rwx-rwx to everything I copied). If you're lucky and knowledgeable enough you might be able to fix it.
Click to expand...
Click to collapse
I have a HTC Sensation and I used the HTC Notes app often and so does my girlfriend on her Sensation. I recently changed ROMS on both our phones and have been trying to figure out how the hell to restore our notes. You indeed need to edit that notes.db as you mentioned. I know you didn't test it, but I just tried your suggestion and it did work on my first try. :victory: Here's what I did:
1) I opened the HTC Notes app and created a new note and named it Blah and saved it.
2) I used ES File Explorer to navigate to /data/data/com.htc.provider.notes. Then I copied the notes.db file to my microsd card.
3) I used DB Browser for SQLite to open the notes.db files that I copied to the card. Then clicked on the tab that says Browse Data, then in the drop down menu where it lets you pick a table, I choose notes. There you can see what notes the HTC Notes app will recognize.
4) The note I created earlier called Blah was on row 2, so I clicked on New Record and carefully made a new entry in row 3 with the same format as row 2. Just VERY carefully edit the columns that say: notebook_id, name, data, saved_time, last_modified_time, saving_time, ap_extra_info, thumdnail_path, widget_screenshot_path, and HTC_CREATED.
5) Verify the info you entered is correct fore ach column, then write changes to the database (File menu, Write Changes.)
6) I copied my now modified notes.db from my sdcard back to /data/data/com.htc.provider.notes ES File Explorer, changed the permissions of the file to match notes.db-journal,
7) And finally, I restarted the HTC Notes app, and the new note I added to the database was recognized.
I can think of a shorter way of doing this, but I''ll have to test it first. :fingers-crossed: Why did HTC have to complicate this? Why can't the app just read the files that are in the same folder or provide a refresh option to read any new files that may have been added to .data\HtcNotes at the very least?

[Q] Cannot delete file

I Downloaded a WinRAR file onto my S5 for my computer. It is in my downloads folder on the internal storage of my S5. I have deleted everything out of the folder itself but cannot delete the folder. It annoys me. When I try to delete it I get this dialog box:
"Error deleting folder" Cannot delete WinRAR 5.21 Final(x86-x64) Pre-Activated 100(weird Chinese symbol) an install: The storage is write protected.
Remove the write protection and try again.
I am not stupid...I've tried everything I could think of and cannot remove the write protection or anything. For some reason I think it may be because of the weird Chinese symbol that is after the "Pre-Activated 100"
I cannot rename it, modify it or anything. It is the only file I am having a problem with. Can anybody help me with my OCD?
Is your phone rooted? If yes, you can either use adb or just a terminal emulator app, and delete the cr.p of that file!
Edit: the command you're looking for:
su
cd /mnt/sdcard
rm -r Download
That will remove the Download folder along with all its content. (this is irreversible)

Categories

Resources