Errors encountered on first install of LSMB 1.3 Beta 1

[Hugh Esco <..hidden..>]

Did not reach the finish line.
I'm wondering if I need pg 8.3, instead of 8.1.

-- Hugh 

first glitch in install so far: perl Makefile.PL gets me: Can't locate inc/Module/Install.pm in @INC

@INC includes .

but $LSMB_INSTALL_DIR includes no inc/

well I found this: 
/usr/local/share/perl/5.8.8/inc/Module/Install.pm, 
however perl -v says  v5.10.0 and no similiar animal exists.

that's a funny name for a module, but 
cpan[2]> install inc::Module::Install 
did the trick.

unimpeded progress until this one blew up in my face:

$ psql -U postgres -d ymd_lsmb_13 -f /usr/local/ledgersmb13/sql/coa/us/chart/General.sql
BEGIN
psql:/usr/local/ledgersmb13/sql/coa/us/chart/General.sql:5: ERROR:  function account_heading_save("unknown", "unknown", "unknown", "unknown") does not exist
HINT:  No function matches the given name and argument types. You may need to add explicit type casts.

So I skipped for the moment loading the CoA.

Then I see the following errors when invoking this:

$ psql -U postgres -d ymd_lsmb_13 -f ymd_lsmb_13_roles.sql

psql:ymd_lsmb_13_roles.sql:31: ERROR:  function eca__list_notes(integer) does not exist
INSERT 0 1

<snip>

GRANT
psql:ymd_lsmb_13_roles.sql:63: ERROR:  syntax error at or near "note_id_seq" at character 23
psql:ymd_lsmb_13_roles.sql:63: LINE 1: GRANT ALL ON SEQUENCE note_id_seq TO "lsmb_ymd_lsmb_13__cont...
psql:ymd_lsmb_13_roles.sql:63:                               ^
GRANT

<snip>

CREATE ROLE
psql:ymd_lsmb_13_roles.sql:1397: ERROR:  function admin__add_user_to_role(text, text) does not exist
psql:ymd_lsmb_13_roles.sql:1399: ERROR:  function admin__remove_user_from_role(text, text) does not exist
psql:ymd_lsmb_13_roles.sql:1401: ERROR:  function admin__add_function_to_group(text, text) does not exist
psql:ymd_lsmb_13_roles.sql:1403: ERROR:  function admin__remove_function_from_group(text, text) does not exist
psql:ymd_lsmb_13_roles.sql:1405: ERROR:  function admin__get_roles_for_user(integer) does not exist
psql:ymd_lsmb_13_roles.sql:1407: ERROR:  function admin__save_user(integer, integer, text, text) does not exist
psql:ymd_lsmb_13_roles.sql:1409: ERROR:  function admin__create_group(text) does not exist
psql:ymd_lsmb_13_roles.sql:1411: ERROR:  function admin__delete_user(text) does not exist
psql:ymd_lsmb_13_roles.sql:1413: ERROR:  function admin__list_roles(text) does not exist
psql:ymd_lsmb_13_roles.sql:1415: ERROR:  function admin__delete_group(text) does not exist
GRANT

<snip>

GRANT
psql:ymd_lsmb_13_roles.sql:1425: ERROR:  relation "user_listable" does not exist
GRANT

<snip>

GRANT
psql:ymd_lsmb_13_roles.sql:1449: ERROR:  function user__get_all_users() does not exist
CREATE ROLE
GRANT
CREATE ROLE
psql:ymd_lsmb_13_roles.sql:1464: ERROR:  function voucher__delete(integer) does not exist
psql:ymd_lsmb_13_roles.sql:1467: ERROR:  function batch_delete(integer) does not exist

Next obstacle makes me wonder if I should have upgraded to pg 8.3:

psql -U postgres -d ymd_lsmb_13 -t -c "INSERT INTO entity (name, entity_class, created) VALUES ('lsmb', 3, NOW()) RETURNING name, entity_class, created;"
ERROR:  syntax error at or near "RETURNING" at character 76
LINE 1: ... entity_class, created) VALUES ('lsmb', 3, NOW()) RETURNING ...
                                                             ^
Trying it this way:

psql -U postgres -d ymd_lsmb_13 -t -c "INSERT INTO entity (name, entity_class, created) VALUES ('lsmb', 3, NOW());"
ERROR:  null value in column "control_code" violates not-null constraint

gives me another error . . . 


And with that, it seems I may have littered my path with a few too many errors to recover from.  

I will try again on the other side of some sleep and perhaps my client's deadlines.

-- 
Hugh Esco 
http://www.CampaignFoundations.com/

if( $insurance->rationing() ) { $people->die(); }