not able to save database

[Michael Hirmke]

On Donnerstag, 26. November 2020 17:16:23 CET Jack wrote:
> On 11/26/20 10:19 AM, mh at mike.franken.de wrote:
> > Hi *,
> > 
> > 
> > today I got an error message
> > 
> > 
> > payeeIdentifier with id 'IDENT000001' not found
> > /home/abuild/rpmbuild/BUILD/kmymoney-5.1.0/kmymoney/plugins/sql/mymoneysto
> > ragesql.cpp:1487
> > 
> > 
> > that prevents me from saving any changes to my database.
> > 
> > I get this messages on the first attempt to save, on the second any
> > any subsequent attempts I get
> > 
> > 
> > Error in function bool MyMoneyStorageSql::writeFile() : starting
> > commit unit
> > 
> > Driver = QSQLCIPHER, Host = localhost, User = hirmkem, Database =
> > //home/hirmkem/finanzen/konto/kmymoney/SPARDA
> > 
> > Driver Error:
> > 
> > Database Error No -1:
> > 
> > Text:
> > 
> > Error type 0
> > 
> > Executed:
> > 
> > Query error No -1: Driver not loaded Driver not loaded
> > 
> > Error type 1
> > /home/abuild/rpmbuild/BUILD/kmymoney-5.1.0/kmymoney/plugins/sql/mymoneysto
> > ragesql.cpp:359
> > 
> > 
> > 
> > I spent two hours adding new data to my accounts - are they all lost?
> > 
> > 
> > TIA.
> > 
> > 
> > Bye.
> > 
> > Michael.
> 
> 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.

I already killed the program 8-(
But obviously I was lucky, somehow a copy was created, where all data survived 
the kill.
Opening this file, though, gives me a warning that the file is already opened
by me at 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.

> 
> Can you run a consistency check?  That issue of not finding a Payee with

A consistency check tells me that all data are consistent.

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

Distribution is openSUSE Tumbleweed.

rpm -q aqbanking kmymoney sqlite3 libsqlcipher-3_31_0-0
aqbanking-6.2.5-1.1.x86_64
kmymoney-5.1.0-2.2.x86_64
sqlite3-3.33.0-1.3.x86_64
libsqlcipher-3_31_0-0-4.4.0-1.1.x86_64

Running from the commandline doesn't show any message.

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

Again not a single message.

> 
> Jack

Thx.
Bye.
Michael.

-- 
Michael Hirmke
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20201126/a7ce6c89/attachment-0001.htm>