kmymoney 5.20: Can't open sqlcipher database

[mh at mike.franken.de]

Hi,

On Freitag, 4. Juli 2025 09:44:39 Mitteleuropäische Sommerzeit Thomas 
Baumgart via KMyMoney wrote:
> 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.

I'll try that.
In the meantime I had installed an older version (5.1.3), saved the 
database file in xml format, reinstalled the latest version and used the 
xml file. That worked as expected, but
the translation to German is incomplete, i.e. I have mixed entries in 
the menu and other places using two languages,
my settings from 5.1.3 for the GUI are gone, 5.20 started over with the 
default settings.

> 
> 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).

Ok.

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

Thx.

Bye.
Michael.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20250704/d5dc868f/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4015 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20250704/d5dc868f/attachment.bin>