Hi Chris,
On May 16, 2013 12:53 AM, "Chris Calef" <..hidden..> wrote:
>
> Thanks again, Erik! Unfortunately, still not quite there yet... but we're getting closer!
Thanks for hanging in!
>
> Here are my current errors:
>
> psql:sql/modules/EndOfYear.sql:28: ERROR: function eoy_reopen_books(date) does not exist
> LINE 6: SELECT eoy_reopen_books(end_date)
>
This one had to do with function ordering in EndOfYear.sql. Adjustment committed.
> ---------------------------------------------------------------------------------
>
> psql:sql/modules/Inventory_Report.sql:44: ERROR: column l.report_id does not exist
> LINE 9: JOIN inventory_report_line l ON l.report_id = r.id
The table inventory_report_line contains a field adjust_id which refers to inventory_report.id (which is the same as the r.id above). Adjustment committed.
> ---------------------------------------------------------------------------------
>
> psql:sql/modules/Transaction_Templates.sql:70: NOTICE: type "journal_search_result" does not exist, skipping
> DROP TYPE
This error is harmless; actually, it's a notice (something that is being dropped/discarded already doesn't exist).
> psql:sql/modules/Transaction_Templates.sql:83: ERROR: syntax error at or near ")"
> LINE 13: );
There was a comma too much in the structure definition. Adjustment committed.
>
> ---------------------------------------------------------------------------------
>
> psql:sql/modules/Goods.sql:372: ERROR: column "id" does not exist
> LINE 4: SELECT * FROM inventory_report_line l WHERE id = $1
>
Ok. The inventory report lines don't have a report_id or id field; they have an adjust_id field (same issue as above).
> ---------------------------------------------------------------------------------
>
> psql:/tmp/ledgersmb/lsmb_roles.sql:1423: ERROR: function admin__list_roles(text) does not exist
The referenced function doesn't exist in our code base. Removed.
All of the changes committed in r5812.
If there's more to be fixed, let me know!
(I don't have 9.1 myself, or I would have run the tests and fixed anything that's still left.)
Bye,
Erik.