After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 448853 - Cannot find customers nor invoices.
Cannot find customers nor invoices.
Status: VERIFIED FIXED
Product: GnuCash
Classification: Other
Component: Business
2.1.x
Other Linux
: Normal critical
: ---
Assigned To: Derek Atkins
Derek Atkins
: 443815 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2007-06-18 17:50 UTC by Bastiaan
Modified: 2018-06-29 21:39 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Bastiaan 2007-06-18 17:50:08 UTC
In recent unstable versions (latest tested 2.1.4) I cannot open any existing invoice or customer record. The search result always is an empty set. Using 2.0.5 on the same file works fine.
Comment 1 Andreas Köhler 2007-06-18 21:13:29 UTC
Confirming.

I lowered the severity, because I think one can find invoices by searching for customers and showing theirs.
Comment 2 Bastiaan 2007-06-19 09:35:18 UTC
Thanks for the tip. I remembered working around it, but now I was searching for invoices by customer, which fails. The workaround you describe works.
Comment 3 Derek Atkins 2007-06-19 14:53:12 UTC
What search criteria are you using to find invoices so I can attmept to reproduce this.  I'm also changing the version becuse, well, there IS no 2.2.0 version yet.
Comment 4 Bastiaan 2007-06-19 17:33:19 UTC
Invoice-ID, Company Name, Date Opened, Is Posted, Date Posted, Is Paid, none of these work. The others do not apply. When I press Find I cannot see that there is any reaction. A message like "no match found" would be helpful.

I go back to version 2.0.5 now and then, and I notice that each time I do this, the accounts are nested in one extra "Root Account". For each of these, the console reports 

<filename>:31: element gnc-v2: Schemas validity error : Element 'gnc-v2': No matching global declaration available for the validation root.

I don't know whether this is related or not.
Comment 5 Derek Atkins 2007-06-19 17:51:00 UTC
Please file a separate bug report about the extra root account.

I'll look into the searches.

Quick question:  do any of your Company Names have accented (non-ASCII) characters?
Comment 6 Andreas Köhler 2007-06-19 17:58:16 UTC
A-Za-z0-9 only here.
Comment 7 Bastiaan 2007-06-19 18:11:03 UTC
No non-ASCII characters. They do have a space and one contains an ordinary comma [,].
Comment 8 Derek Atkins 2007-06-19 18:11:52 UTC
I can certainly confirm that this is an issue.  I can't even search by invoice ID.  I've raised this to critical because it means you can't modify the report options for invoice reports.
Comment 9 Derek Atkins 2007-06-19 18:16:53 UTC
So, the question is:   when did it STOP working?  Can someone take the time to test various timepoints in SVN and figure out when it stopped working?
Comment 10 Bastiaan 2007-06-19 18:26:22 UTC
I can quickly test 2.1.2. I think it was an issue there too.
Comment 11 Derek Atkins 2007-06-19 18:32:40 UTC
It would be interesting to compare r15845 and r15846
Comment 12 Bastiaan 2007-06-19 18:38:17 UTC
Yes, it is prior r16109 (v2.1.2).
Comment 13 Derek Atkins 2007-06-19 18:41:33 UTC
Right..  I'd like to know if r15845 works or still has this issue.
Comment 14 Bastiaan 2007-06-19 18:48:21 UTC
I cannot help you with r15845 at this moment, sorry. IIRC, r15667 worked.
Comment 15 Andreas Köhler 2007-06-19 21:20:47 UTC
I can confirm that r15846 broke it.
Comment 16 Derek Atkins 2007-06-20 16:52:23 UTC
Yep, 15846 definitely broke it.  Damn.  Okay, time to see what I did.  :(
Is this limited to invoices?  Do other searches fail, too?
Comment 17 Derek Atkins 2007-06-20 18:09:40 UTC
*** Bug 443815 has been marked as a duplicate of this bug. ***
Comment 18 Derek Atkins 2007-06-20 18:17:30 UTC
Okay, I've tracked it down a little more to somewhere between r15762 and r15779 in the gobject-engine-dev-warlord branch.  This means it broke somewhere early on in the conversion of QofEntity->QofInstance, somewhere in r15772, r15773, r15778, or r15779.  In reality it should be limited to only those first three; the last one is just moving the branch so shouldn't have had any affect on the code.  Maybe someone else could look into those three changesets and maybe eye the issue?  I'll keep trying in a bit but I've got other work to get done right now.

For the record, I CAN still find Customers, just not Invoices.
Comment 19 Andreas Köhler 2007-06-22 17:44:11 UTC
Fixed by r16201 for GnuCash 2.2.0.
Thanks for the report!

Well, seems like some things should never change ;-)
Comment 20 John Ralls 2018-06-29 21:39:25 UTC
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=448853. Please update any external references or bookmarks.