Page 1 of 1

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

Posted: Mon Mar 18, 2024 3:01 pm
by 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.

Re: I can't open database file from OneDrive. But desktop MMEX can open it normally.

Posted: Tue Mar 19, 2024 1:57 am
by guanlisheng
Seems can’t open the file, please leave password empty/blank for non-encrypted database .

Re: I can't open database file from OneDrive. But desktop MMEX can open it normally.

Posted: Tue Mar 19, 2024 2:09 am
by jkambb
It works for non-encrypted database. I still keep backup of non-encrypted version. Thanks a lot Sir. :D
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.

Re: I can't open database file from OneDrive. But desktop MMEX can open it normally.

Posted: Tue Mar 19, 2024 2:45 am
by 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.

Re: I can't open database file from OneDrive. But desktop MMEX can open it normally.

Posted: Tue Mar 19, 2024 3:26 am
by jkambb
I got it Sir. Ok. Cool! Thank you. 8-) 8-) 8-)