Database Users

[PROBLEM SOLVED]ALL PROBLEMS' SOLUTIONS AT One PLACE.

Dear friends post your links and guides to all the problems you have faced and were able to solve.. Post the links to the thread and the discussions.
DO NOT --
*Post your Problems here until unless you have a solution too.
*Post anything else other than solved problems.
PLEASE do:::
*Share your experience and post anything you know or find.
EDIT:: Just one Info.. WILDFIRE IS NOW ROOTED :: Follow instructions here.
SOLVED PROBLEMS​
1. Wildfire not vibrating when sms is received.[Solved]
2. HTC Sync not syncing.[SOLVED]
3. Not able to transfer files to SD card.[SOLVED but open for further discussion]
4. Unnecessary images(from gps etc), sounds(From Gps etc), Showing up in HTC gallery and Music app.[Solved]
5. Lesser Battery Life- Try THIS ...... and NOTE::Read the bold part here in this thread.
Hope it helps.
Regards.

reserved...

Unnecessary images(gps etc),sounds(From Gps etc),Showing up in gallery/music
Ok Here are two Simple solutions ::
1><NOT RECOMMENDED> This solution basically helps is hiding the contents of a particular folder and might cause problems with the apps which are linked to those files..It is advisable to be used for images you don't want to show up in gallery and are not associated with any app eg GPS..
-Open Astro / Androzip or whatever file manager/explorer you are using and create a folder named “.anyname” and then mount your phone or mini-SD card on a computer.
-Transfer private files into the new folder and they will no longer appear in the photo browser. Browsing through Astro or a similar file manager will become the only method of viewing those photos on an Android phone.
2> <HIGHLY RECOMMENDED>
- On your computer, open Notepad or any other text editor
-Save the blank file as “.nomedia” . Make sure that the Save as type is ​set as “All Files” instead of “Text documents”
-Copy that file to the folder on your SD card containing audio files you ​don’t want to show up.
(Example: If you want to block CoPilot sound files from coming up, place the .nomedia file in the sdcard/copilot folder)
-Reboot your phone and the files should no longer be viewable
This same trick works for folders containing images or videos that you don’t want to appear in the Gallery app. The files will still be accessible from your original app or an explorer like Astro or Linda or Androzip, but you’ll finally be able to stop hearing “From the next roundabout take the first exit" announcements after a great song.
HAVE FUN

.Trash-1000 :HOW do I delete the files in it?

So I have my EVO mounted and while viewing the root of the SD card I hit <Ctrl>H to show hidden files and then go to .Trash-1000 and all of the files that I thought I had deleted from the music folder are in this folder.
Any info on how to get rid of these files? Even if I try to re-select them and delete they disappear for 1 sec then return... They are .flac files and are very large, so I need them gone.
What is the proper way to delete files directly from folders?

What computer are you using with your phone? '.Trashes' is the name Macintosh uses for the un-emptied trash folders. I imagine similar processes are used by other OSes. To empty it simply requires emptying the Trash (or Recycle Bin) from Finder or the like. You can also use any file browser when the phone isn't mounted to delete that folder directly.

generalExpert said:
So I have my EVO mounted and while viewing the root of the SD card I hit <Ctrl>H to show hidden files and then go to .Trash-1000 and all of the files that I thought I had deleted from the music folder are in this folder.
Any info on how to get rid of these files? Even if I try to re-select them and delete they disappear for 1 sec then return... They are .flac files and are very large, so I need them gone.
What is the proper way to delete files directly from folders?
Click to expand...
Click to collapse
By default on Ubuntu (and other distros with GNOME), pressing delete just puts files in a trash folder. In the file browser you'll have to "Empty Trash" to delete them.
If you want to skip sending them to the Trash in the first place, press "Shift-Delete"

I Usually delete that entire folder.
Sent from my PC36100 using XDA App

[TIP/TRICK] Stop Stock Gallery From Creating .thumbnails Folder! Save SD Card Space!

