yashsingh1/xdaforums huggingface dataset:
[Verizon Samsung Galaxy S 4] Parafly:
Hey guys,

Didn't get this earlier but I'm new to SQL Lite Editor

Getting an error of "Ran out of Memory while loading data. Not all records are displayed."

The only record I see on this is _id 1, volume_music with a value of 7
[Verizon Samsung Galaxy S 4] p-slim:
Soft reset then open app
[Verizon Samsung Galaxy S 4] bmtbandit:
Reboot and try again. It worked for others in this thread.
[Verizon Samsung Galaxy S 4] Parafly:
Just tried rebooting, didn't help. What is soft reset? Battery pull?

Edit: just did a battery pull and it's still not working. :/ ARGH!

---------- Post added at 09:59 AM ---------- Previous post was at 09:39 AM ----------

Well whatever. I rebooted three times and the third time it worked. Who knows. Thanks!
[Verizon Samsung Galaxy S 4] Itsmyphoneyo:
Anyone know or able to find out what the 3 remaining blank toggle spots are? I was trying to figure out if the hotspot toggle would be one, but cant get it to show. I tried everything I can think of. I tried these 4 and nothing came up; Hotsopt, MobileHotspot, Tether, WifiTether.
[Verizon Samsung Galaxy S 4] Schoat333:
I don't think there is one for mobile hotspot.. The other 2 that AT&T has are air gesture and blocking mode.

I can confirm that adding AirGesture will add that toggle, but blocking mode must be completely removed, because that does not work
[Verizon Samsung Galaxy S 4] Itsmyphoneyo:
Then that would leave 1, maybe 2 more spots... I wonder what the international S4 has.
[Verizon Samsung Galaxy S 4] open1your1eyes0:
Perfect! Thank you for figuring this out OP. This change in combination with below flashed is exactly what we needed. :good:

http://xdaforums.com/showthread.php?t=2297213
[Verizon Samsung Galaxy S 4] jds3118:
Worked perfectly! Great job !
[Verizon Samsung Galaxy S 4] rmreagle:
is there a free version of SQlite editor or another similar free app that will do the job?

Or maybe someone can turn the fix into a flash somehow...?

Also does this restore the air gesture toggle also?
[Verizon Samsung Galaxy S 4] Parafly:
Awesome. So glad I rooted. So far I removed the eye icon, put the toggle back in place, changed my boot animation, removed the persistant wifi notification. All is beautiful.
[Verizon Samsung Galaxy S 4] Schoat333:
Actually, I just answered the air gesture questions above, it does.
[Verizon Samsung Galaxy S 4] open1your1eyes0:
I wonder if we can get the missing blocking mode and air gesture toggles back this way too.

EDIT: Nevermind, I'm blind. :silly:
[Verizon Samsung Galaxy S 4] Schoat333:
See my post above.
[Verizon Samsung Galaxy S 4] wolfgrrl:
SUPER! And can reorder - AWESOME! Thanks! Works great!
[Verizon Samsung Galaxy S 4] Itsmyphoneyo:
I found an image on google that shows all the notification toggles for the international s4, it has a hotspot and blocking mode, so it does exist... Guess I'm gonna play some more.
[Verizon Samsung Galaxy S 4] Schoat333:
Interesting. We need to get an international person to open up sqlLite, and tells us what they have listed. :good:
[Verizon Samsung Galaxy S 4] rmreagle:
That is my thought. Maybe the name for Blocking mode is something we're not thinking of... Like how GPS is actually written as Location. Can anyone dig around and see if there is an apk that would have the right name?
[Verizon Samsung Galaxy S 4] Soldi3rxx:
Can someone post a screenshot please!
[Verizon Samsung Galaxy S 4] medicwyatt:
Genius! Worked perfectly
[Verizon Samsung Galaxy S 4] carbon coupe:
Could this be used to change download targets? Say, from internal storage to external SD card within an app??

A complete breakdown of SQLites capabilities would help justify.
[Verizon Samsung Galaxy S 4] mbh87:
blocking mode requires more than just adding the toggle. it FCs SystemUI.

WiFiHotspot adds exactly that.

DoNotDisturb allows the option to turn off notifications.

