kmymoney 5.20: Can't open sqlcipher database

[Thomas Baumgart]

Michael,

On Donnerstag, 3. Juli 2025 12:01:52 CEST mh--- via KMyMoney wrote:

> Hi *,
> 
> after openSUSE Tumbleweed upgraded to kmymoney 5.20 I am not able to 
> open my datebase, which has the sqlcipher format:
> 
> kmymoney "sql://<user>@localhost//home/docs/SPARDA.sqlcipher?
> driver=QSQLCIPHER&secure=yes"
> 
> shows an infinite amount of
> 
> Perform upgrade to db layout version 14
> Unknown version number in database - 13
> 
> messages, after entering the password.
> 
> How can I solve this?

Wow, there was an update on reports that did not get implemented in the
SQL backend (not only SQLcipher). For now, you can manually set the
version in the kmmFile record to 14 to get around the problem.

Once 5.2.1 is out you might need to reset that to 13 to run the update
procedure for the reports. Keep a backup before you do that and don't
play around with reports too much (keep notes what you did in case
we need to restore the table from the backup once 5.2.1 is out).

I filed a bug for that: https://bugs.kde.org/show_bug.cgi?id=506569

-- 

Regards

Thomas Baumgart

-------------------------------------------------------------
A crash turns an expensive computer into a simple stone!
-------------------------------------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 868 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20250704/baf4d7d7/attachment.sig>