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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
