Invoices cannot be opened anymore

[Derek Atkins]

Hi,

Bill White <bill at opentek.ca> writes:

> Sorry for the duplicate post but I did notice that someone stole the
> thread :)
>
> I have actually tested this on multiple OS/GnuCash version
> combinations. At this time I am on Ubuntu 12.04/GnuCash 2.4.10. I have
> also tested on Gentoo/GnuCash 2.4.11 and the issue is the same.
>
> I have checked into when I upgraded to 2.4.x. Logs tell me that the
> install was November 2012. I have GnuCash backup files from as far
> back as April 2 2013 for the 2.4.x files. I noticed the issue
> yesterday when GnuCash crashed. When I re-opened my file I noticed
> that I cannot search for invoices. I did try to open many of my
> GnuCash backup files and they all give the same problem. I do work by
> simply leaving the computer on with GnuCash open and it is likely that
> the program has not been closed and re-opened between April 2 and now.
>
> Business -> Customer -> Find Invoice and then select [Invoice ID]
> [matches regex] .
> Returns no invoices. Blank list.
>
> If I enable "search only active data" the result is exactly the same.
>
> I have also since notices that my tax table entries show a long list
> of empty items.

I am afraid I don't know what to tell you.  It sounds like your data
file got corrupted somehow.  However if you're using XML that shouldn't
have affected anything per se.

One thing you can try is to run a diff between the last .xac file and
the first .gnucash file in your set of backups and see what differences
might exist.

> Thanks!

-derek

> Bill White
> IT consultant, Systems & Network Specialist
> Opentek.ca Computing Solutions Incorporated
> Phone: 1-604-834-4065
> Skype: opentek.ca
> http://www.opentek.ca
>
> On 2013-05-02 8:25 am, Derek Atkins wrote:
>> Hi,
>>
>> "opentek.ca" <bill at opentek.ca> writes:
>>
>>> I'm hoping someone can help with this issue...
>>>
>>> I have a GnuCash XML file that i have been happily working from for
>>> the last
>>> 3 years. Today GnuCash crashed on me and now I cannot access my
>>> invoices. I
>>> do have all of the backup files in a directory (many for each
>>> day). Those
>>> that are named with the .gnucash extension all exhibit the
>>> problem. Those
>>> older files (pre 2.4.x upgrade) with the .xac extension do not
>>> exhibit the
>>> problem. The problem is that if I try to search invoices by any
>>> criteria I
>>> get no invoices returned. I have verified that the invoice data
>>> still exists
>>> in the XML file. I can even see all of the invoice numbers in
>>> GnuCash when
>>> looking at the Accounts Receivable account etc. I have also run
>>> GnuCash with
>>> the --debug and --extra flags and get no usable error messages in
>>> the trace
>>> file.
>>>
>>> Any help would be much appreciated...
>>
>> First, no need to post your question twice.  We did see it the first
>> time (even though someone else stole the thread).
>>
>> Second, What OS/Distro are you using?
>>
>> Third, when did you upgrade to 2.4.x, and when did you notice the
>> issue?
>>
>> Fourth, what happens when you go to Business -> Customer -> Find
>> Invoice
>> and then select [Invoice ID] [matches regex] .
>>
>> Fifth, what happens if you click on the "search only active data"
>> checkbox?
>>
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>
>> -derek
>
>
>

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available