---------- Post added at 10:19 AM ---------- Previous post was at 10:16 AM ----------

but for those curious DormantMode will add the blocking toggle.
[Verizon Samsung Galaxy S 4] Schoat333:
Nice!

I think VZW removed blocking mode code completely this time, because you can't even get to it using the quick shortcut method anymore.
[Verizon Samsung Galaxy S 4] Parafly:
Awesome!
[Verizon Samsung Galaxy S 4] mbh87:
list of all buttons that should be able to be added, but whether they work is a different story
[Verizon Samsung Galaxy S 4] Parafly:
Do not disyurb showed uo for me then vanished again
[Verizon Samsung Galaxy S 4] ret4425:
+1 for a free or flashable version...is there another app that will allow me to do this? Not to sound cheap (well, I am, anyways), but I don't think I will ever use this app again....
[Verizon Samsung Galaxy S 4] Itsmyphoneyo:
I see my error in getting the hotspot toggle... Since the Wifi toggle was only "Wifi" without the capital F, I didn't include it when imputing that. Used the capital F and it showed right up!

And it bypasses the security check on my stock rooted phone.

Thanks!
[Verizon Samsung Galaxy S 4] Parafly:
Nice that's a big plus for unlimited data users
[Verizon Samsung Galaxy S 4] Itsmyphoneyo:
You can reorder without SQLite. Pull down notification bar with 2 fingers, tap the pencil in top right corner, rearrange. If you we're going to use SQLite, this is easier and faster without risk.
[Verizon Samsung Galaxy S 4] Schoat333:
I notice that dormant mode options are listed in the same db we are editing. I wonder if they work by manually changing them using sqllite?
[Verizon Samsung Galaxy S 4] bmtbandit:
Good Call, I set dormant_switch_onoff from 0 to 1, blocking is enabled to be toggled off, it starts as on.
[Verizon Samsung Galaxy S 4] Itsmyphoneyo:
screenshot attached... if I did it right.
[Verizon Samsung Galaxy S 4] open1your1eyes0:
Here's all the ones I added:
[Verizon Samsung Galaxy S 4] Schoat333:
Yep, seems to have worked. I can now turn it on and off. No settings option tho.
[Verizon Samsung Galaxy S 4] bmtbandit:
I started http://xdaforums.com/showthread.php?p=42018423#post42018423 for discussion.
[Verizon Samsung Galaxy S 4] jmcox99:
I added the "wifi" to the list, when I rebooted, it didn't work. I went back into SQLite Editor and when I click on settings storage, it says no databases found.

Any idea what went wrong?

Justin
[Verizon Samsung Galaxy S 4] ilkevinli:
Not sure, but I can tell you it's case sensitive so "wifi" wouldn't work.
[Verizon Samsung Galaxy S 4] Itsmyphoneyo:
That dormant_switch_onoff just turns blocking mode on or off, same thing as the toggle. But when u turn it on, and call yourself or have someone text you, it does not block it from coming through.
[Verizon Samsung Galaxy S 4] Schoat333:
We are discussing this in the other thread, it will block the led for me, but that's all.
[Verizon Samsung Galaxy S 4] Itsmyphoneyo:
Sorry, didn't see that. I'm moving...
[Verizon Samsung Galaxy S 4] holla420:
Ty op got this working :thumbup:
[Verizon Samsung Galaxy S 4] EliezerB:
Is there any way to accomplish this on a non-rooted S4?
[Verizon Samsung Galaxy S 4] jpmcnown:
Thanks so much for this. After realizing that the options are case sensitive, this worked great! Seems weird that a wifi toggle would have been left out, and all that other crap left in.
[Verizon Samsung Galaxy S 4] ilkevinli:
Nope.
[Verizon Samsung Galaxy S 4] jpen:
Whats the last Notification one?
[Verizon Samsung Galaxy S 4] open1your1eyes0:
DoNotDisturb, which turns off all notifications.
[Verizon Samsung Galaxy S 4] brizey:
IT does not seem to work for me. It turned off but will not turn back on.
[Verizon Samsung Galaxy S 4] open1your1eyes0:
Yeah I think this one doesn't work, I got the same issue and even after like an hour when I was able to turn it back on I get notifications in both modes. Just too lazy to remove it. :p
[Verizon Samsung Galaxy S 4] kbtoiz:
Its there a free sql manager app for this?

