[HOWTO] Remove SMS Per Hour Limit

billypostman

Member
Nov 19, 2012
9
0
0
Istanbul
Hmm that record doesn't show up in my system table, so I'm not sure.

It is highly recommended that you do also edit the gservices database. Try clearing cache and davlik cache in recovery and fixing permissions. Then try again.


Sent from my SPH-L710 using xda app-developers app
It worked. Thanks a lot for your solution.

Now the only thing left; how to remove 10 recipient limit when sending sms :confused:

Do you know how to do that?

Edit: of course without 3rd party application
 
Last edited:

Hostage XII

Senior Member
Jul 17, 2012
242
63
0
Owings Mills
It worked. Thanks a lot for your solution.

Now the only thing left; how to remove 10 recipient limit when sending sms :confused:

Do you know how to do that?

Edit: of course without 3rd party application
Glad it worked! :)

I posted a link to another thread a couple pages back. Look on the second page of this thread. However, most custom ROMs have this MMS fix implemented already.

Sent from my SPH-L710 using xda app-developers app
 
  • Like
Reactions: billypostman

melvinator

Senior Member
Nov 15, 2012
57
16
0
Have not been able to try the adb route yet as I am getting married this weekend and haven't had time I will though come back and note if it worked or not.

Sent from my SAMSUNG-SGH-T989 using xda app-developers app
 

squadz

Senior Member
Nov 15, 2012
182
17
0
Wasn't able to get it to work.

First option didn't work, rebooting to see that makes a difference.

Second option says sqlite3 not found.

Edit: Ended up working on my Nexus 4. Thanks.
 
Last edited:

Hostage XII

Senior Member
Jul 17, 2012
242
63
0
Owings Mills
Tried doing this on my Nexus 4 on version 4.2.1. rooted but it doesn't seem to work =(
Any help?
If you have SQLite Editor installed:

Open the SQLite Editor app.
Scroll down and open "Settings Storage".
Open up "secure"
Add a new record.
Set the name "sms_outgoing_check_max_count"
Set the value to "9999" or whatever you want.
Reboot!
Sent from my SPH-L710 using xda app-developers app
 
Last edited:
  • Like
Reactions: melvinator

melvinator

Senior Member
Nov 15, 2012
57
16
0
If you have SQLite Editor installed:

Open the SQLite Editor app.
Scroll down and open "Settings Storage".
Open up "secure"
Add a new record.
Set the name "sms_outgoing_check_max_count"
Set the value to "9999" or whatever you want.
Reboot!
Sent from my SPH-L710 using xda app-developers app
So i have tried the first and second method with no luck but.....

Bingo! found out how we can do it! For those of you that this doesnt work for them i think there is a way of doing this. i cant confirm it was built into the rom or not and dont feel like trying to reflash and trying all these steps again to find out. I am currently running cyanogenmod 10.0.0 "stable" on my tmobile samsung galaxy S2. if you go to settings -> security -> APP Security -> there should be a option that states SMS message limit -> then choose what limit you would like in a 15 minute interval.

This works for me now and removed sms (text) per hour limit

For all that helped me till this point i thank you again!

If this helps hit thanks!
 

sponix2ipfw

Senior Member
Jul 21, 2012
58
27
0
As the tittle suggests this is a How-To in increasing the SMS/Hour Limit.

Some of you while sending a text might have had the following message pop-up.
View attachment 1262984

Sure you can simply click "Allow" but isn't doing that for every text message you send for the next hour frustrating?

Well, through a few hours browsing the Web and with the help of this thread http://forum.xda-developers.com/showthread.php?t=626771 I was able to increase the limit, thus keeping the message from popping up.

There are two methods of doing this. One requires a couple of apps, the other is done using ADB.

Remember you MUST be rooted for this to work.


The Steps

Required Apps: Root Explorer, SQLite Editor.

1. Open up Root Explorer
2. Navigate to /data/data/com.android.providers.settings/databases/settings.db (It'll ask you if you want to open the database with SQLite or with the internal viewer, choose SQLite)
3. Open the secure table
4. Hit the menu key and select New Record
5. Under name type in sms_outgoing_check_max_count
6. Under the value type in whatever you'd like, I did 9999
7. Hit Save
8. Go back once and select the table system
9. Repeat steps 4-7
10. Now navigate to /data/data/com.google.android.gsf/databases/gservices.db
11. Open the table main
12. Repeat steps 4-7.
13. Back out the home screen and reboot.

If you have SDK installed on computer, it might be easier to run the commands from there. That way you could copy and paste the commands.

ADB Method.
1.Open Command Terminal
2. Type in adb shell hit enter
3. Type in su hit enter
4. Type in sqlite3 /data/data/com.android.providers.settings/databases/settings.db hit enter
5. Type in INSERT INTO secure (name, value) VALUES('sms_outgoing_check_max_count’, 9999); hit enter
6. Type in INSERT INTO system (name, value) VALUES('sms_outgoing_check_max_count’, 9999); hit enter
7. Type in .exit hit enter (you should now see a hash tag again instead of sqlite>. If not conitune typing in .exit and hitting enter until you are)
8. Type in sqlite3 /data/data/com.google.android.gsf/databases/gservices.db
9. Type in INSERT INTO main (name, value) VALUES('sms_outgoing_check_max_count’, 9999); hit enter
10. Again exit back to where the command line has a hashtag
11. Type in reboot and hit enter.
:good::good:
I used the ADB method and ran into 2 minor issues:
1. sqlite3 wasn't found, and doesn't seem to exist in my Stock TW 4.1.1 + Root anywhere except: "/data/data/com.jrummy.liberty.toolboxpro/files/sqlite3" where my install of ROM Toolbox Pro happened to install its own version luckily *Grin*. Nitrogen helped me track this down with: find / -iname sqlite3 and then I copied it to /system/xbin/ to make life a little easier
2. On the INSERT SQL statements I ran into the the closing Quote marks having to be deleted and manually typed in before they would function, seems they ended up slightly altered (formatting possibly) to the point a simple Copy/Paste wouldn't do the trick
The over all result was a success though, and I am very thankful you took the time to document this process !
 
  • Like
Reactions: Hostage XII

Hostage XII

Senior Member
Jul 17, 2012
242
63
0
Owings Mills
I used the ADB method and ran into 2 minor issues:
1. sqlite3 wasn't found, and doesn't seem to exist in my Stock TW 4.1.1 + Root anywhere except: "/data/data/com.jrummy.liberty.toolboxpro/files/sqlite3" where my install of ROM Toolbox Pro happened to install its own version luckily *Grin*. Nitrogen helped me track this down with: find / -iname sqlite3 and then I copied it to /system/xbin/ to make life a little easier
2. On the INSERT SQL statements I ran into the the closing Quote marks having to be deleted and manually typed in before they would function, seems they ended up slightly altered (formatting possibly) to the point a simple Copy/Paste wouldn't do the trick
The over all result was a success though, and I am very thankful you took the time to document this process !
Glad you got it working! With the quotes thing it can be tricky. For example " will work when using ADB through your computer but not when using ADB through Terminal on your phone, you have to use ' instead. Its weird.

Sent from my SPH-L710 using xda app-developers app
 

bazzawhite

Senior Member
Dec 9, 2009
114
22
0
Liverpool
softhands.co.uk
I'm having issues getting this working on my Galaxy Nexus 4.2.1. I edited the files via Root explorer and SQL editor and rebooted. Followed the instruction to the dot and am having no luck still get those annoying pop ups when I exceed the messages/hour limit. I have over 100 contacts and unlimited texts and since I work for a charity organisation I send lots of texts and this gets really annoying. Any help would be appreciated. Thanks
 

Hostage XII

Senior Member
Jul 17, 2012
242
63
0
Owings Mills
I'm having issues getting this working on my Galaxy Nexus 4.2.1. I edited the files via Root explorer and SQL editor and rebooted. Followed the instruction to the dot and am having no luck still get those annoying pop ups when I exceed the messages/hour limit. I have over 100 contacts and unlimited texts and since I work for a charity organisation I send lots of texts and this gets really annoying. Any help would be appreciated. Thanks
Have you tried the ADB method? Also, do you mean that the changes aren't sticking upon the reboot? Like are the added records missing or are they still there and nothing is happening?

Sent from my SPH-L710 using xda app-developers app