After updating to Version: 1.9.0 I cannot save as encrypted database

[Eduardommex]

I have still dealing with a problem to save my current mmb database to an encrypted emb file. After creating a database, this message come up:
SQL logic error[1]: Rekeying failed. Pagesize cannot be changed for an encrypted database.

Then if I try to open this new file this another message come up.

When database file opening:
/home/eduardo/Documents/Finanzas/MMEx/MMExdatabase/EduardoMMExdatabase2025.emb
An incorrect password given for an encrypted file
or attempt to open a File that is not a database file

I am installed a Flatpak version on my Ubuntu 24.04

[Renato]

seems to be the same problem as user Redwise viewtopic.php?t=11242

[Eduardommex]

Right, I had the same problem with 1.8.1, but I assumed this was fixed in 1.9 wasn't it?. It will require to follow the process mentioned in GitHub even for 1.9 as well?

[Renato]

I can't answer that, a developer would have to comment on that.
@whall3y @nstein

[Eduardommex]

@whall3y @nstein Is there any update on that?

[Eduardommex]

Hi,@whall3y, @nstein, and @Renato , I have been waiting and requesting a new version of MMEx, for encrypting my MMEx database again.
When version 1.9 was released, I assumed everything would be fixed, but that wasn’t the case, so I kept requesting it, (see above).

Later, after reading the blog information again, I realized that the issue might not be with the new version itself, but rather with my old database that I was still using, that not working with the increasing of number of-bit encryption that new versions have..
So, I made a simple change in the database that seems to have worked, and I want to share it in case anyone else wants to try it.
1. downloaded DB Browser for SQLite: https://sqlitebrowser.org/
2. made a copy of my database as EDB_copy.mmb, just in case.
3. opened the database with the browser (EDB_copy.mmb).
4. changed page_size to 4096 in the EDB_copy.mmb database.
5. opened MMEX with this modified database and then encrypted it using the MMEX menu option.

It seems to be working fine, and I didn’t need to modify Vacuum.