I tried a couple from the market but I cant seem to find nothing like you guys are doing :/

Sent from super awesome S4
[Verizon Samsung Galaxy S 4] voltjap:
I looked as well, but ended up just purchasing the paid version.

Sent from Verizon Samsung Galaxy s4
[Verizon Samsung Galaxy S 4] dopediculous:
I can get WiFi HotSpot to show, but not plain WiFi... I thought it might have been because of the blue battery and toggle MOD I flashed, but if that were the case, the hotspot wouldn't have showed up like it did? So I'm ruling that out for now. I also tried adding the AirGesture and that didn't show up. I removed driving mode, thinking that maybe there was a limit to how many toggles were allowed, but even with that gone, I STILL can't get just WiFi? Ugh... First World Problems... Haha
[Verizon Samsung Galaxy S 4] blulite:
Outstanding!!! It works.
[Verizon Samsung Galaxy S 4] steelersmb:
I can't get around the out of memory error. Tried rebooting twice and still didn't work.
[Verizon Samsung Galaxy S 4] Itsmyphoneyo:
Its case sensitive. To get just wifi, you have to put "Wifi" without quotes. For air gestures, its "AirGestures" also, remember to never use a space and always separate the toggle names with a ";" especially at the end.
[Verizon Samsung Galaxy S 4] ilkevinli:
It's Wifi NOT WiFi
[Verizon Samsung Galaxy S 4] dopediculous:
I guess I should have mentioned that I did it case sensitive "WiFi" and did sepperate with ; with NO spaces.

Ideas?
[Verizon Samsung Galaxy S 4] mbh87:
as mentioned above its "Wifi" for the wifi toggle, not "WiFi"
[Verizon Samsung Galaxy S 4] dopediculous:
Durka! Lol. Lemme try
[Verizon Samsung Galaxy S 4] voltjap:
Autocorrect got me too. Yeah it should work fine now

Sent from Verizon Samsung Galaxy s4
[Verizon Samsung Galaxy S 4] mutelight:
Thanks very much for this!

So one thing I did notice is that I did the following.

1.) Added "Wifi" and rebooted - Wifi toggle was present

2.) Went back into SQLite to add the WiFiHotspot and AirGestures, saved, rebooted, they did not show

I double and triple checked that the they were correct and had the ";" at the end.

This seems similar to what the other user experienced where they made one addition, toggle showed up, then went back to add more and the changes weren't reflected.
[Verizon Samsung Galaxy S 4] ch0use:
MobileData;SilentMode;AutoRotate;MultiWindow;Bluetooth;DrivingMode;AllShareCast;AirplaneMode;Location;SBeam;Nfc;AirView;Sync;SmartScroll;PowerSaving;SmartStay;Wifi;WiFiHotspot;AirGesture;
[Verizon Samsung Galaxy S 4] coolsilver:
Long Press on Blocking Mode icon should open the settings. All it does for me is crash System UI.

I figure something in there is preventing the settings app from loading it.
[Verizon Samsung Galaxy S 4] s44:
Does the hotspot toggle bypass Verizon's subscription check?
[Verizon Samsung Galaxy S 4] SuperSonicRob:
Added "Wifi" at the end followed by ";" no spaces and theres no toggle after reboot. Did I miss something?

Edit: nevermind I was under default active list not active list.
[Verizon Samsung Galaxy S 4] mexiken:
Unfortunately, a flashable file cannot be made as this is a database edit, within a database that has account specific data within it, so a generic one wouldn't work,nor would using someone else's really.

