Fix Mobile Data drain.

---

After 2 days of testing i think i have a clean solution to fix the mobile data drain by setting the preferred network mode to 1 (GSM only). No need to delete or rename anything. Just update the db that is already there :).

You need a rooted device for this.

Extract the sqlite3.zip and push to your device with the following commands:

adb shell mount -o rw,remount /dev/block/mmcblk0p3 /system
adb push sqlite3 /system/bin
adb shell chmod 6755 /system/bin/sqlite3
adb shell 
su (to gain root permissions)
sqlite3 /data/data/com.android.providers.settings/databases/settings.db 'update secure set value="1" where name="preferred_network_mode"'
reboot

I'll give this a try. Thanks

Edit: Is it possible I can do this on the device without adb? Adb doesn't want to detect my tablet with debugging enabled.

Originally Posted by agentdax5

I'll give this a try. Thanks

Edit: Is it possible I can do this on the device without adb? Adb doesn't want to detect my tablet with debugging enabled.

Sure, as long as you have some sort of terminal emulator installed.

Originally Posted by agentdax5

I'll give this a try. Thanks

Edit: Is it possible I can do this on the device without adb? Adb doesn't want to detect my tablet with debugging enabled.

with root explorer and a terminal app (eg connectbot) you can do it.

What exactly does this do? Is it the same result as renaming the phone and telephone apks?

Sent from my SPH-D700 using XDA App

Thanks! Mine is done. I'll report back later after I charge and give it a go.

Originally Posted by mrkrabs

What exactly does this do? Is it the same result as renaming the phone and telephone apks?

Sent from my SPH-D700 using XDA App

This updates the database configuration setting that causes the phone to not to look for 3G networks only 2G (GSM which includes GPRS and EDGE). I'll let the OP elaborate more, but this config change must reduce the battery usage by causing the phone and telephony services to chill out out a bit when in standy mode.

Originally Posted by _motley

This updates the database configuration setting that causes the phone to not to look for 3G networks only 2G (GSM which includes GPRS and EDGE). I'll let the OP elaborate more, but this config change must reduce the battery usage by causing the phone and telephony services to chill out out a bit when in standy mode.

couldn't describe it better :)

2g = only poll cell if request is made that needs cell, 3g = poll all the time, which means that if you change to only 2g then it should not check for cell if you are in wifi range.
I am sure thats how the tech works if i remember my time at nokia right LOL :P

is there a post around here to explain how to get ADB working on this thing? i can ADB shell in but i get "operation not permitted" when i try to mount /system as r/w

(yes i'm rooted)

thanks guys

edit: i got permission to mount the /system as r/w but when i try to push the sqlite3 i get "Device not found"

i suppose i can give a little more info

i'm running windows 7 ultimate 64 bit with an administrator command prompt and the newest iconia a500 usb drivers from acer's support site and i have my SDK up to date