[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Errors encountered on first install of LSMB 1.3 Beta 1
- Subject: Errors encountered on first install of LSMB 1.3 Beta 1
- From: Hugh Esco <..hidden..>
- Date: Tue, 15 Dec 2009 02:14:04 -0500
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(); }