[TIP/TRICK] Stop Stock Gallery From Creating .thumbnails Folder! Save SD Card Space!
First off, I'll start by saying: "I am not responsible if you brick your phone! Always make a nandroid backup before using my steps/messing with Autostarts! (It's a very powerful application!)"
If you use a 3rd party gallery app (Like QuickPic, my personal favorite...) - You are probably tired of wasting over 100mb of space on your SD card... (And waiting a long time for booting up as well...) I had no need for the /sdcard/DCIM/.thumbnails folder taking up space on my SD card, so this is how to disable the stock Gallery app from doing so!
I researched a little on how to accomplish this and came up with little information, so I thought I'd share:
What you'll need:
1.) Autostarts app (I used: Version 1.7.0)
---
Steps/Directions:
1.) Run Autostarts
2.) Look for these entries: Media ejecting/mounted
3.) Choose either entry (ONLY CHOOSE ONE, IT DOES NOT MATTER WHICH! Choosing one entry will disable both entries in Media ejecting AND Media mounted!)
4.) Click on BootReceiver
5.) Choose Disable (A popup will show saying "This is a system app, are you sure? etc.)
6.) Done! Reboot. On boot, go to /sdcard/DCIM/ and look inside for the usual .thumbnails folder, it should be contained with a few (SMALL) files now!
Note: (Make sure you disable the entry BootReceiver ONCE, it should "strikeout" (as in: draw a line through) the entry BootReceiver, to show it has been disabled on boot.) - zmag

Hmm, seems I just looked in my folder and I saw the darn .thumbnails file again... If anyone knows how to disable the stock Gallery app from wasting boot time & sd space; PLEASE TELL ME!!! - zmag

Well, it looks like this is not a big issue for anyone out there - but it still annoys me.
I have since "frozen" the stock Camera and Gallery apps with Titanium Backup Pro, and still; no luck.
Now, granted when I reboot my phone and look in my DCIM folder it doesn't seem to be creating the .thumbnails folder 100% of the time. But the folder is still being created somehow, and my only guess is from a third-party app (and I can't seem to pinpoint which one) but I'm gonna test to find out which and post my results...
I wish someone out there could give me some input, I've been talking to myself here for too long. - zmag

This isn't the same, but you can create a filetype named '.nomedia' and place it at the root of the folder where you want and it will stop displaying the thumbnails in the gallery app.
http://smartadopter.wordpress.com/2...mbnails-showing-in-the-android-photo-gallery/

OK I believe I may have found the possible solution to this problem.
I was searching around on how to fix this problem as well, and tried a few things myself and believe I have found a solution, so I had to sign up for xda to share with everyone else. So please be gentle as this is my first post, although im a long time lurker.
I also got rid of the stock gallery (uninstalled with Titanium Backup) and now use Quick Pic. although I have removed the stock gallery it still builds that 60mb+ thumbnails directory on my SDcard. I was using SD Maid to delete it but it gets annoying that it kept reappearing even after the uninstall of stock gallery.
Now to start fixing,
I realized it was actually a large single file itself named ".thumbdata3-1967290299" in "sdcard/DCIM/.thumbnails/" that was taking up the 60mb+ , the smaller individual thumbnails Quick Pic created only added up to a 1mb or so.
So what I did was I just grabbed a random useless file from my SD card I didn't need anymore (an alarm clock plus backup .bak file, but I would assume the *new file" option in root explorer would do the same) and I renamed the unneeded file the same name as the file in /.thumbdata/ (the the .thumbdata3-19672902099).
Now I had a .thumbdata file that was only 1.75kb and just simply moved it to the sdcard/DCIM/.thumbnails/ folder and replaced the 60mb .thumbdata file with the smaller one.
After a few restarts of my phone, opening and browsing Quick Pic, checking my thumbnail size a few times with both SD Maid and Root Explore - I now have a much smaller 1.75kb file instead of the old 60mb file.
Hopefully this well help some of you out and solve your problem as well, as far as I can tell it is no longer making that thumbnail file expand so large on my phone.
Phone: HTC Hero CDMA
ROM: Cyanogenmod 7.1
Carrier: i-wireless/sprint

hewillmakehell said:
OK I believe I may have found the possible solution to this problem.
Click to expand...
Click to collapse
i've tried both your copied file trick and making a new file with root explorer, both to no avail. ".thumbdata3--1967290299" always reverts to its old size if any app associated with the gallery is opened.
has yours really stopped reappearing?
i can't figure out where the large thumbnail data is stored, but it must be in the system somewhere...

