Re: A little trouble installing 1.4.

Hi again,

>Thanks for hanging in!

No problem, thanks for the help!

Still got quite a few errors, although you fixed several with that round...

There was one more report_id vs adjust_id problem in Inventory_Report.sql, line 53, fixed that myself but you'll want to do it in the repo:

psql:sql/modules/Inventory_Report.sql:58: ERROR: column l.report_id does not exist
LINE 8: JOIN inventory_report_line l ON l.report_id = r.id

Then, Transaction_Templates.sql had this now:

psql:sql/modules/Transaction_Templates.sql:134: ERROR: missing "LOOP" at end of SQL _expression_
LINE 22: j.transaction_date);

Goods.sql is fixed now.

Still having trouble with some more of those menu_node ids. I'll just summarize them here with the bad node id, they are all in my lsmb_roles.sql:

DETAIL: Key (node_id)=(28) is not present in table "menu_node".
DETAIL: Key (node_id)=(29) is not present in table "menu_node".
DETAIL: Key (node_id)=(17) is not present in table "menu_node".
DETAIL: Key (node_id)=(18) is not present in table "menu_node".
DETAIL: Key (node_id)=(87) is not present in table "menu_node".
DETAIL: Key (node_id)=(88) is not present in table "menu_node".
DETAIL: Key (node_id)=(89) is not present in table "menu_node".

DETAIL: Key (node_id)=(90) is not present in table "menu_node".
DETAIL: Key (node_id)=(93) is not present in table "menu_node".
DETAIL: Key (node_id)=(94) is not present in table "menu_node".

DETAIL: Key (node_id)=(220) is not present in table "menu_node".
DETAIL: Key (node_id)=(221) is not present in table "menu_node".

And that's it! I think we're getting closer!!

Chris C

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

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel