Android Question (Fixed) Error 14: Could not open db

Emme Developer · Apr 18, 2020

Hi to all, i'm trying to initialize a db in File.dirInternal (copied from assets) but i got this error:

B4X:

android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14 SQLITE_CANTOPEN): Could not open database

This is the code i use:

B4X:

If File.Exists(File.DirInternal,DB_NAME) Then
        sqlManager.Initialize(File.DirInternal,DB_NAME,False)
    Else
        File.Copy(File.DirAssets,DB_NAME,File.DirInternal,DB_NAME)
        sqlManager.Initialize(File.DirInternal,DB_NAME,False)
    End If

I think is right because is a shared sub that I use in all my projects... So i don't understand the issue.
File in assets exists. Also in DirInternal.. I know i can use DBUtils to copy file, but i need to understand why i'm getting this error

Thanks to all

Emme Developer · Apr 18, 2020

I noticed that I can open another db... maybe could be this specific db?

drgottjr · Apr 18, 2020

normally, i would suspect an issue with DB_NAME (eg, you spelled it wrong or there is a problem with case sensitivity - "A" vs "a"), but in this case if there was a problem with DB_NAME, your tests would have failed and you would have seen a different error. perhaps you did and didn't tell us...

so, if the problem is not with DB_NAME, it would seem to be with the db itself. is it sqlite for sure? did you create it? perhaps it's corrupt?

makis_best · Apr 18, 2020

If you copy that database on your computer you can use it?
You can open it?

aeric · Apr 18, 2020

Maybe the db is readonly if you are reading it from assets folder.

Emme Developer · Apr 18, 2020

drgottjr said:
normally, i would suspect an issue with DB_NAME (eg, you spelled it wrong or there is a problem with case sensitivity - "A" vs "a"), but in this case if there was a problem with DB_NAME, your tests would have failed and you would have seen a different error. perhaps you did and didn't tell us...

so, if the problem is not with DB_NAME, it would seem to be with the db itself. is it sqlite for sure? did you create it? perhaps it's corrupt?

Now way to have a problem with dbname as i use it in every sub, so i'm sure there is not a problem with mispelling. I'm sure it is SQLite, i created it with SQLliteStudio.
I think it's not corrupted, maybe can be an issue with table

makis_best said:
If you copy that database on your computer you can use it?
You can open it?

Yes i can open without any issue

aeric said:
Maybe the db is readonly if you are reading it from assets folder.

I'm trying to read from Dirinternal, not assets. Btw is not readonly

makis_best · Apr 18, 2020

You are 100% that the name of your database are the same on your database file and everywhere on your code?
Are you sure you don't have any other instance open?
Are you sure that the folder you use is not read only?
Have you try to create another file inside that folder?

klaus · Apr 18, 2020

What exactly is : DB_NAME ?

Emme Developer · Apr 18, 2020

makis_best said:
You are 100% that the name of your database are the same on your database file and everywhere on your code?
Are you sure you don't have any other instance open?
Are you sure that the folder you use is not read only?
Have you try to create another file inside that folder?

Yes, 100%
Yes
Yes
Yes

Emme Developer · Apr 18, 2020

klaus said:
What exactly is : DB_NAME ?

dbgames.db, i've declared it globally

B4X:

Sub Class_Globals
    Private sqlManager As SQL
    Private DB_NAME As String = "dbgames.db"
End Sub

aeric · Apr 18, 2020

Try restart the PC, maybe the file is locked by other processes. ?

Emme Developer · Apr 18, 2020

aeric said:
Try restart the PC, maybe the file is locked by other processes. ?

The error is on Android

Pendrush · Apr 18, 2020

Did you maybe upload your DB to your phone from PC directly? Trough ADB, FTP or any other way?
EDIT:
Can you upload example project?

Mahares · Apr 18, 2020

I think you need to upload your project if you can as Pendrush suggested. But, here is another suggestion, as if you need another one, did you try to delete the database from internal and then copy it back to internal from assets and initialize it on firsttime in internal. I hope I am not repeating a recommendation given in the posts above.

OliverA · Apr 18, 2020

Pure guess: could it be due to version differences in SQLite? Android is notorious for being behind. Does the desktop version use a feature that the older SQLite can not deal with?

Mahares · Apr 18, 2020

OliverA said:
Pure guess: could it be due to version differences in SQLite?

Usually, from what I observed in the past, if the version on the device is behind you get a syntax error. But, I am guessing too. See this thread:

SQLite "OVER PARTTION" not supported in B4A ?!

Hi, I wanted to add some statistics to my App and now have the problem, that it seems that "OVER" is not supported by B4A ?! SELECT Spieler, count(*) OVER (PARTITION BY spieler ORDER BY Spieler_Spieltag.ID_Spieltag) as Part_SUM from Spieler_Spieltag Executing the statement in "DB Browser for...

www.b4x.com

Please MDev, don't let us down. we are all eager to find out what you come up with. Watch, tomorrow Erel will blow by all our suggestions and give him the correct diagnosis.

Emme Developer · Apr 19, 2020

Pendrush said:
Did you maybe upload your DB to your phone from PC directly? Trough ADB, FTP or any other way?
EDIT:
Can you upload example project?

I need to try to copy directly as you suggest.

Mahares said:
I think you need to upload your project if you can as Pendrush suggested. But, here is another suggestion, as if you need another one, did you try to delete the database from internal and then copy it back to internal from assets and initialize it on firsttime in internal. I hope I am not repeating a recommendation given in the posts above.

I delete all files in internal folder everytime i start the app, to be sure that i will a fresh copy of db (of course only meanwhile i'm in debug)

OliverA said:
Pure guess: could it be due to version differences in SQLite? Android is notorious for being behind. Does the desktop version use a feature that the older SQLite can not deal with?

I'm no trying to do nothing, only initialize the db. I don't think the problem is releated to a specific version

I'm attaching a small project that replicates the issue, hope to help someone to find the right way. Thanks to everybody

Emme Developer · Apr 19, 2020

Mahares said:
Please MDev, don't let us down. we are all eager to find out what you come up with. Watch, tomorrow Erel will blow by all our suggestions and give him the correct diagnosis.

I'm sure of this, but i'm also sure we can find a solution without the help of Erel (but if he wants to help of course he can )

Emme Developer · Apr 19, 2020

Finally, found the issue!!
The problem is in the DB, i've using a table with a colum named All, and seems that All is a restricted keyword in sqllite so we can't use it as column name

SQLite Keywords

I am quite irritated by the error, could be specified the problem instead of giving error 14, but at the least without this colum all works properly.

Thanks to all for help, and sorry for wasting your time

Mahares · Apr 19, 2020

I was just going to post that I deleted the table called: progress and then it worked fine.
Also, you have columns in that table with data type as STRING. I have never seen that before. I usually put TEXT. Is STRING a valid data type in SQLite. Apparently, it is valid. You learn something every day.

Android Question (Fixed) Error 14: Could not open db

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Expert

Expert

Expert

Well-Known Member

Attachments

Well-Known Member

Well-Known Member

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency