<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">On 11/26/20 10:19 AM,
<a class="moz-txt-link-abbreviated" href="mailto:mh@mike.franken.de">mh@mike.franken.de</a> wrote:<br>
</div>
<blockquote type="cite" cite="mid:5620410.xrssjR2HX5@thunder">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<p
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Hi
*,</p>
<br>
<p
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">today
I got an error message</p>
<br>
<p
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">payeeIdentifier
with id 'IDENT000001' not found
/home/abuild/rpmbuild/BUILD/kmymoney-5.1.0/kmymoney/plugins/sql/mymoneystoragesql.cpp:1487</p>
<br>
<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;">I
get this messages on the first attempt to save, on the second
any any subsequent attempts I get</p>
<br>
<p
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Error
in function bool MyMoneyStorageSql::writeFile() : starting
commit unit</p>
<p
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Driver
= QSQLCIPHER, Host = localhost, User = hirmkem, Database =
//home/hirmkem/finanzen/konto/kmymoney/SPARDA</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;">Database
Error No -1: </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;">Error
type 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;">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;">Error
type 1
/home/abuild/rpmbuild/BUILD/kmymoney-5.1.0/kmymoney/plugins/sql/mymoneystoragesql.cpp:359</p>
<br>
<br>
<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>
<br>
<p
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">TIA.</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>
</blockquote>
<p>The SQL backend is similar to the XML (file) backend in that data
is not saved per activity as a usual database application, but
only when you do an explicity File/Save. So unfortunately, if you
have quit KMM without doing a successful save, then yes, the data
is gone. However, if you haven't quit yet, you can do Save As,
choose the XML plugin, and save as a .kmy file. Then, once we
figure out the database problem, you can re-save to a database.</p>
<p>Can you run a consistency check? That issue of not finding a
Payee with a given identifier seems odd, but I'll have to look
into the source code to see if that's an sql specific error. The
Driver not loaded error also seems odd, since I would expect such
an error to show up earlier. So, a few further questions.</p>
<p>What OS/distribution are you using? Can you run from command
line, as there may be more detailed messages output to console.
Also, what versions of KMM, sqlite, and sqlcipher are you using?</p>
<p>One other thing you can try is to start with "kmymoney -n" which
does NOT open the last file/database. Then try to create a new
file using sqlcipher. Again, you may get more detailed messages
if you run from the command line.<br>
</p>
<p>Jack<br>
</p>
</body>
</html>