[SOLVED] I can't open database file from OneDrive. But desktop MMEX can open it normally.

[jkambb]

When I editing database on OneDrive, after syncing, I open android app to access the file, and this is happening [File is not a database: , while compiling: select count(*) from sqlite_master;] Can you tell me what is the error?
Now I only access the data from desktop version, only runs on desktop. Android is unable to run.
I'm using 2024.03.07, downloaded from F-droid.

[guanlisheng]

Seems can’t open the file, please leave password empty/blank for non-encrypted database .

[jkambb]

It works for non-encrypted database. I still keep backup of non-encrypted version. Thanks a lot Sir.
But with encrypted database, I can't open it even type password correctly. I am working on it.
2 cases testing with encrypted database
Case 1: filling password and still appear the same error.
Case 2: leave blank and press OK, it appears the error as screenshot I attach
* Encrypted file still be opened on desktop with the same password I will to open the file on android.

[guanlisheng]

Great it works.

So far, the two use different ciphers, aes256(SQLCihper) for android while aes128 for desktop. Desktop has a temp schedule (v1.7.2) to upgrade to aes256.


a workaround to test/verify encrypted desktop database is via wxSQLitePlus to covert it to aes256.

[jkambb]

I got it Sir. Ok. Cool! Thank you.