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

[yopiglop]

Same as hxigor here

[Renato]

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

[guangong]

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 10834 times

[guangong]

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 10698 times

[hxigor]

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

[Giapo]

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

[Renato]

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