If someone really wants this change, PM me the settings.db file, and I can make the change for you and shoot it back to you.
[Verizon Samsung Galaxy S 4] christianstudebaker:
To clear this up even more, there are two notification app lists in the directory. When you get to the app list search for notification. There will be two lists that have to do with the notification toggles. There will be notification_panel_default_active and notification_panel_active_app_list. Add Wifi to the notification panel active app list, not default. That should fix the problem.
[Verizon Samsung Galaxy S 4] vwpiper:
Thank you. Piece of cake. Hardest part was letting go of $2.99. (Yeh, I'm a cheap bastard sometimes)
[Verizon Samsung Galaxy S 4] SponsOne:
I'm not sure if someone has mentioned this yet but could one of the toggles missing be a flashlight toggle? I remember the S3 had one but I do not see it on the S4. Does anybody know what to put to unlock it?
[Verizon Samsung Galaxy S 4] Soldi3rxx:
Was wondering the same thing. There's an assistance light widget. Idk if we can do something with that
[Verizon Samsung Galaxy S 4] mbh87:
Look a few pages back as I posted all the toggles that could be added. Torch isn't one of them. I'm sure a dev or someone could add the smali and stuff to get one though.
[Verizon Samsung Galaxy S 4] mutelight:
That was my problem, thank you for pointing that out!

The first time I used the right line but the second time I didn't but it is all sorted now.
[Verizon Samsung Galaxy S 4] igotgame:
I would like to know this as well. Currently I am using FoxFi, but if there was just a toggle that worked, that would be cool.
[Verizon Samsung Galaxy S 4] Itsmyphoneyo:
A few pages back, I confirmed it does bypass Verizon check for me. Prior to that, I used a hotspot toggle widget that did the same.
[Verizon Samsung Galaxy S 4] Chris000001:
I HAVE NOT TESTED WHAT I'M POSTING!

I found a free sqlite app: https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager

It's not root aware, but it has another app that is: https://play.google.com/store/apps/details?id=dk.andsen.aShell

It seems like you could edit /data/data/com.android.providers.settings/settings.db to add the wifi toggle with those apps.

Again, I have not personally tested this. You should check file ownership and permissions before you start and check again after the edit, but before reboot. This might bootloop your phone!
[Verizon Samsung Galaxy S 4] Eric214:
Thanks! This was way easy. Just had to get my hands on sqlite and took me a min flat. The one who mention searching for Panel" was spot on. Mine was in line 1565 or som such nonsense. I'm sooo starting to hate Verizon even more with all their BS with how they feel they are high and mighty locking down crap and altering things like this that doesn't need altering.

Thanks to all the people who root(pun) this crap out and give us "fixes" on a brand new device!
[Verizon Samsung Galaxy S 4] jalaw:
Must say this was easy. Becarefull of the spelling tho. My auto correct made it "WiFi". I rebooted and nothing. Went back and saw the problem and made it "Wifi" plus the simi-colon or whatever that is and it worked like a dream.

Thanks for the tweak.
[Verizon Samsung Galaxy S 4] AzureShadow:
The wifi toggle is a feature I wouldn't mind having, but at the same time its not worth $3 to me, since Tasker pretty much takes care of my WiFi connection for me anyway.

I know other people have asked, but has anyone confirmed a free app that has this same editing functionality, or is there any other way to get it for free?
[Verizon Samsung Galaxy S 4] theRG:
Thanks for finding this out. It worked perfect although it did change me to "custom" but that was bound to happen at some point.

From my GS4 using Tapatalk 2
[Verizon Samsung Galaxy S 4] jds3118:
Thanks this worked with free app now I have toggles for wifi,wifi hotspot and air gesture :thumbup::)
[Verizon Samsung Galaxy S 4] loonie01:
I got the wifi but what do you put for the hotspot toggle
[Verizon Samsung Galaxy S 4] Itsmyphoneyo:
"WiFiHotspot;" but leave out the quotes.
[Verizon Samsung Galaxy S 4] joeyx2:
So I went throw all of the settings and changed a few other things but kinda forgot exactly what every change I did. If I just re flash the rom will it put all of the settings back to what they where?
[Verizon Samsung Galaxy S 4] loonie01:
I tried the "MoneyGrowOnTrees" toggle but nothing worked. Any ideas?
[Verizon Samsung Galaxy S 4] ret4425:
+1. Is this something devs can bake into a ROM?
[Verizon Samsung Galaxy S 4] djdmbrwsk:
Quick and dirty way to do this for free...

1. Download this free non-root sqllite app...

https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager

2. Use a root explorer and copy the settings.db file at the path below to your sd...

/data/data/com.android.provider.settings/databases

