not able to save database

[mh at mike.franken.de]

Hi again,

at least I got back a working copy of my database.
I saved it as a different file, but again with sqlite (cipher) format.
This file can be openend without a lock warning.
Modifying data and saving the file also is working.

So the actual problem seems to be solved, but the behaviour as such seems a 
bit strange 8-<

Bye.
Michael.

On Donnerstag, 26. November 2020 17:44:18 CET mh at mike.franken.de wrote:
> 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/mymoneys
> > > to
> > > 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/mymoneys
> > > to
> > > 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20201126/117d0dbe/attachment.htm>