Remove SMS Limit

[anaylor01]

Maybe you can help me with this. I am trying to remove the SMS limit. I found some information on the net but am having trouble getting it to work. http://www.flixya.com/blog/2933174/How-to-Increase-the-SMS-Limit-on-Android-How to Increase the SMS Limit on AndroidIt keeps saying "No Such Table". Here is what I have so far.

SQL1.Initialize(File.DirInternal, "settings.db", True)
lblsendingto.Text =  SQL1.ExecQuerySingleResult("SELECT count(name) FROM gservices")

 

[Erel]

You should probably need to open some Android database for this. File.DirInternal means that you are opening a database local to your application. This database will not have any effect on the SMS limit.

 

[anaylor01]

According to the post. The database is /data/data/com.android.providers.settings/databases/settings.db
How would I initialize this? Here is the info from the post.

Open Command Terminal and enter the following:
adb shell
sqlite3 /data/data/com.android.providers.settings/databases/settings.db
Then you’ll see: sqlite>
To turn off the limit enter:
INSERT INTO gservices (name, value) VALUES(’sms_outgoing_check_interval_ms’, 0);
It worked right away for me.. (SMS Bomber >)) Id reboot to be safe.

 

[anaylor01]

I have an app that will do this. I ran it with Logcat running. I attached the Logcat file with the piece I think is beneficial highlighted. But I could be wrong about the highlighted part.

 

[anaylor01]

Any Ideas on this?

 

[Erel]

Enter: "/data/data/com.android.providers.settings/databases" instead of File.DirInternal in the Initialize line.

 

[anaylor01]

I tried the code below and it says unable to open file.

SQL1.Initialize("/data/data/com.android.providers.settings/databases/settings.db","/data/data/com.android.providers.settings/databases/settings.db", False)

 

[kickaha]

Maybe you should read the docs

Initialize (Dir As String, FileName As String, CreateIfNecessary As Boolean)

and then seperate the filename and the directory.

 

[anaylor01]

I did. I just didn't put 2 and 2 together. I have tried the following with the same result. "Unable to open"

SQL1.Initialize("data/data/com.android.providers.settings/databases","settings.db", False)
SQL1.Initialize("/data/data/com.android.providers.settings/databases","settings.db", False)
SQL1.Initialize("data/data/com.android.providers.settings/databases/","settings.db", False)
SQL1.Initialize("/data/data/com.android.providers.settings/databases/","settings.db", False)

 

[agraham]

Is your device rooted? I think that you need SU privileges to access the data folder.

 

[anaylor01]

Yeah my device is rooted and my app has SU rights.

 

[anaylor01]

I ran root explorer and the database is there. So what am I missing?

 

[anaylor01]

I ran the following code and was able to create a database in the same folder as the settings database.

SQL1.Initialize("/data/data/com.android.providers.settings/databases","TEST.db", True)

 

[anaylor01]

Ok. I went into root explorer and changed the permissions on settings.db. I will post another questions about how to change permissions.