Android Question sql error

StarinschiAndrei said:

Can anybody advice me what shod i do or try ?

Click to expand...

StarinschiAndrei said:

Hi everyone,
I'm facing with the following situation:
i have 2 test environment; 1 - Samsung A71 - Android 13 and Xiomi Mi6 with Android 9.
if a run the app on Samsung is working on Xiomi I get an SQL error

B4X:

pg_sell_new_load_items (java line: 674)
android.database.sqlite.SQLiteException: no such table: tbl_items (code 1 SQLITE_ERROR): , while compiling: Select * FROM tbl_items WHERE Activ=1 order by Nume ASC

Can anybody advice me what shod i do or try ?
Thank you.

Click to expand...

Caused by: android.database.sqlite.SQLiteException: no such table: tbl_items (code 1): , while compiling: Select * from tbl_items order by Nume ASC
#################################################################
Error Code : 1 (SQLITE_ERROR)
Caused By : SQL(query) error or missing database.
(no such table: tbl_items (code 1): , while compiling: Select * from tbl_items order by Nume ASC)
#################################################################

Click to expand...

StarinschiAndrei said:

Thank you for everybody support , i made some tests and i think the problem is with permission on Xiomi , the db file is on device (attached image), but app can't access the db , here

B4X:

    SQL1.Initialize(xui.DefaultFolder, "pos.db",False)

i get the error. On Samsung it works perfect.

B4X:

** Service (starter) Start **
** Activity (main) Create (first time) **
true
Error occurred on line: 39 (B4XMainPage)
android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14 SQLITE_CANTOPEN): Could not open database
    at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)
    at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:211)
    at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:195)
    at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:503)
    at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:204)
    at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:196)
    at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:880)
    at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:868)
    at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:766)
    at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:714)
    at anywheresoftware.b4a.sql.SQL.Initialize(SQL.java:44)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.shell.Shell.runVoidMethod(Shell.java:777)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:354)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:157)
    at anywheresoftware.b4a.debug.Debug.delegate(Debug.java:262)
    at com.stoltex.MultiColumnCustomListView.b4xmainpage._b4xpage_created(b4xmainpage.java:72)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.debug.Debug.CallSub4(Debug.java:318)
    at anywheresoftware.b4a.debug.Debug.CallSubNew2(Debug.java:285)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.keywords.Common.CallSubDebug2(Common.java:1087)
    at com.stoltex.MultiColumnCustomListView.b4xpagesmanager._createpageifneeded(b4xpagesmanager.java:1071)
    at com.stoltex.MultiColumnCustomListView.b4xpagesmanager._showpage(b4xpagesmanager.java:428)
    at com.stoltex.MultiColumnCustomListView.b4xpagesmanager._addpage(b4xpagesmanager.java:248)
    at com.stoltex.MultiColumnCustomListView.b4xpagesmanager._addpageandcreate(b4xpagesmanager.java:262)
    at com.stoltex.MultiColumnCustomListView.b4xpagesmanager._initialize(b4xpagesmanager.java:168)
    at com.stoltex.MultiColumnCustomListView.main._activity_create(main.java:419)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:351)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:157)
    at com.stoltex.MultiColumnCustomListView.main.afterFirstLayout(main.java:105)

View attachment 156037

Click to expand...

aeric said:

Have you uninstalled the app first after you made changes to the code I suggested?

Click to expand...