Re: Database creation errors?

["Chris Travers" <..hidden..>]

This sounds like the Pg-database.sql did not import smoothly for some reason.

Most likely reason is that plpgsql may not be available.  To correct this, you can log in as the db superuser (usually "postgres") and run the command:
create language plpgsql;

Then try to run the db import scripts again.  If that doesn't work, I will have you log the error messages and send them to the list :-)

Best Wishes,
Chris Travers

On 7/26/07, Chris Hines <..hidden..> wrote:

Hello,
I've been trying to get ledgersmb-1.2.7 up running and having some
issues.  I upgraded my postgresql from 7.4 to 8.2, no issues there.  I
had sql-ledger running but ledgersmb looked like a more attractive
choice and I had not entered any data so I just dumped the db and
reinstalled.  I get no errors when I run "psql -U ledgersmb -d ledgersmb
-f Pg-central.sql" with the exception of some notices in my syslog.
However when I try to add my first user I get errors on my apache log
and pgsql logs stating relation to "employee" does not exist.  And if I
run "psql -U ledgersmb -d ledgersmb" and execute the same command
"SELECT id FROM employee WHERE login = 'chines';" I get the same result
(Der).  If anyone could shine some light on the situation I would be
very grateful!


DBD::Pg::st execute failed: ERROR:  relation "employee" does not exist
DBD::Pg::st fetchrow_array failed: no statement executing
DBD::Pg::st execute failed: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
DBD::Pg::st fetchrow_array failed: no statement executing
DBD::Pg::st execute failed: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
Can't call method "dberror" without a package or object reference at
LedgerSMB/Form.pm line 3034.
Compilation failed in require at /usr/local/ledgersmb/admin.pl line 91.
[Thu Jul 26 13:36:13 2007] [error] [client 192.168.10.1] Premature end
of script headers: /usr/local/ledgersmb/admin.pl

--
Chris Hines
..hidden..


-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>   http://get.splunk.com/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users