problem solved
hey i figured out how to fixed this on my atrix. should be the same for all android phones.
http://forum.xda-developers.com/showthread.php?p=28447099#post28447099

There's no "external.db" inside my "com.android.providers.media" folder.
However, I didn't even understood what I was supposed to do with this file. What he meant with "trim the thumbnails table with an sql editor"?
I quoted the post you linked below:
i found the place where the thumbnail data is stored, which was making the huge thumbnail file and crashing Entertainment Center.
it isn't storing the entire ".thumbdata3--1967290299" file (which can be hundreds of mb for some people), rather a large (tens of mb) .db database file that is being used to recreate it on demand.
/data/data/com.android.providers.media/databases
external.db
with Root Explorer i could view the file, and Speed Software also sells an sql editor which you can use to trim the thumbnails table.
*be careful: deleting entries from this file also seems to delete it from the device! i deleted all records from the thumbnails and images tables..
learn from my mistake. i thought it would regenerate, but it deleted all images from /sd card. good thing i backed up all my photos first, but better to use the filter option and trim out only the records for files that are no longer on the device.
".thumbdata3--1967290299" now reappears, but a whole lot smaller.
Gallery opens so much faster now, and Entertainment Center works again!
hope it helps!
Click to expand...
Click to collapse

i bet it is hiding somewhere. maybe it's slightly different on other phones.
the issue was that i had an ever-expanding sdcard/dcim/.thumbnails/.thumbdata3--1967290299 file being recreated every time i accessed the gallery viewer, even after that thumbnails folder was erased.
my device was keeping track of ALL the media files that were ever on it, not just the ones presently on it. so the more files that passed through my device, the bigger the thumbdata file kept getting. the external.db file contains a table that lists all media files along with a bunch of attributes for each. apparently this db file is used to generate the thumbdata file. all the info for deleted files just leads to more padding inside the thumbdata file, so it keeps getting bigger.
by trimming the table i meant to delete the records in the external.db that correspond to thumbnails for media no longer on the device. that file is an SQLite file, so to open it you need a special viewer/editor. i first used the SQLite Viewer that comes with Root Explorer. with that, i could see the all the redundant thumbnail entries. to edit it, i got the SQLite Editor, though i'm sure there are other ways. then it's a matter of recognizing which files it lists that are no longer on your device, and getting rid of those rows from the table. in my case the external.db file went down from 8mb to 500kb after i did that.
screenshot 1 showing tables inside external.db, using SQLite Editor
screenshot 2 showing 'thumbnails' table

TBN FILE 2gb
hi
i have a huge thumbnail file in he sd card its almots 2GB
i have already came to opeing the list for thumbnails in the editor
but i dont know how to filter it that i can delete only the files which are not in the sd card (i.e already deleted ) plss guide me throught ,,, this and u will be a star:good:

whitebreadstyle said:
i bet it is hiding somewhere. maybe it's slightly different on other phones.
the issue was that i had an ever-expanding sdcard/dcim/.thumbnails/.thumbdata3--1967290299 file being recreated every time i accessed the gallery viewer, even after that thumbnails folder was erased.
my device was keeping track of ALL the media files that were ever on it, not just the ones presently on it. so the more files that passed through my device, the bigger the thumbdata file kept getting. the external.db file contains a table that lists all media files along with a bunch of attributes for each. apparently this db file is used to generate the thumbdata file. all the info for deleted files just leads to more padding inside the thumbdata file, so it keeps getting bigger.
by trimming the table i meant to delete the records in the external.db that correspond to thumbnails for media no longer on the device. that file is an SQLite file, so to open it you need a special viewer/editor. i first used the SQLite Viewer that comes with Root Explorer. with that, i could see the all the redundant thumbnail entries. to edit it, i got the SQLite Editor, though i'm sure there are other ways. then it's a matter of recognizing which files it lists that are no longer on your device, and getting rid of those rows from the table. in my case the external.db file went down from 8mb to 500kb after i did that.
screenshot 1 showing tables inside external.db, using SQLite Editor
screenshot 2 showing 'thumbnails' table
Click to expand...
Click to collapse
I had the sam issue, but unfortunately your solution didn't help me. I have only a couple of pictures on my phone, but a lot of GBs of music on SDCard and I think this is he reason why .thumbdata3 file is so large on my phone.
I also tried using SDRescan as proposed here: http://forum.xda-developers.com/showpost.php?p=28516079&postcount=6, but that didn't help either.
I've done some more research and found a solution here: http://www.mobilephonetalk.com/show...in-memory-card&p=311954&viewfull=1#post311954. After I deleted the .thumbdata3 file, created a blank one with Root Explorer and removed write permission to it, the file stays at 0 bytes and Camera and Gallery apps still work fine.

