MMEX Discussion Forum

Posted: **Sat Nov 30, 2024 6:49 pm**

Same as hxigor here

Posted: **Sat Nov 30, 2024 7:13 pm**

I would suggest that users revert to version 1.8 or not use encryption until the bug is fixed.

Posted: **Sat Nov 30, 2024 11:34 pm**

Thanks @hxigor and also the guy from the Github, we know it is page_size that triggers the issue now.

for some very old databases (e.g. before 2014), the page_size is 1024, while newer ones are 4096.

you can run PRAGMA page_size in wxSQLitePlus or any SQLite clients to tell the result.

4096, it will be fine to re-encryption

1024, you might have to update page size to 4096 via next reply

: 391296795-ff5eaba1-5a2a-4956-8c4b-3cc9c7937e70.png (97.3 KiB) Viewed 11900 times

Posted: **Sat Nov 30, 2024 11:50 pm**

here is the instruction to update the legacy page size (1024) to the default page size (4096).

run the following code to update page size in place

Code: Select all

PRAGMA page_size = 4096;
VACUUM;

: 391297483-133c6503-74f5-4c1b-b9a9-c64899198041.png (108.71 KiB) Viewed 11764 times

Posted: **Sun Dec 01, 2024 11:20 am**

@guanlisheng
Thanks for the analysis and fix, changing the page size to 4096 worked!

Posted: **Sun Dec 01, 2024 11:59 am**

Could you explain in detail the steps to take?
Thank you

Posted: **Sun Dec 01, 2024 1:43 pm**

https://github.com/moneymanagerex/money ... ssues/6971

MMEX Discussion Forum

[SOLVED] New v1.8.1 rejecting .emb database password

Re: New v1.8.1 rejecting .emb database password

Re: New v1.8.1 rejecting .emb database password

Re: New v1.8.1 rejecting .emb database password

Re: New v1.8.1 rejecting .emb database password

Re: New v1.8.1 rejecting .emb database password

Re: New v1.8.1 rejecting .emb database password

Re: New v1.8.1 rejecting .emb database password