This guide is to fix a problem that affect all Xperia 2011 phones, you can find a description here also with the link to official Sony support discussion: http://xdaforums.com/showthread.php?p=23119111#post23119111
What we need:
1) Rooted phone. The more simple way to do it’s flash the stock firmware 4.0.A.2.0.42 with flashtool or wotan server, then run the easy ZurgRush-DoomLoRD script available here:
http://xdaforums.com/showthread.php?t=1321582.
Finally update the phone to 0.62 only via OTA or keep the 0.42 build.
2) Root explorer app for Android.
3) SQLite browser download for windows available here: http://sourceforge.net/projects/sqlitebrowser/
Instructions:
First of all make sure you have a full backup of your system or know how recover it if something goes wrong.
I’m not responsible of any damage you can do to your phone. This procedure can brick your phone or cause a boot loop ! ! ! Do it at your own risk !
Ok, let’s start.
Open the app Root explorer and browse the folders to find the file “settings.db” located here:
data/data/com.android.providers.settings/databases/settings.db
Long click, then Copy the file and paste it in your Sd Card, make sure to select the appropriate option in the app. To do it press the “Mount” button until you can see Mount R/W like in the picture below.
Now, get the file from your Sd card and move it in your windows Pc.
Make a copy or a backup of the file and save it in your secure Hard disc.
Install the software SQLite database browser for windows and open it, then go to “File” – “Open database”, select so “settings.db” file saved in your PC, but not the backup one .
Go to “Browse Data” and under “Table” select “secure”.
Now find the line “assisted_gps_enabled” and after a double click change the value from “1” to “0”.
Here a picture of the line you should see with the old “1” value, remember to change it like described up .
Apply the change, then “File” – “Save database”.
To be sure the file is correctly edited, open again it with the software and go in the “secure” tab, if you see “0” in the assisted_gps line is ok, Exit.
Copy the edited file into your SD card and keep it there, Open root explorer and go into the folder:
data/data/com.android.providers.settings/databases/settings.db
long click on the file settings.db, then click “permissions”.
Note these settings in the paper or somewhere, it is very important do it carefully, is enough remember the flags position !!! However the correct permissions are:
User: Read Write
Group: Read Write
Others: no flags
Now, you are ready for the most important step.
Go again with Root explorer in your SD card, where is located the pc edited “settings.db” file, long click and “Copy”; now place it in the folder “\system”, long click and “Permissions”.
Make sure to select the correct flags as you noted them for the original file !!!! So:
User: Read Write
Group: Read Write
Others: no flags
If the flags of the edited file are the same of the original one or, I explane better, if the edited file don’t need permissions change because they are already the same of the original one noted before,stop you, it is very probably a boot loop.
Now long click on the edited file with the new permissions and select “Move”; paste it into the folders: data/data/com.android.providers.settings/databases/settings.db
replace it. DONE !!!
Reboot your phone .
Do it at your own risk !!!
This procedure works, is tested by me but I’m not responsible of any damages.
Now the Gps works like a charm and no more disconnections every 5 minutes with data disabled, finally we have a full offline Gps !!!
NOTE: This fix exclude totally the "Assisted mode", the gps will work only in "standalone mode" without data required. This doesn't mean you will have low performances, absolutely not , the gps chip works like a charm with the best precision, only the First fix will be a little slower, because not data assisted, basically you have to wait 20 seconds intead of 10 seconds. That's all.
This is not an official Sony fix, you can void your warranty doing so.
Tested on Xperia Neo, should work with Arc, Arc S, Ray, Neo V, Pro but it is not tested at the moment.
This is only for Gingerbread !!!
Remember to do a backup until use this guide, you have to be sure to recover your system without lose nothing, in most of Xda threads you can see how do it.
UPDATE 1: A user have reported a minor issue when replacing the settings.db file on .58 firmware. Basically when you confirm to replace the file with original, the same file disappear from the folder !!! This didn't never happen in my tests, however cause a boot loop, so to prevent it after the procedure is done exit from root explorer and open it again (don't reboot of course), go to the folder of settings.db file and make sure it is still here with the correct permissions.
If the file there isn't, copy again the edited one from your sd directly into the folder data/data/com.android.providers.settings/databases/settings.db (not in the root "\system") and change there the permissions.
Now the file should remain and you can enjoy the fix.
Good Luck
By Marco
What we need:
1) Rooted phone. The more simple way to do it’s flash the stock firmware 4.0.A.2.0.42 with flashtool or wotan server, then run the easy ZurgRush-DoomLoRD script available here:
http://xdaforums.com/showthread.php?t=1321582.
Finally update the phone to 0.62 only via OTA or keep the 0.42 build.
2) Root explorer app for Android.
3) SQLite browser download for windows available here: http://sourceforge.net/projects/sqlitebrowser/
Instructions:
First of all make sure you have a full backup of your system or know how recover it if something goes wrong.
I’m not responsible of any damage you can do to your phone. This procedure can brick your phone or cause a boot loop ! ! ! Do it at your own risk !
Ok, let’s start.
Open the app Root explorer and browse the folders to find the file “settings.db” located here:
data/data/com.android.providers.settings/databases/settings.db
Long click, then Copy the file and paste it in your Sd Card, make sure to select the appropriate option in the app. To do it press the “Mount” button until you can see Mount R/W like in the picture below.
Now, get the file from your Sd card and move it in your windows Pc.
Make a copy or a backup of the file and save it in your secure Hard disc.
Install the software SQLite database browser for windows and open it, then go to “File” – “Open database”, select so “settings.db” file saved in your PC, but not the backup one .
Go to “Browse Data” and under “Table” select “secure”.
Now find the line “assisted_gps_enabled” and after a double click change the value from “1” to “0”.
Here a picture of the line you should see with the old “1” value, remember to change it like described up .
Apply the change, then “File” – “Save database”.
To be sure the file is correctly edited, open again it with the software and go in the “secure” tab, if you see “0” in the assisted_gps line is ok, Exit.
Copy the edited file into your SD card and keep it there, Open root explorer and go into the folder:
data/data/com.android.providers.settings/databases/settings.db
long click on the file settings.db, then click “permissions”.
Note these settings in the paper or somewhere, it is very important do it carefully, is enough remember the flags position !!! However the correct permissions are:
User: Read Write
Group: Read Write
Others: no flags
Now, you are ready for the most important step.
Go again with Root explorer in your SD card, where is located the pc edited “settings.db” file, long click and “Copy”; now place it in the folder “\system”, long click and “Permissions”.
Make sure to select the correct flags as you noted them for the original file !!!! So:
User: Read Write
Group: Read Write
Others: no flags
If the flags of the edited file are the same of the original one or, I explane better, if the edited file don’t need permissions change because they are already the same of the original one noted before,stop you, it is very probably a boot loop.
Now long click on the edited file with the new permissions and select “Move”; paste it into the folders: data/data/com.android.providers.settings/databases/settings.db
replace it. DONE !!!
Reboot your phone .
Do it at your own risk !!!
This procedure works, is tested by me but I’m not responsible of any damages.
Now the Gps works like a charm and no more disconnections every 5 minutes with data disabled, finally we have a full offline Gps !!!
NOTE: This fix exclude totally the "Assisted mode", the gps will work only in "standalone mode" without data required. This doesn't mean you will have low performances, absolutely not , the gps chip works like a charm with the best precision, only the First fix will be a little slower, because not data assisted, basically you have to wait 20 seconds intead of 10 seconds. That's all.
This is not an official Sony fix, you can void your warranty doing so.
Tested on Xperia Neo, should work with Arc, Arc S, Ray, Neo V, Pro but it is not tested at the moment.
This is only for Gingerbread !!!
Remember to do a backup until use this guide, you have to be sure to recover your system without lose nothing, in most of Xda threads you can see how do it.
UPDATE 1: A user have reported a minor issue when replacing the settings.db file on .58 firmware. Basically when you confirm to replace the file with original, the same file disappear from the folder !!! This didn't never happen in my tests, however cause a boot loop, so to prevent it after the procedure is done exit from root explorer and open it again (don't reboot of course), go to the folder of settings.db file and make sure it is still here with the correct permissions.
If the file there isn't, copy again the edited one from your sd directly into the folder data/data/com.android.providers.settings/databases/settings.db (not in the root "\system") and change there the permissions.
Now the file should remain and you can enjoy the fix.
Good Luck
By Marco
Last edited: