Android Question MySql not working on Galaxy S5

[Shay]

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:

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:

File.Copy(File.DirAssets,"Parameters.db",File.DirDefaultExternal,"Parameters.db")
      SQL2.Initialize(File.DirDefaultExternal,"Parameters.db", False)

any idea what is wrong here?

 

[DonManfred]

seems that the db on s5 is not the same as the one you are using...
Try to remove the file File.DirDefaultExternal,"Parameters.db" before starting the app on the s5 device and then run your app again..

 

[Shay]

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

 

[DonManfred]

maybe try to save the db-file in file.DirInternal. This must work in emulator also if there is no sdcard...

 

[edgar_ortiz]

Be sure that in your database your column "Must_Approve" have the same characteres (case sensitive).

Regards

Edgar

 

[Shay]

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

 

[tsteward]

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

 

[Shay]

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

 

[guidoarfini]

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 ....

 

[KMatle]

Maybe a general Kitkat (Android 4.4) issue? "Starting from Android 4.4 you can only save on the SD card under one specific folder.
This is how Google designed it..."

http://www.b4x.com/android/forum/th...elete-files-on-external-sd-with-kitkat.37592/