mihir880 said:
hi
i have a huge thumbnail file in he sd card its almots 2GB
i have already came to opeing the list for thumbnails in the editor
but i dont know how to filter it that i can delete only the files which are not in the sd card (i.e already deleted ) plss guide me throught ,,, this and u will be a star:good:
Click to expand...
Click to collapse
it sure would be nice if android did that automatically
i don't know how though, sorry.. maybe there is a way, but it is surely safer to backup the media files to another drive, trim the db, then move them back if necessary.
---------- Post added at 09:47 PM ---------- Previous post was at 09:42 PM ----------
strom87 said:
I've done some more research and found a solution here: http://www.mobilephonetalk.com/show...in-memory-card&p=311954&viewfull=1#post311954. After I deleted the .thumbdata3 file, created a blank one with Root Explorer and removed write permission to it, the file stays at 0 bytes and Camera and Gallery apps still work fine.
Click to expand...
Click to collapse
i guess that's one way of doing it. it just means all the thumbnails have to be recreated every time you open the gallery or file browser.

strom87 said:
I had the sam issue, but unfortunately your solution didn't help me. I have only a couple of pictures on my phone, but a lot of GBs of music on SDCard and I think this is he reason why .thumbdata3 file is so large on my phone.
I also tried using SDRescan as proposed here: http://forum.xda-developers.com/showpost.php?p=28516079&postcount=6, but that didn't help either.
I've done some more research and found a solution here: http://www.mobilephonetalk.com/show...in-memory-card&p=311954&viewfull=1#post311954. After I deleted the .thumbdata3 file, created a blank one with Root Explorer and removed write permission to it, the file stays at 0 bytes and Camera and Gallery apps still work fine.
Click to expand...
Click to collapse
How did you removed write permission from the thumbdata3 file with RootExplorer. If I try this, then I get a message, that that is not possible on the SD-Card and nothing happens!! The permissions stay !!!

Sunnymen1975 said:
How did you removed write permission from the thumbdata3 file with RootExplorer. If I try this, then I get a message, that that is not possible on the SD-Card and nothing happens!! The permissions stay !!!
Click to expand...
Click to collapse
You can try creating a folder instead of a file(no need to set permissions). So far, it's working

lbrfabio said:
You can try creating a folder instead of a file(no need to set permissions). So far, it's working
Click to expand...
Click to collapse
Another quick way that seems to work:
Code:
rm -rf /mnt/sdcard/DCIM/.thumbnails && touch /mnt/sdcard/DCIM/.thumbnails
rm -rf /mnt/sdcard/external_sd/DCIM/.thumbnails && touch /mnt/sdcard/external_sd/DCIM/.thumbnails

Hello, I also have this problem. Now I put another file with that name and that seems to work.
However, I came on this because my device went suddenly very slow.
Is it possible that the application that writes these .thumbnail files is still searching through the complete device, even when it cannot update the file?
And, how can I inspect what app is causing this file or slow down?

Fixed!... deleted .thumbnails folder and then created a file called .thumbnails using root explorer....thats worked for me in my THL w1..saved 1.2 gb of space!

Is there anyway to stop the stock camera from posting pics in the DCIM folder? I am somewhat ocd and would like them to be posted in a folder of my choosing.

estranged1977 said:
Fixed!... deleted .thumbnails folder and then created a file called .thumbnails using root explorer....thats worked for me in my THL w1..saved 1.2 gb of space!
Click to expand...
Click to collapse
Created a file or a folder?

petrsiri said:
Created a file or a folder?
Click to expand...
Click to collapse
try create folder (I do this and see no more thumbdata3-files yet two months)

stop thumbnail????

