<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;">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/mymoneysto</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/mymoneysto</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;"><br /></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 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 opened</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">by me@localhost. I can see all newly added data in it, but trying to 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;"><br /></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;">> 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;"><br /></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;"><br /></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;"><br /></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;"><br /></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;"><br /></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;"><br /></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;"><br /></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;"><br /></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;"><br /></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;"><br /></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>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;"><br /></p>
<br /></body>
</html>