Hi all:
I'm trying to get my first install of LedgerSMB running, but am failing in the setting up a company DB phase. First, here's the background info:
I'm running Linux Mint Debian Edition, which is 100% compatible with latest Debian (sorry, I never can stay in tune with the debian names).
I have version 1.3.18-2 installed from the repos. Installation is complete and appeared to complete without any issues. I'm running it against Postgres 9.1 (already installed for other applications).
I'm trying the instructions at:
I've gotten the
setup.pl running, and get part way through the wizzard until it prompts for loading general.sql, or select from a few others (including manufacturing.sql or service.sql). I click next, and I get a server error. My apache logs show:
[Mon Jul 08 15:41:13 2013] [error] [client ::1] 2013/07/08 15:41:13 - INFO - LedgerSMB::Scripts::setup::create_db -- create_and_load rc=1, referer:
http://localhost/ledgersmb/setup.pl
[Mon Jul 08 15:41:24 2013] [error] [client ::1] DBD::Pg::st execute failed: ERROR: function public.person__list_salutations() does not exist, referer:
http://localhost/ledgersmb/setup.pl
[Mon Jul 08 15:41:24 2013] [error] [client ::1] HINT: No function matches the given name and argument types. You might need to add explicit type casts. at LedgerSMB.pm line 828., referer:
http://localhost/ledgersmb/setup.pl
[Mon Jul 08 15:41:24 2013] [error] [client ::1] 2013/07/08 15:41:24 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1085) -- Logging SQL State 42883, error 7, string ERROR: function public.person__list_salutations() does not exist, referer:
http://localhost/ledgersmb/setup.pl
[Mon Jul 08 15:41:24 2013] [error] [client ::1] HINT: No function matches the given name and argument types. You might need to add explicit type casts., referer:
http://localhost/ledgersmb/setup.pl
[Mon Jul 08 15:41:24 2013] [error] [client ::1] Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=pts at /usr/share/ledgersmb/
setup.pl line 8., referer:
http://localhost/ledgersmb/setup.pl
[Mon Jul 08 15:41:24 2013] [error] [client ::1] File does not exist: /var/www/favicon.ico
I asked on the irc channel, and only chris___ came back, and said he got the same thing following the ubuntu install tutorial.
How do I get past this?
Thanks!
--Jim