[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Setup.pl fails on database setup on new installation

On Fri, Nov 4, 2011 at 11:11, Steven Marshall
<..hidden..> wrote:
> I have brand new installation of 1.3.3 with I believe all prereqs.
> 1. Created Postgresql superuser "ledgersmb"
> 2. From browser navigate to http://localhost/ledgersmb/setup.pl
> 3. On setup.pl screen enter ledgersmb/password/foo for SuperUser Credentials
> and click Login button
> 4. On the Confirm Operation screen I select "Yes" to create database and
> click Next
> 5. On the Database Management Console screen select Country Code "Br" and
> click Next

Did you check that you have postgresql-contrib (psql-contrib) and
enter your contrib (extension) directory location?

> 6. On next screen select General.sql and click Next
> Results:
> Error!
> 42883:ERROR: function public.person__list_salutations() does not exist
> HINT: No function matches the given name and argument types. You may need to
> add explicit type casts.

database load is incomplete or non-existent -- functions didn't get
created.  this can happen if you don't have contribs (extensions) or
didn't specify the correct directory (among other things)

> I opened a bug on this, but wanted to see if anybody in the community has
> already figured this out.
> Best Regards,
> Steven Marshall
> Sent from my iPad
> ------------------------------------------------------------------------------
> RSA(R) Conference 2012
> Save $700 by Nov 18
> Register now
> http://p.sf.net/sfu/rsa-sfdev2dev1
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

David A. Bandel
Two things are infinite: the universe and human stupidity; and I'm not
sure about the the universe. -- Albert Einstein
Visit my web page at: http://david.bandel.us/