Re: 42883:ERROR function does not exist

[apallik <..hidden..>]

Chris Travers-5 wrote
> 
> On Thu, Apr 5, 2012 at 12:10 PM, apallik <apallik@> wrote:
> 
>>
>>
>> Just looked through the error log file again and the apache log files and
>> it
>> turns out that the problem occurs with psql command not found. Even
>> though
>> when I do echo$ PATH is see that my path is set correctly and when I call
>> psql from terminal it responds, it seems not to identify the command when
>> called through the Database.pm file that creates the new database. Hope
>> this
>> helps
>>
> It does.
> 
> Try setting PATH variables in your ledgersmb.conf.
> 
> Best Wishes,
> Chris Travers
> 
> ------------------------------------------------------------------------------
> For Developers, A Lot Can Happen In A Second.
> Boundary is the first to Know...and Tell You.
> Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
> http://p.sf.net/sfu/Boundary-d2dvs2
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> 

Ok this worked, but now I am getting some other ERRORs and NOTICE in the
dblog_stderr

I will start only with the errors as I think that they are affecting the
rest

/Library/PostgreSQL/9.1/share/postgresql/extension/pg_trgm.sql: No such file
or directory/Library/PostgreSQL/9.1/share/postgresql/extension/tsearch2.sql:
No such file or directory
/Library/PostgreSQL/9.1/share/postgresql/extension/tablefunc.sql: No such
file or directorypsql:sql/Pg-database.sql:1: ERROR:  language "plpgsql"
already exists

When I look in the directory I have pg_trgm--1.0.sql and the same for the
rest of the files. Actually all sql files are *--1.0.sql. Not sure if this
is causing the error (Database.pm has pg_trgm tsearch2 tablefunc instead of
pg_trgm--1.0 etc).  There is also a pg_trgm.control file (same for other
scripts) which I am not sure if these are the ones called from Database.pm. 

Moreover, when I checked the Database.pm file it also says :

my @contrib_scripts = qw(pg_trgm tsearch2 tablefunc);
    if($ENV{PG_CONTRIB_DIR})
    {
     #postgres 9.1 this is done by create extension pg_trgm btree_gist ..
     for my $contrib (@contrib_scripts){
         $rc2=system("psql -f $ENV{PG_CONTRIB_DIR}/$contrib.sql >>
$temp/dblog_stdout 2>>$temp/dblog_stderr");

I am not sure what you mean by 
#postgres 9.1 this is done by create extension pg_trgm btree_gist?
Finally, I cannot locate contrib.sql in the extension directory (not sure if
this is needed since it is mentioned in the above Database.pm lines.

Even though I am getting the errors, I have managed to create the database
and a user however when I load to ledgersmb/login.pl and login, it seems
that I do not have full functionality (ie cannot create any accounts for
company, AR, AP etc).


--
View this message in context: http://ledger-smb.1045705.n5.nabble.com/42883-ERROR-expected-1-3-12-error-tp5556135p5622352.html
Sent from the Ledger SMB - Users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users