3. Use the sqllite app above to modify the copied file on your sd as instructed in first post...

4. Use your root explorer to copy it back to...

/data/data/com.android.provider.settings/databases

5. Reboot into recovery and fix permissions...

6. Enjoy!
[Verizon Samsung Galaxy S 4] lagvoid:
Thanks OP! why would verizon even take this out?!?!?
[Verizon Samsung Galaxy S 4] brizey:
Well, since WiFi is such a little known, obscure technology, they thought it best to take up 1/5 of the notification window with a friendly reminder to everyone that it exists. And as everyone knows, Verizon just abhors bloat, so they removed the toggle since you can just click the notification.
[Verizon Samsung Galaxy S 4] ret4425:
I'm guessing this is why little boys shouldn't play with bog boy toys...I have no idea what all this jibber-jabber means. Best for shallow folk like me to wait for a bake-in version! Thanks for the effort, tho!
[Verizon Samsung Galaxy S 4] Sparatan117:
https://code.google.com/p/xdroidx/downloads/detail?name=SQLite Editor-9.apk

If you have root, use this.

When the database list populates select Settings Storage (little green droid out to the left of it)

Hit Settings.db

Hit System

Scroll WAY down to find _id "3805" notification_panel_active_app_list

Highlight it, then hit the menu button (on the phone) and Edit Field

add a ; and the word Wifi then another ; and then save.

Reboot the phone

Success
[Verizon Samsung Galaxy S 4] spr0k3t:
This is awesome... one more thing to get fixed. Now if I could just change the height of those buttons... they are freakin huge.
[Verizon Samsung Galaxy S 4] john7760:
I have Dormant mode active now and can toggle on/off but not sure how to change the settings? Anyone?
[Verizon Samsung Galaxy S 4] AzureShadow:
I just used this method and I can confirm it works, at least for me. Currently using a TW stock deodexed rom.
[Verizon Samsung Galaxy S 4] vwpiper:
Any chance this sql method could be used to add the Assistive Light toggle?
[Verizon Samsung Galaxy S 4] jeffy8605:
Dangit. Was trying to hold off on rooting until we got an unlocked bootloader... now I needs to. Lol. Good job!

My Galaxy S4
[Verizon Samsung Galaxy S 4] ProfEngr:
Mine was at 600. And after a reboot I have wifi toggle. Woot!

Sent from my SGS4 using one opposable thumb.
[Verizon Samsung Galaxy S 4] hpower1:
Thanks for this. much appreciated.

---------- Post added at 11:21 AM ---------- Previous post was at 11:19 AM ----------

My guess is to force people to use wifi versus data. constant nag to people, so most will just turn on wifi and leave it, especially since you can't see it is on thru a toggle.

Just a way to get people not to use the data they are paying for.
[Verizon Samsung Galaxy S 4] twisted.transistor:
wow, thank u, I thought there was no solution.
[Verizon Samsung Galaxy S 4] pas_scorpion:
So if you use this same method and type "Brightness;" it gives you a semi functional Brightness toggle but it doesn't stick. The moment you go to rearrange your toggle order 'poof' its gone. Any idea or methods of getting it to stick around?
[Verizon Samsung Galaxy S 4] cell128:
I tried thus over and over still not working on mine I edit the record it begins ;Wifi; I also tried ;WiFi; no luck. I rebooted a ton of times
[Verizon Samsung Galaxy S 4] hero2zero:
Same here. I tried adding "Wifi;" to the beginning of the list, too. But, still no toggle.

Edit: Changed the wrong field. I need to pay attention: edit notification_panel_active_app_list NOT notification_panel_default_active_app_list
[Verizon Samsung Galaxy S 4] Itsmyphoneyo:
Couple pages back, there is a helpful post that describes the difference in 2 fields that look the same. One field says default active list and the other does not have default... check back a couple pages and it tells you exactly what the 2 fields say and which one to edit.
[Verizon Samsung Galaxy S 4] hero2zero:
Yup **banging head on desk**
[Verizon Samsung Galaxy S 4] wingdo:
That can't be it as even when connected to wifi that stupid notification bar is there on stock. Was so happy to make it go away and find this to add the proper toggle back in.
[Verizon Samsung Galaxy S 4] xtreme2ner:
THANK YOU!!!!!

