[GNC] Lost Data
Matthew Lybanon
lybanon at earthlink.net
Wed Jan 8 15:58:01 EST 2020
Sorry, something happened to the first line of the listing I included in my last post when I pasted it into the message. The correct first line is
-rw-r--r--@ 1 matthewlybanon staff 52409 Jan 7 16:02 MAGS Show.gnucash
I tried opening it by navigating directly to that file, and got the “Report error …” message. I also tried opening one of the backup files (from the Gnucash file menu, without first renaming it MAGS Show.gnucash). Same result.
I suspect something may have happened to my copy of the Gnucash program. There were a few peculiarities when I ran it yesterday. I entered one transaction (the same way I have previously entered hundreds of transactions), and it ended up with the year 1899 attached to that line. I changed the date to 2019, and things looked normal. But when I tried to reconcile the December 2019 bank statement something about the process seemed different. Again, sorry to be so vague but I can’t quite put my finger on what was wrong.
I will retrieve a _.gnucash file from several days ago from my Time Machine backup, make sure it is called MAGS Show.gnucash (I’ll hide the current MAGS Show.gnucash in a temporary folder), and see if Gnucash can open it. If that doesn’t work then I don’t think it will hurt to reinstall Gnucash.app and see if that solves the problem.
Begin forwarded message:
> From: David Cousens <davidcousens at bigpond.com>
> Subject: Re: [GNC] Lost Data
> Date: January 7, 2020 at 11:13:18 PM CST
> To: Matthew Lybanon <lybanon at earthlink.net>, "<gnucash-user at gnucash.org> User" <gnucash-user at gnucash.org>
>
> Matthew,
>
> One thing that is immediately obvious in your list of files is that there currently is no active data file in the
> dirctory you have listed. The data file would appears as
>
> MAGS Show.gnucash
>
> in that listing. All the files you have shown are either backup or log files.
>
> MAGS Show.gnucash.20200107155657.gnucash is a backup file created on 7th January 2020 at 15:56:57
> and
> MAGS Show.gnucash.20200107160232.gnucash is a backup file created on 7th January 2020 at 16:02:32
> which appears to be the last time you successfully opened GnuCash. I would make a copy of this file and then rename the
> copy to
>
> MAGS Show.gnucash .
>
> You should then be able to open that file withiout any problem. The file
>
> MAGS Show.gnucash.20200107160232.log
>
> should have a record of the transactions you entered/reconciled since 16:02:32.
>
> Under the File->Import submenu you will find an entry "Replay GnuCash .log file. If you click on that entry a file
> selection dialog will come up. If you navigate to that last log file
>
> MAGS Show.gnucash.20200107160232.log
>
> and open the file and your reconciliation should be replayed into the register. When it has completed either use Save
> from the toolbar or File->Save from the menu (not File->Save As as that will rename the file with a new name and/or
> location). It is normally greyed out unless the data has been changed since either opening or the last save but
> replaying the log file should activate it. With any luck that should fix your problem. If not come back to the mailing
> list and tell us what happens when you try the above.
>
> David Cousens
>
> On Tue, 2020-01-07 at 22:13 -0600, Matthew Lybanon wrote:
>>> From: Matthew Lybanon <lybanon at earthlink.net>
>>> Subject: [GNC] Lost Data
>>> Date: January 7, 2020 at 4:31:14 PM CST
>>> To: "<gnucash-user at gnucash.org> User" <gnucash-user at gnucash.org>
>>>
>>>
>>> Gnucash 3.5-1 running on a MacBook Pro under macOS 10.14.6. I’m been using Gnucash for years for very simple
>>> accounting, primarily just maintaining a checkbook register. Today I had trouble reconciling a bank statement. After
>>> clicking “Finish” the reconciled transactions had a “y” in the appropriate column, but when I tried to quit Gnucash
>>> I got a message saying that something hadn’t been saved and asking if I wanted to save it. Sorry to be so vague, but
>>> I don’t recall exactly what the message was.
>>>
>>> When I restarted Gnucash the transactions that were previously reconciled weren’t; they had “n” in place of “y”. I
>>> tried to reconcile again, but the next time I started Gnucash and looked at the register I got the message
>>>
>>> "Report error
>>>
>>> An error occurred while running the report."
>>>
>>> I tried opening an earlier version of the data file (NAME.gnucash.string of numbers.gnucash) but got the same error
>>> message. I have not deleted anything. I have _.gnucash files, one _.LNK files, _.log files.
>>>
>>> What went wrong and–more important–how can I get the data back?
>>>
>>>
>>>
>>> From: David Cousens <davidcousens at bigpond.com>
>>> Subject: Re: [GNC] Lost Data
>>> Date: January 7, 2020 at 9:18:47 PM CST
>>> To: gnucash-user at gnucash.org
>>>
>>>
>>> Matthew
>>>
>>> Not sure what is going on. Were you opening using a recent entry in the File
>>> Open dialog? If so try navigating explicitly to your data file and opening
>>> it explicitly. Before doing so check there are no files with a .LCK
>>> extension in the directory with your data file as these will normally block
>>> opening the file although that should bring uop a dialog allowing you to
>>> override it. Deleting the files with the .LCK extension should not cause any
>>> problems as long as you don't have GnuCash open in another instance. They
>>> are intended to stop multiple instances of the program from opening the same
>>> file at the same time. AFAIK ".LNK" files are Windows created files and
>>> shouldn't have any effect on MacOSX or Linux. The report error tends to
>>> indicate that GnuCash is trying to open a report. Did you have a report tab
>>> open when you last closed the file?
>>>
>>> David Cousens
>>>
>>>
>>>
>>> -----
>>> David Cousens
>>> --
>>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>>>
>>>
>>>
>>>
>>>
>>
>> Normally I open the Gnucash application which, I understand, by default opens the _.gnucash data file. That now gives
>> the error message. The same thing happens when I open the _.gnucash file explicitly, and the same thing happens when
>> I open one of the the _.gnucash.string of numbers.gnucash files explicitly.
>>
>> Here is a list of all the Gnucash data (and related) files I now have (I got this list from the Terminal application).
>>
>> -rw-r--r--@ 1 matthewlybanon staff 52409 Jan 7 16:02
>> -rw------- 1 matthewlybanon staff 0 Jan 7 15:54 MAGS Show.gnucash.0.33401.LNK
>> -rw-r--r--@ 1 matthewlybanon staff 2380 Jan 7 11:23 MAGS Show.gnucash.20200107111856.log
>> -rw-r--r--@ 1 matthewlybanon staff 359 Jan 7 15:40 MAGS Show.gnucash.20200107112457.log
>> -rw-r--r--@ 1 matthewlybanon staff 779 Jan 7 15:55 MAGS Show.gnucash.20200107155416.log
>> -rw-r--r--@ 1 matthewlybanon staff 52283 Jan 7 11:24 MAGS Show.gnucash.20200107155657.gnucash
>> -rw-r--r--@ 1 matthewlybanon staff 4370 Jan 7 15:57 MAGS Show.gnucash.20200107155657.log
>> -rw-r--r--@ 1 matthewlybanon staff 4581 Jan 7 16:01 MAGS Show.gnucash.20200107155856.log
>> -rw-r--r--@ 1 matthewlybanon staff 52402 Jan 7 15:56 MAGS Show.gnucash.20200107160232.gnucash
>> -rw-r--r--@ 1 matthewlybanon staff 170 Jan 7 16:02 MAGS Show.gnucash.20200107160232.log
>>
>> I could try to open an older version of MAGS Show.gnucash from a Time Machine backup, but since opening one of the
>> MAGS Show.gnucash.numbers.gnucash files didn’t work I don’t see why that would work, either. It seems as if the
>> problem may be something else. I’m open ot suggestions.
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> --
> Dr David R Cousens
> B.Sc, M.Prof. Acc., Ph.D., G.C.Ed
>
More information about the gnucash-user
mailing list