Invoices cannot be opened anymore

[Bill White]

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.

Thanks!

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