Same here. I tried adding "Wifi;" to the beginning of the list, too. But, still no toggle.

Edit: Changed the wrong field. I need to pay attention: edit notification_panel_active_app_list NOT notification_panel_default_active_app_list[/QUOTE]

DUDE THANK YOU!!! I done the same thing LOL
[Verizon Samsung Galaxy S 4] xray49er:
Thank you, worked like a charm
[Verizon Samsung Galaxy S 4] tsiehta:
I tried the soft reset and I still get the out of memory error... I was able to get around it by filtering with panel_active... as just typing panel in gave me the wrong line.
[Verizon Samsung Galaxy S 4] loudaccord:
You da man... thank you! Worked like a charm. Added WiFihotspot also = profit :)
[Verizon Samsung Galaxy S 4] theboo7:
Does the WiFi Hotspot perform the bypass?
[Verizon Samsung Galaxy S 4] mbh87:
Yes. This has been mentioned plenty in this thread alone.
[Verizon Samsung Galaxy S 4] theboo7:
Thanks for the answer.
[Verizon Samsung Galaxy S 4] trebb:
Is there any way to get rid of the huge ass brightness toggle from the main screen with this method? I pretty much always keep it on auto-brightness. I don't see any type of brightness listed in the stuff you guys have showed is there so far.
[Verizon Samsung Galaxy S 4] r_hippy:
Settings my device display notification panel
[Verizon Samsung Galaxy S 4] trebb:
Wow, I'm stupid. Thanks.
[Verizon Samsung Galaxy S 4] ryan1977:
Yeah this worked great for me, thanks again.
[Verizon Samsung Galaxy S 4] Gam3r 4 Life:
This worked for me, but instead of pressing edit field, I had to press edit record. Then I was able to add "Wifi:" and reboot. Then it worked. Dont know why it was different for me. Either way Thanks.
[Verizon Samsung Galaxy S 4] fizeke136:
This might be a dumb question, but do I need to add all the panels from the default_active_app_list to the active_app_list as well? I added just the 3 noted in the OP and now those are the ONLY panels that i have...

EDIT: NVM...figured it out. Guess I should have tried before posting..
[Verizon Samsung Galaxy S 4] Sparatan117:
Ha almost edited the same one when I first did it. Good catch
[Verizon Samsung Galaxy S 4] moonman777:
New to the forum, just rooted my S4 and followed most of the stuff here.

There was something that didn't seem to be mentioned here, but once you change the value of the "dormant_switch_onoff" from 0 to 1, save, and reboot, if you go back into that same database, the fields are different and that dormant_switch_onoff isn't there anymore.

Instead there's dormant_disable_incoming_call, dormant_disable_notifications, etc... and there's also dormant_start_hour, dormant_start_min, and the same for dormant_end.

Apparently you can enter in the start and end times of when you want Blocking Mode to be on (military time). I'm not sure if it works well, but if anyone wants to experiment with it, it'd be good to know if it does actually work.

I'm going to sleep now..
[Verizon Samsung Galaxy S 4] aw091486:
Thanks

I copied the file to SD, used the free SQL editor and used ADB to edit everything.

Had trouble booting up but then I realized it was because I had to fix the setting.db permissions, so make sure you chmod and chown the files to the correct permissions if you decide to go this route.

chmod 660

chown system:system
[Verizon Samsung Galaxy S 4] jimmiem:
When you edit a field, it may move to a different field number. Chances are that dormant_switch_onoff is still there just not where you were expecting to find it.
[Verizon Samsung Galaxy S 4] moonman777:
That's what I thought too, but I couldn't find it anywhere. I double checked, but couldn't find it anywhere in the list.

I could still be wrong though, but I'm wondering if anyone else that's done this sees the same thing?
[Verizon Samsung Galaxy S 4] Scorp123:
Is getting a flashlight toggle a possibility with this method?
[Verizon Samsung Galaxy S 4] EVOme:
This worked great for me....I added wifi at the beginning of the list and it's the first toggle now. The text was so small in that SQLite app I damn near needed a magnifying glass.

Thanks for this...hated not having that.