Android Question MySql not working on Galaxy S5

Shay

Well-Known Member
Licensed User
Longtime User
Hi

I am getting complains that my app is not working on Galaxy S5 or Nexus 5
I think I manage to see the issue (I sent debug apk to someone) and he says he see this:

java.lang.IllegalArgumentException: column 'Must_Approve' does not exist

I then used the avg manager and saw same issue
this is related to this code part:
B4X:
Sub Read_Settings
       
    Cursor2 = SQL2.ExecQuery("SELECT * FROM Table_Parameters")
    Cursor2.Position = 0
   
    Must_Approve = (Cursor2.GetString("Must_Approve"))

but if I run this on my galaxy s2, I can get the result from the parameter table

this is how I init the sql:
B4X:
File.Copy(File.DirAssets,"Parameters.db",File.DirDefaultExternal,"Parameters.db")
      SQL2.Initialize(File.DirDefaultExternal,"Parameters.db", False)

any idea what is wrong here?
 

Shay

Well-Known Member
Licensed User
Longtime User
In Emulator it is still happening (no idea if this can work in emulator or not - can you answer?)
I sent the new apk to the guy - pending his answer
 
Upvote 0

edgar_ortiz

Active Member
Licensed User
Longtime User
Be sure that in your database your column "Must_Approve" have the same characteres (case sensitive).

Regards

Edgar
 
Upvote 0

Shay

Well-Known Member
Licensed User
Longtime User
I found the issue, it seems that my table was "reverted" to old version
I have no idea how it happened, and how this is related only to new phones
(since on old phone it is working fine)
any way this issue is closed
 
Upvote 0

tsteward

Well-Known Member
Licensed User
Longtime User
I also have a complaint my app is not working on Galaxy S5 after updating to 4.4
It also is a SQL based app.
So far I haven't had a chance to find the cause. Customer just left bad review
 
Upvote 0

Shay

Well-Known Member
Licensed User
Longtime User
As I wrote above it was bug that was ignored on old phones, so check if you run over your tables, each time app is loaded
 
Upvote 0

guidoarfini

Member
Licensed User
Longtime User
good day .. i have a similar problem ... app to work correctly .. s3 amount of contacts from the phone (2094) and insert them in sqlite database ... 560 app crash whit s5 ....
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…