<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Hi again,</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">at least I got back a working copy of my database.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">I saved it as a different file, but again with sqlite (cipher) format.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">This file can be openend without a lock warning.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Modifying data and saving the file also is working.</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">So the actual problem seems to be solved, but the behaviour as such seems a bit strange 8-<</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Bye.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Michael.</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">On Donnerstag, 26. November 2020 17:44:18 CET mh@mike.franken.de wrote:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> On Donnerstag, 26. November 2020 17:16:23 CET Jack wrote:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > On 11/26/20 10:19 AM, mh@mike.franken.de wrote:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Hi *,</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > today I got an error message</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > payeeIdentifier with id 'IDENT000001' not found</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > /home/abuild/rpmbuild/BUILD/kmymoney-5.1.0/kmymoney/plugins/sql/mymoneys</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > to</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > ragesql.cpp:1487</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > that prevents me from saving any changes to my database.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > I get this messages on the first attempt to save, on the second any</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > any subsequent attempts I get</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Error in function bool MyMoneyStorageSql::writeFile() : starting</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > commit unit</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Driver = QSQLCIPHER, Host = localhost, User = hirmkem, Database =</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > //home/hirmkem/finanzen/konto/kmymoney/SPARDA</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Driver Error:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Database Error No -1:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Text:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Error type 0</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Executed:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Query error No -1: Driver not loaded Driver not loaded</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Error type 1</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > /home/abuild/rpmbuild/BUILD/kmymoney-5.1.0/kmymoney/plugins/sql/mymoneys</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > to</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > ragesql.cpp:359</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > I spent two hours adding new data to my accounts - are they all lost?</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > TIA.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Bye.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Michael.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > The SQL backend is similar to the XML (file) backend in that data is not</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > saved per activity as a usual database application, but only when you do</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > an explicity File/Save. So unfortunately, if you have quit KMM without</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > doing a successful save, then yes, the data is gone. However, if you</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > haven't quit yet, you can do Save As, choose the XML plugin, and save as</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > a .kmy file. Then, once we figure out the database problem, you can</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > re-save to a database.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> I already killed the program 8-(</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> But obviously I was lucky, somehow a copy was created, where all data</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> survived the kill.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Opening this file, though, gives me a warning that the file is already</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> opened by me@localhost. I can see all newly added data in it, but trying to</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> modify and save another change shows the same messages as described above.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > Can you run a consistency check? That issue of not finding a Payee with</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> A consistency check tells me that all data are consistent.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > a given identifier seems odd, but I'll have to look into the source code</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > to see if that's an sql specific error. The Driver not loaded error</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > also seems odd, since I would expect such an error to show up earlier.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > So, a few further questions.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > What OS/distribution are you using? Can you run from command line, as</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > there may be more detailed messages output to console. Also, what</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > versions of KMM, sqlite, and sqlcipher are you using?</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Distribution is openSUSE Tumbleweed.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> rpm -q aqbanking kmymoney sqlite3 libsqlcipher-3_31_0-0</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> aqbanking-6.2.5-1.1.x86_64</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> kmymoney-5.1.0-2.2.x86_64</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> sqlite3-3.33.0-1.3.x86_64</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> libsqlcipher-3_31_0-0-4.4.0-1.1.x86_64</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Running from the commandline doesn't show any message.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > One other thing you can try is to start with "kmymoney -n" which does</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > NOT open the last file/database. Then try to create a new file using</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > sqlcipher. Again, you may get more detailed messages if you run from</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > the command line.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Again not a single message.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > Jack</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Thx.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Bye.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Michael.</p>
<br /><br /></body>
</html>