Re: 1.3RC4 New DB

[Chris Travers <..hidden..>]

On Tue, Oct 4, 2011 at 12:13 AM, Dave Babb <..hidden..> wrote:
> I used the script to delete the database, then launched the setup.pl script from
> the web browser. Here is what happened. This is just an FYI.
>
> I can get back up and running by running the bsah scripts....But you said to use
> one or the other....So I choose to attempt to setup things in the web-browser as
> a test. The roadmap to recreate follows and the results...
>
> a) Used script to remove DB in the 'orthodox' fashion. Told the script to remove
> the ledgersmb and admin users at the same time.
> b) Went to '/var/loag/apache2' and deleted the error.log file.
> c) Restarted Apache2.
> d) "su postgres" verified that ledgersmb and admin did not exist, neither did
> the "aci" database.
> e) createuser -d -P admin:admin, superuser "y".
> f) Restarted postgresql.
> g Logged in with "admin:admin:aci"
> h) Was prompted "Database does not exist. Create Database?. I answered yes and
> then pressed next. The HDD in the VM got busy for a while
> f) I selected the country code of US. Pressed next.
> g) Selected "Manufacturing.sql", pressed Next.
> h) the following error in the web browser:
>
> 42883:ERROR: function public.person__list_salutations() does not exist
> LINE 1: SELECT * FROM "public"."person__list_salutations"() ^ HINT: No function
> matches the given name and argument types. You might need to add explicit type
> casts.
>
>
> Contents of the apache2 'error.log":
>
> [Tue Oct 04 01:08:42 2011] [notice] Apache/2.2.16 (Debian) configured --
> resuming normal operations
> DBI connect('dbname=aci','admin',...) failed: FATAL:  database "aci" does not
> exist at LedgerSMB/Database.pm line 181
> Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db
> handle dbname=template1 at scripts/setup.pl line 57.
> DBD::Pg::st execute failed: ERROR:  function public.person__list_salutations()
> does not exist
> LINE 1: SELECT * FROM "public"."person__list_salutations"()
>                      ^
> HINT:  No function matches the given name and argument types. You might need to
> add explicit type casts. at LedgerSMB.pm line 781.
> 2011/10/04 01:10:56 - ERROR Logging SQL State 42883, error 7, string ERROR:
> function public.person__list_salutations() does not exist
> LINE 1: SELECT * FROM "public"."person__list_salutations"()
>                      ^
> HINT:  No function matches the given name and argument types. You might need to
> add explicit type casts.
> ERROR - Logging SQL State 42883, error 7, string ERROR:  function
> public.person__list_salutations() does not exist
> LINE 1: SELECT * FROM "public"."person__list_salutations"()
>                      ^
> HINT:  No function matches the given name and argument types. You might need to
> add explicit type casts.
> [Tue Oct 04 01:11:00 2011] [error] [client 127.0.0.1] File does not exist:
> /var/www/favicon.ico
>
Could you include the following files here:
/tmp/dblog
/tmp/dblog_stderr
/tmp/dblog_stdout

if not there, try creating a new db and if the same error occurs
attach those files.

Best Wishes,
Chris Travers