Re: A little trouble installing 1.4.

Hi Chris,

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

Fixed this one and found another one (just by inspecting the code).

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);

Found a spurious semicolon. Removed. That should fix it.

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

I'll do these in the course of the day: I want to be sure to remove the right bits in that table.

Bye,

Erik.