Comment 5 for bug 1850547

Revision history for this message
Mike Risher (mrisher) wrote :

I gave this a look. Some of the testing wasn't as thorough as I'd like, due to some problems using some interfaces. For instance, I wasn't able to set a Payment type on a newly created invoice even when I verified the "Invoice Item Types" had the payment type I was trying to add.

From what testing I managed to do, I see 4 issues:

1. On the 4 tabs used for navigation, one tab says "Inovices Search" s/b "Invoices Search"

2. Beneath the 4 tabs there is a grey box for entering search terms. On the top right of this box is an arrow used to hide the form or show the form. That arrow is invisible to my screen reader (NVDA) and it gets skipped right over when tabbing through the interface. I believe this is because it's using an <a> html tag, but the tag is missing an "href" attribute.

3. I wasn't able to set a default search on any of the 4 tabs. Trying to set a default line item search gives this error:

ERROR Error: Uncaught (in promise): No user or workstation setting type exists for: "eg.acq.search.default.lineitems".
Create a ws/user setting type or use setLocalItem() to store the value locally.

Trying to set a default invoice search gives this error:
ERROR Error: Uncaught (in promise): No user or workstation setting type exists for: "eg.acq.search.default.invoices".
Create a ws/user setting type or use setLocalItem() to store the value locally.

4. Whenever I visit the "Purchase Orders Search" tab I get 3 console errors. I don't run into this on any other tab. Here's the 3 errors:

main.a0af4c705f18a7e99990.js:1 open-ils.pcrud.retrieve.acqpostlbl failed! stat=500 msg=Severe query error -- see error log for more details

open-ils.pcrud.retrieve.acqpostlbl failed! stat=404 msg=An unknown server error occurred

ERROR open-ils.pcrud.retrieve.acqpostlbl failed! stat=500 msg=Severe query error -- see error log for more details

The error logs tell me this:

"2020-08-20 22:52:50 kcls-icelandic open-ils.pcrud: [ERR :3288:oils_sql.c:7047:1597963968363013] open-ils.pcrud ERROR No "datatype" attribute for field "id"
2020-08-20 22:52:50 kcls-icelandic open-ils.pcrud: [ERR :3288:oils_sql.c:7047:1597963968363013] open-ils.pcrud ERROR No "datatype" attribute for field "id"
2020-08-20 22:52:50 kcls-icelandic open-ils.pcrud: [ERR :3288:oils_sql.c:6049:1597963968363013] open-ils.pcrud: Error retrieving acq::po_state_label with query [SELECT "acqpostlbl".id, oils_i18n_xlate('acq.po_state_label', 'acqpostlbl', 'label', 'id', "acqpostlbl".id::TEXT, 'en-US') AS "label" FROM acq.po_state_label AS "acqpostlbl" WHERE "acqpostlbl".id = 'on-order';]: 6844177 6844177: ERROR: relation "acq.po_state_label" does not exist
LINE 1: ..., "acqpostlbl".id::TEXT, 'en-US') AS "label" FROM acq.po_sta..."