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.
[SOLVED] I can't open database file from OneDrive. But desktop MMEX can open it normally.
Moderator: Renato
-
jkambb
- New User
- Posts: 5
- Joined: Sat Dec 16, 2023 4:33 am
- Are you a spam bot?: No
[SOLVED] I can't open database file from OneDrive. But desktop MMEX can open it normally.
- Attachments
-
- Image_20240318215938.png (38.9 KiB) Viewed 316 times
Last edited by jkambb on Mon Mar 25, 2024 6:12 am, edited 1 time in total.
-
guanlisheng
- Developer
- Posts: 382
- Joined: Wed Dec 21, 2011 5:58 am
- Are you a spam bot?: No
- Location: China
- Contact:
Re: I can't open database file from OneDrive. But desktop MMEX can open it normally.
Seems can’t open the file, please leave password empty/blank for non-encrypted database .
-
jkambb
- New User
- Posts: 5
- Joined: Sat Dec 16, 2023 4:33 am
- Are you a spam bot?: No
Re: I can't open database file from OneDrive. But desktop MMEX can open it normally.
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.
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.
- Attachments
-
- Image_20240319092148.png (42.1 KiB) Viewed 280 times
-
guanlisheng
- Developer
- Posts: 382
- Joined: Wed Dec 21, 2011 5:58 am
- Are you a spam bot?: No
- Location: China
- Contact:
Re: I can't open database file from OneDrive. But desktop MMEX can open it normally.
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.
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
- New User
- Posts: 5
- Joined: Sat Dec 16, 2023 4:33 am
- Are you a spam bot?: No
Re: I can't open database file from OneDrive. But desktop MMEX can open it normally.
I got it Sir. Ok. Cool! Thank you. 