kmymoney 5.20: Can't open sqlcipher database

[Thomas Baumgart]

On Freitag, 4. Juli 2025 12:06:54 CEST mh--- via KMyMoney wrote:

> 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,

The translation is performed by a complete different team in KDE. I can
tell you anything about the status. You can probably get more information
when you politely ask on http://mail.kde.org/mailman/listinfo/kde-i18n-de/
about the status of the KMyMoney 5.2 translation for German.

> my settings from 5.1.3 for the GUI are gone, 5.20 started over with the 
> default settings.

Not sure why this happened. We simply use the KDE provided mechanisms.

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

The fix is already in review and soon part of the source repo.

-- 

Regards

Thomas Baumgart

-------------------------------------------------------------
The ability to speak several languages is an asset, but the ability to
keep your mouth shut in any language is priceless! -- ITI Bulletin 6.7.1990
-------------------------------------------------------------
-------------- 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/066dab2b/attachment.sig>