Frndz.... In DCIM folder .thumbnail create atoumatically.... I dont use Gallery 3D. So i dont need this btw it eats upto 100+ mb in my sd card.. when i delete it,it creates atoumatically.. so i want to delete it parmanently... is there any way???

I'm guessing the Gallery3D app is made to do that upon start up. Only way I personally see around it is to modify it and change some actions it does.

Remove that folder n then create new file from root explorer with name .thumbnails (make a file not folder) I did it n it cannot create a folder thumbnail automatically
Sent from my GT-S5360 using xda premium

storage/emulated/0/

can someone please explain to me why, since updating to 4.2, I have what looks like a duplicate of my SD card contents in a sub folder called storage/emulated/0/?
all my gallery apps, Gallery, DroidIris etc. see duplicates of all my pictures now?
And If I save a pic from a browser It points to the folders in storage/emulated/0/, not the SD card ones?
deleting any file in one folder effects the other, so it is probably not a true duplicate thats taking up space is it?
I assume this has to do with the multi user addition to 4.2, but I have not set up a second user at all.
Does this just occur to people upgrading, or to people who installed a fresh version as well?
Cheers.

CarsnGadgets said:
can someone please explain to me why, since updating to 4.2, I have what looks like a duplicate of my SD card contents in a sub folder called storage/emulated/0/?
all my gallery apps, Gallery, DroidIris etc. see duplicates of all my pictures now?
And If I save a pic from a browser It points to the folders in storage/emulated/0/, not the SD card ones?
deleting any file in one folder effects the other, so it is probably not a true duplicate thats taking up space is it?
I assume this has to do with the multi user addition to 4.2, but I have not set up a second user at all.
Does this just occur to people upgrading, or to people who installed a fresh version as well?
Cheers.
Click to expand...
Click to collapse
I think this has been added as part of the multi-user feature and is where the data/content is stored for other users. It has been mentioned on the forum somewhere else, cant remember where I seen it though.

I also wondered this but then thought logically.
Two users using the same SD card wouldn't be a good idea.
So they sort of virtualise the SD card, and then when a new user is created a sort of partition is created for the user.

I was wondering what that was in ASTRO I thought it was something I did wrong and yes if you delete one file it will end up deleting both of them so be careful luckily I deleted some old downloads I didn't need anymore GOD BLESS YOU GUYS
Sent from my Nexus 7 using xda app-developers app

thats all fine, thanks guys,
but now, if I download a new pic from dolphin browser to the /emulated/0/pictures folder, the gallery sees my SD/pictures as well as the /emulated/0/pictures folder, the original has 99 files in, and the new one 1 file in, both are called "pictures".
the "save picture as" action opens up its own file explorer, and it wont let me go back far enough in the file tree to access the SD/pictures folder so I can only save in the new /emulated/0 folder and its sub folders?
cheers.

I can't find the folder on my pc. I am trying to run a backup app and it stores it there. I try to replace the backup location to downloads for example and it won't work. It's driving me mad.

The linked directories are linked to look like separate directories but they link to what is called a mount point that the actual physical storage and the actual file. What you do in any of folders will be done in all the folders.
I'm still wrapping my mind and this and my Linux knowledge it's weak. So I'm not going to try to suggest how to deal with these folders. As much as possible I'm letting the app handle the files.
Sent from my Nexus 7 using xda premium

CarsnGadgets said:
can someone please explain to me why, since updating to 4.2, I have what looks like a duplicate of my SD card contents in a sub folder called storage/emulated/0/?
all my gallery apps, Gallery, DroidIris etc. see duplicates of all my pictures now?
And If I save a pic from a browser It points to the folders in storage/emulated/0/, not the SD card ones?
deleting any file in one folder effects the other, so it is probably not a true duplicate thats taking up space is it?
I assume this has to do with the multi user addition to 4.2, but I have not set up a second user at all.
Does this just occur to people upgrading, or to people who installed a fresh version as well?
Cheers.
Click to expand...
Click to collapse
Same for me. Music player, gallery and other apps now show two copies of files. Any solution to fix this yet?

algus said:
Same for me. Music player, gallery and other apps now show two copies of files. Any solution to fix this yet?
Click to expand...
Click to collapse
I think you are confusing a symlink'd directory with a second copy.

No one - so far - has reported a real problem related to duplicate file - so don't be expecting a fix.
Spend the time reading up on Linux directory structures instead.

rmm200 said:
No one - so far - has reported a real problem related to duplicate file - so don't be expecting a fix.
Spend the time reading up on Linux directory structures instead.
Click to expand...
Click to collapse
This.
It's not broken do don't expect a fix. It only 'looks' like you have duplicate files. A change you make in any single place will show up in all locations. Delete a file in one place it will be gone everywhere. The whole file system is an optical illusion. Layers on layers of naming parts of the file system.
For instance /sdcard is actually /data/media/0 if you created another user on your tab they would get /data/media/1 but they would find their files under /sdcard in a file manager.
Sent from my Nexus 7 using xda premium

I understand that it is a link. As I said problem is that applications show two copies of all files put in /sdcard folder. Because applications treat each link as a separate file. This is exactly what the original poster and I wrote in our posts.
So far I fixed this problem for myself by deleting all files from /sdcard (they disappeared from other linked locations as well) and saving them back straight to /storage/emulation/0 (they appeared in other linked locations, including /sdcard, but this time the gallery and other apps show single copy of each file in their collections).
This is not confortable for a typical user to learn about all these linked folders and I consider it as a drawback of Jelly Bean.

algus said:
I understand that it is a link. As I said problem is that applications show two copies of all files put in /sdcard folder. Because applications treat each link as a separate file. This is exactly what the original poster and I wrote in our posts.
So far I fixed this problem for myself by deleting all files from /sdcard (they disappeared from other linked locations as well) and saving them back straight to /storage/emulation/0 (they appeared in other linked locations, including /sdcard, but this time the gallery and other apps show single copy of each file in their collections).
This is not confortable for a typical user to learn about all these linked folders and I consider it as a drawback of Jelly Bean.
Click to expand...
Click to collapse
I am trying to understand what you are seeing.
On my device, the gallery app only shows pictures in my user: emulated/0. This is from selecting a picture and then asking for info on it.
What apps are showing duplicates, other than a file explorer that you would expect to show symlinks?
I should add - are you copying pictures directly to /sdcard from somewhere else?

Well I had a problem...because of all the multiuser crap I was unable to restore a titanium backup cause of all the emulated directories that another user makes...I had to delete every /0 directory that it made cause if you install another Rom it makes a new /0 directory inside the other /0 directory so after flashing CM10, MIUI and slim bean I finished with a directory like this: sdcard0/0/0/0.
Sent from my GT-I9300 using xda app-developers app

restoring backups seems to be a problem too in cwm. Hmm how to fix it
Sent from my Nexus 4 using xda app-developers app

I ran into this problem with Titanium Backup and my Nexus 7. I was trying to copy the titanium backup folder on the Nexus 7 to my windows PC (also tried mac too) as it was taking up a lot of space on the Nexus but Windows and Mac wouldn't have any of it. It just copied the folder and not the contents. Android file Transfer manager on mac just keeped crashing. I did not try adb pull folder with WugFresh toolkit, so that may work. I ended up copying from the nexus 7 to a USB drive using an OTG cable.

I been looking into this too, this is what I find so far I did a fresh install after I installed my Rom I wipe storage on my N7 so I have a clean storage nothing on it about 27.80gb after I installed one game that is 2gb and its show on both storage emulated and 0 n after my available space is 23.72gb. So I think its does create a duplicate that take space. But Im not sure.I going to run some more tests. If this is true this kinda suck cus then my 32gb n7 is only 16gb then.
Ps. Also if u reboot ur n7 and u go to storage there is another folder under emulated with 0 with the same files you can deleted this folder is save you won't loose anything but if you reboot and go back to storage the file reappear and you can delete but once u reebot again it will reappear again and over again.
Sent from my EVO using xda premium

No way are there 2 copies of files (unless you are auto backing up, which I do). My free space was 3.9gb before and after 4.2. Have all the extra meaningless folders.

You could think of the emulated storage locations like a shortcut. You could place multiple shortcuts to your 'My Documents' folder on your desktop without creating multiple copies of 'My Documents'.

Same problem with Galaxy Nexus
I have the same problem with my Galaxy Nexus and Android 4.2.1
In my Windows Explorer i dont see the same files like in my Phone with Total Commander on my Storage.
This is not funny.